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:

Sku numbers (1997) Bad Cookie (1998) Converting order file to database (1998) Listserver problem (1997) Moment of Thanks (1997) Signal Raised Error (1997) Troubles with Selection Drop Down List Search (1998) Trouble with formula.db (1997) Text data with spaces in them... (1997) Bug or syntax error on my part? (1997) Bug or syntax error on my part? (1997) Keep away (1997) [WebDNA] UTF-8 encoding issues (2010) webcat 2.1 new cart fields - please explain more (1998) Emailer setup (1997) Re:2nd WebCatalog2 Feature Request (1996) Listfiles path bug ... (2005) Re:2nd WebCatalog2 Feature Request (1996) bug in [SendMail] (1997) WebCat (or other) Indexing (1999)