Re: [WebDNA] v 7 append

This WebDNA talk-list message is from

2012


It keeps the original formatting.
numero = 108469
interpreted = N
texte = --Apple-Mail-12--119171164 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=us-ascii Small test that works fine with your code. --Apple-Mail-12--119171164 Content-Disposition: attachment; filename=testme.dna Content-Type: application/octet-stream; name="testme.dna" Content-Transfer-Encoding: 7bit WebDNA Performance Test [!] ##Check for the Database first - create it if not there--[/!] [showif T=[fileinfo file=speed.db][exists][/fileinfo]] [closedatabase db=speed.db] [deletefile file=speed.db] [/showif] [showif F=[fileinfo file=speed.db][exists][/fileinfo]] [writefile file=speed.db]skuvalue1value2value3 [/writefile] [/showif] [!] ##Delete the records in the DB to ensure the search is 'clean'--[/!] [delete db=speed.db&neSKUdata=find_all]                  [text show=F]one=bcbcbcbcbcbcbcbcbcb[/text] [text show=F]two=jgjgjgjgjgjgjgjgjgj[/text] [text show=F]three=azazazazazazazaza[/text]  [append db=speed.db]sku=101&[!] [/!]value1=[url][one][/url]&[!] [/!]value2=[url][two][/url]&[!] [/!]value3=[url][three][/url] [/append]     
(seconds) This Task
 
 
Open a database (4 fields), append 100 records [Math time]{[time]}-{[start_time]}[/Math]
Show the records [search db=speed.db&neSKUdata=find_all&SKUtype=num&SKUsort=1] [founditems] [index] - [value1] - [value2] - [value3]
[/founditems] [/search]		[Math time]{[time]}-{[start_time]}[/Math]
--Apple-Mail-12--119171164 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii - chris On Feb 2, 2012, at 21:47, Rob wrote: >=20 > On Feb 2, 2012, at 5:39 PM, Govinda wrote: >=20 >>>=20 >>> I think I need a drink...or three.... >>>=20 >>> I have a test section that works just fine on 6.2, but when I move = it over to 7, it refuses to append to the db, and is not returning any = errors. The code: >>>=20 >>> [append db=3Dsome.db]one=3D[URL][one][/URL]&[!] >>> [/!]two=3D[URL][two][/URL][!] >>> [/!]three=3D[URL][three][URL] >>> [/append] >>>=20 >>> At first I was getting a permission error, so I set it to 777 with = user:group www. I've tried flushing everything, restarting apache, you = name it. Has something changed in 7, or is my dev server haunted... >>=20 >> that is basic code that should work on 7, or any version. >> But you forgot a "&" char... to separate what you write into the = [two] field and the [three] field, and your wrapper around the value for = the [three] field's value is not right. >>=20 >> -G--------------------------------------------------------- >=20 > I just went back and looked at the actual code, and its ok. I had just = typed that quickly, cause its a lot of fields. I also have all the = fields writing to the page that does the appending, so I could check to = make sure all fields were operational. The exact same page works fine = and appends in 6.2, so I'll do some digging somewhere else, and see if I = can track it down... I didn't think there were any differences in 7, but = had to check.... thanks... >=20 > Rob >=20 >=20 >=20 > --------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us > Bug Reporting: support@webdna.us --Apple-Mail-12--119171164-- Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] v 7 append (Rob 2012)
  2. Re: [WebDNA] v 7 append (William DeVaul 2012)
  3. Re: [WebDNA] v 7 append (Rob 2012)
  4. Re: [WebDNA] v 7 append (Rob 2012)
  5. Re: [WebDNA] v 7 append (christophe.billiottet@webdna.us 2012)
  6. Re: [WebDNA] v 7 append (Rob 2012)
  7. Re: [WebDNA] v 7 append (Govinda 2012)
  8. [WebDNA] v 7 append (Rob 2012)
