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:

[Fwd: F3 database munching] (1997) [WebDNA] Downloading a .xls file daily (2009) Help name our technology! (1997) How to combine two or more audio format files listed in a WebCat (1999) More on the email templates (1997) [WebDNA] Error 500 with SUMM=T (2017) Not really WebCat (1997) Pass a form (2003) Help! WebCat2 bug (1997) emailer (1997) WebCat .pdf file is still messed up... (2000) [WebDNA] Candidate versions release (2010) Why is my easy [AddLineItems] NOT working?? (2000) why is this line in GeneralStore? (1998) RE: Jimmy Houssen (1998) [SHOWIF]s and empty arguments (1997) Error Log.db --however (1997) [Announce] Newest Commerce Site based on WebCatalog (1997) Secure server question (1997) Cookies (1999)