--Apple-Mail-12--119171164 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=us-ascii Small test that works fine with your code. --Apple-Mail-12--119171164 Content-Disposition: attachment; filename=testme.dna Content-Type: application/octet-stream; name="testme.dna" Content-Transfer-Encoding: 7bit WebDNA Performance Test [!] ##Check for the Database first - create it if not there--[/!] [showif T=[fileinfo file=speed.db][exists][/fileinfo]] [closedatabase db=speed.db] [deletefile file=speed.db] [/showif] [showif F=[fileinfo file=speed.db][exists][/fileinfo]] [writefile file=speed.db]skuvalue1value2value3 [/writefile] [/showif] [!] ##Delete the records in the DB to ensure the search is 'clean'--[/!] [delete db=speed.db&neSKUdata=find_all]                  [text show=F]one=bcbcbcbcbcbcbcbcbcb[/text] [text show=F]two=jgjgjgjgjgjgjgjgjgj[/text] [text show=F]three=azazazazazazazaza[/text]  [append db=speed.db]sku=101&[!] [/!]value1=[url][one][/url]&[!] [/!]value2=[url][two][/url]&[!] [/!]value3=[url][three][/url] [/append]     
(seconds) This Task
 
 
Open a database (4 fields), append 100 records [Math time]{[time]}-{[start_time]}[/Math]
Show the records [search db=speed.db&neSKUdata=find_all&SKUtype=num&SKUsort=1] [founditems] [index] - [value1] - [value2] - [value3]
[/founditems] [/search]		[Math time]{[time]}-{[start_time]}[/Math]
--Apple-Mail-12--119171164 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii - chris On Feb 2, 2012, at 21:47, Rob wrote: >=20 > On Feb 2, 2012, at 5:39 PM, Govinda wrote: >=20 >>>=20 >>> I think I need a drink...or three.... >>>=20 >>> I have a test section that works just fine on 6.2, but when I move = it over to 7, it refuses to append to the db, and is not returning any = errors. The code: >>>=20 >>> [append db=3Dsome.db]one=3D[url][one][/URL]&[!] >>> [/!]two=3D[url][two][/URL][!] >>> [/!]three=3D[url][three][url] >>> [/append] >>>=20 >>> At first I was getting a permission error, so I set it to 777 with = user:group www. I've tried flushing everything, restarting apache, you = name it. Has something changed in 7, or is my dev server haunted... >>=20 >> that is basic code that should work on 7, or any version. >> But you forgot a "&" char... to separate what you write into the = [two] field and the [three] field, and your wrapper around the value for = the [three] field's value is not right. >>=20 >> -G--------------------------------------------------------- >=20 > I just went back and looked at the actual code, and its ok. I had just = typed that quickly, cause its a lot of fields. I also have all the = fields writing to the page that does the appending, so I could check to = make sure all fields were operational. The exact same page works fine = and appends in 6.2, so I'll do some digging somewhere else, and see if I = can track it down... I didn't think there were any differences in 7, but = had to check.... thanks... >=20 > Rob >=20 >=20 >=20 > --------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us > Bug Reporting: support@webdna.us --Apple-Mail-12--119171164-- christophe.billiottet@webdna.us

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

Exclude by date - multiple (1997) inetinfo.exe (1999) Need relative path explanation (1997) WebCat2b13 Command Reference Doc error (1997) Emailer choke (1997) [OT] Xserve (2002) ShowIf & HideIf Question? (1998) 2nd WebCatalog2 Feature Request (1996) about this server and links to who (1997) Testing (2000) Re:listfiles-looking for slick solution (1997) RE: Webcatalog and CyberSTUD (1998) WebCat2b15MacPlugin - [protect] (1997) Wanted: Broader string manipulation functions (1997) Weird NT mail (1998) Problems with Price field (1997) WebCat2b13MacPlugIn - [shownext method=post] ??? (1997) READFILE command? (1998) Enhancement Request for WebCatalog-NT (1996) [TaxableTotal] - not working with AOL and IE (1997)