Re: [table] strange behaviour REAL solution

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 49927
interpreted = N
texte = OK. Turns out that the previous solution wasn't actually working, only displaying properly... there IS a difference. When I did a [numFound] it was showing 24 founditems when there should have been only 12. Therefore we have deduced that this below, as previously posted, is not correct:[table name=delivery&fields=sku,price,DESCRIPTION][!] [/!][search db=delivery.db&geskudata=0&asSKUsort=1&SKUtype=num][!] [/!][founditems] [sku] [price] [DESCRIPTION] [/founditems][!] [/!][/search] [/table]And this IS correct: [table name=delivery&fields=sku,price,DESCRIPTION][!] [/!][search db=delivery.db&geskudata=0&asSKUsort=1&SKUtype=num][!] [/!][founditems] [sku] [price] [DESCRIPTION][/founditems][!] <<< ** HERE ** [/!][/search] [/table]The [founditems] needs a cr before the data, just like following a header, and no cr at the end of the data, otherwise it creates double the number of items.Will, you should try and do a [numFound] with yours to see if it says twice the number it should.Regards, Tim -- Tim Robinson IDFK Web Developments tim@idfk.com.au 114a/40 Yeo Street Neutral Bay 2089 Australia Phone +612 9908 2134 Fax +612 9908 4837> From: Tim Robinson > Reply-To: (WebDNA Talk) > Date: Thu, 01 May 2003 12:43:54 > To: (WebDNA Talk) > Subject: Re: [table] strange behaviour > > The $ didn't make any difference. So I tried the only thing that's > different between yours and mine: i changed neskudata=find_all to > neskudata=[blank]... and... it worked. > > How weird is that! > > If that's not a bug... > > Regards, > Tim > -- > Tim Robinson > IDFK Web Developments > tim@idfk.com.au > 114a/40 Yeo Street > Neutral Bay 2089 > Australia > Phone +612 9908 2134 > Fax +612 9908 4837 > >> From: WJ Starck >> Reply-To: (WebDNA Talk) >> Date: Wed, 30 Apr 2003 21:31:53 >> To: (WebDNA Talk) >> Subject: Re: [table] strange behaviour >> >> HTML escape codes. >> >> $ would be $ >> >> Here's a good reference: >> >> http://www.tangent.org/~brian/dict/ascii-codes.html >> >> I doubt that's it though. >> >> I was having problems with [table] earlier today, turns out I had some >> extra in my HTML. >> >> This code worked for me for your example: >> >> [table name=products&fields=sku,price,description][!] >> [/!][search db=../catalog.db&neskudata=[blank]][!] >> [/!][founditems] >> [sku] [price] [description] [!] tabs here between fields [/!] >> [/founditems][!] >> [/!][/search][!] >> [/!][/table] >> >> >> [search table=products&neskudata=[blank]&aspricesort=1] >> [founditems] >> >> >> >> >> >> >> >> [/founditems] >> [/search] >> >> >> On Wednesday, April 30, 2003, at 09:21 PM, Tim Robinson wrote: >> >>> What escape characters? >>> >>> >>>> From: WJ Starck >>>> Reply-To: (WebDNA Talk) >>>> Date: Wed, 30 Apr 2003 21:15:30 >>>> To: (WebDNA Talk) >>>> Subject: Re: [table] strange behaviour >>>> >>>> Have you tried using the escape characters for the $? >>>> >>>> Regards, >>>> >>>> -- >>>> >>>> Will Starck >>>> NovaDerm Skincare Science >>>> http://www.novaderm.com >>>> wjs@novaderm >>>> On Wednesday, April 30, 2003, at 09:12 PM, Tim Robinson wrote: >>>> >>>>> I have created a [table] which has three fields and the results >>>>> display like >>>>> this: >>>>> [founditems] >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> [/founditems] >>>>> >>>>> When the [table] is populated with a [search] of a db, the results >>>>> display >>>>> badly, with an extra row for each founditem which has nothing but '$' >>>>> in it >>>>> (but this only occurs when SORTED by PRICE). If I remove the '$' from >>>>> this >>>>> '$[price]', it doesn't occur. >>>>> >>>>> PLUS, if I populate the [table] with the actual DB, rather than from >>>>> a >>>>> search, it works perfectly, whether the $ is there or not! >>>>> >>>>> Any ideas? >>>>> >>>>> Here's the full business if you're really interested: >>>>> >>>>> - - - >>>>> >>>>> [table name=delivery&fields=sku,price,DESCRIPTION][!] >>>>> [/!][search >>>>> db=delivery.db&neskudata=find_all&asSKUsort=1&SKUtype=num][!] >>>>> [/!][founditems] >>>>> [sku] [price] [DESCRIPTION] >>>>> [/founditems][!] >>>>> [/!][/search] >>>>> [/table] >>>>> >>>>> [search >>>>> table=delivery&neskudata=find_all&asPRICEsort=1&PRICEtype=num] >>>>>
[sku]$[price] width=20>[description]
[SKU]$[price][description]
>>>>> >>>>> >>>>> >>>>> >>>>> >>>>> [founditems] >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> [/founditems] >>>>>
ZoneChargeDescription
[SKU]$[price][description]
>>>>> [/search] >>>>> >>>>> - - - >>>>> >>>>> Regards, >>>>> Tim >>>>> -- >>>>> Tim Robinson >>>>> IDFK Web Developments >>>>> tim@idfk.com.au >>>>> 114a/40 Yeo Street >>>>> Neutral Bay 2089 >>>>> Australia >>>>> Phone +612 9908 2134 >>>>> Fax +612 9908 4837 >>>>> >>>>> >>>>> >>>>> ------------------------------------------------------------- >>>>> This message is sent to you because you are subscribed to >>>>> the mailing list . >>>>> To unsubscribe, E-mail to: >>>>> To switch to the DIGEST mode, E-mail to >>>>> >>>>> Web Archive of this list is at: http://webdna.smithmicro.com/ >>>>> >>>>> >>>> ..com >>>> >>>> >>>> ------------------------------------------------------------- >>>> This message is sent to you because you are subscribed to >>>> the mailing list . >>>> To unsubscribe, E-mail to: >>>> To switch to the DIGEST mode, E-mail to >>>> >>>> Web Archive of this list is at: http://webdna.smithmicro.com/ >>>> >>> >>> >>> >>> ------------------------------------------------------------- >>> This message is sent to you because you are subscribed to >>> the mailing list . >>> To unsubscribe, E-mail to: >>> To switch to the DIGEST mode, E-mail to >>> >>> Web Archive of this list is at: http://webdna.smithmicro.com/ >>> >>> >> -- >> >> Will Starck >> NovaDerm Skincare Science >> http://www.novaderm.com >> wjs@novaderm.com >> >> >> ------------------------------------------------------------- >> This message is sent to you because you are subscribed to >> the mailing list . >> To unsubscribe, E-mail to: >> To switch to the DIGEST mode, E-mail to >> >> Web Archive of this list is at: http://webdna.smithmicro.com/ >> > > > > ------------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to > > Web Archive of this list is at: http://webdna.smithmicro.com/ > ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: [table] strange behaviour REAL solution (Joe D'Andrea 2003)
  2. Re: [table] strange behaviour REAL solution (Tim Robinson 2003)
  3. Re: [table] strange behaviour REAL solution (dbrooke 2003)
  4. Re: [table] strange behaviour REAL solution (Joe D'Andrea 2003)
  5. Re: [table] strange behaviour REAL solution (Tim Robinson 2003)
  6. Re: [table] strange behaviour REAL solution (WJ Starck 2003)
  7. Re: [table] strange behaviour REAL solution (Tim Robinson 2003)
OK. Turns out that the previous solution wasn't actually working, only displaying properly... there IS a difference. When I did a [numFound] it was showing 24 founditems when there should have been only 12. Therefore we have deduced that this below, as previously posted, is not correct:[table name=delivery&fields=sku,price,DESCRIPTION][!] [/!][search db=delivery.db&geskudata=0&asSKUsort=1&SKUtype=num][!] [/!][founditems] [sku] [price] [DESCRIPTION] [/founditems][!] [/!][/search] [/table]And this IS correct: [table name=delivery&fields=sku,price,DESCRIPTION][!] [/!][search db=delivery.db&geskudata=0&asSKUsort=1&SKUtype=num][!] [/!][founditems] [sku] [price] [DESCRIPTION][/founditems][!] <<< ** HERE ** [/!][/search] [/table]The [founditems] needs a cr before the data, just like following a header, and no cr at the end of the data, otherwise it creates double the number of items.Will, you should try and do a [numFound] with yours to see if it says twice the number it should.Regards, Tim -- Tim Robinson IDFK Web Developments tim@idfk.com.au 114a/40 Yeo Street Neutral Bay 2089 Australia Phone +612 9908 2134 Fax +612 9908 4837> From: Tim Robinson > Reply-To: (WebDNA Talk) > Date: Thu, 01 May 2003 12:43:54 > To: (WebDNA Talk) > Subject: Re: [table] strange behaviour > > The $ didn't make any difference. So I tried the only thing that's > different between yours and mine: i changed neskudata=find_all to > neskudata=[blank]... and... it worked. > > How weird is that! > > If that's not a bug... > > Regards, > Tim > -- > Tim Robinson > IDFK Web Developments > tim@idfk.com.au > 114a/40 Yeo Street > Neutral Bay 2089 > Australia > Phone +612 9908 2134 > Fax +612 9908 4837 > >> From: WJ Starck >> Reply-To: (WebDNA Talk) >> Date: Wed, 30 Apr 2003 21:31:53 >> To: (WebDNA Talk) >> Subject: Re: [table] strange behaviour >> >> HTML escape codes. >> >> $ would be $ >> >> Here's a good reference: >> >> http://www.tangent.org/~brian/dict/ascii-codes.html >> >> I doubt that's it though. >> >> I was having problems with [table] earlier today, turns out I had some >> extra in my HTML. >> >> This code worked for me for your example: >> >> [table name=products&fields=sku,price,description][!] >> [/!][search db=../catalog.db&neskudata=[blank]][!] >> [/!][founditems] >> [sku] [price] [description] [!] tabs here between fields [/!] >> [/founditems][!] >> [/!][/search][!] >> [/!][/table] >> >> >> [search table=products&neskudata=[blank]&aspricesort=1] >> [founditems] >> >> >> >> >> >> >> >> [/founditems] >> [/search] >> >> >> On Wednesday, April 30, 2003, at 09:21 PM, Tim Robinson wrote: >> >>> What escape characters? >>> >>> >>>> From: WJ Starck >>>> Reply-To: (WebDNA Talk) >>>> Date: Wed, 30 Apr 2003 21:15:30 >>>> To: (WebDNA Talk) >>>> Subject: Re: [table] strange behaviour >>>> >>>> Have you tried using the escape characters for the $? >>>> >>>> Regards, >>>> >>>> -- >>>> >>>> Will Starck >>>> NovaDerm Skincare Science >>>> http://www.novaderm.com >>>> wjs@novaderm >>>> On Wednesday, April 30, 2003, at 09:12 PM, Tim Robinson wrote: >>>> >>>>> I have created a [table] which has three fields and the results >>>>> display like >>>>> this: >>>>> [founditems] >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> [/founditems] >>>>> >>>>> When the [table] is populated with a [search] of a db, the results >>>>> display >>>>> badly, with an extra row for each founditem which has nothing but '$' >>>>> in it >>>>> (but this only occurs when SORTED by PRICE). If I remove the '$' from >>>>> this >>>>> '$[price]', it doesn't occur. >>>>> >>>>> PLUS, if I populate the [table] with the actual DB, rather than from >>>>> a >>>>> search, it works perfectly, whether the $ is there or not! >>>>> >>>>> Any ideas? >>>>> >>>>> Here's the full business if you're really interested: >>>>> >>>>> - - - >>>>> >>>>> [table name=delivery&fields=sku,price,DESCRIPTION][!] >>>>> [/!][search >>>>> db=delivery.db&neskudata=find_all&asSKUsort=1&SKUtype=num][!] >>>>> [/!][founditems] >>>>> [sku] [price] [DESCRIPTION] >>>>> [/founditems][!] >>>>> [/!][/search] >>>>> [/table] >>>>> >>>>> [search >>>>> table=delivery&neskudata=find_all&asPRICEsort=1&PRICEtype=num] >>>>>
[sku]$[price] width=20>[description]
[SKU]$[price][description]
>>>>> >>>>> >>>>> >>>>> >>>>> >>>>> [founditems] >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> [/founditems] >>>>>
ZoneChargeDescription
[SKU]$[price][description]
>>>>> [/search] >>>>> >>>>> - - - >>>>> >>>>> Regards, >>>>> Tim >>>>> -- >>>>> Tim Robinson >>>>> IDFK Web Developments >>>>> tim@idfk.com.au >>>>> 114a/40 Yeo Street >>>>> Neutral Bay 2089 >>>>> Australia >>>>> Phone +612 9908 2134 >>>>> Fax +612 9908 4837 >>>>> >>>>> >>>>> >>>>> ------------------------------------------------------------- >>>>> This message is sent to you because you are subscribed to >>>>> the mailing list . >>>>> To unsubscribe, E-mail to: >>>>> To switch to the DIGEST mode, E-mail to >>>>> >>>>> Web Archive of this list is at: http://webdna.smithmicro.com/ >>>>> >>>>> >>>> ..com >>>> >>>> >>>> ------------------------------------------------------------- >>>> This message is sent to you because you are subscribed to >>>> the mailing list . >>>> To unsubscribe, E-mail to: >>>> To switch to the DIGEST mode, E-mail to >>>> >>>> Web Archive of this list is at: http://webdna.smithmicro.com/ >>>> >>> >>> >>> >>> ------------------------------------------------------------- >>> This message is sent to you because you are subscribed to >>> the mailing list . >>> To unsubscribe, E-mail to: >>> To switch to the DIGEST mode, E-mail to >>> >>> Web Archive of this list is at: http://webdna.smithmicro.com/ >>> >>> >> -- >> >> Will Starck >> NovaDerm Skincare Science >> http://www.novaderm.com >> wjs@novaderm.com >> >> >> ------------------------------------------------------------- >> This message is sent to you because you are subscribed to >> the mailing list . >> To unsubscribe, E-mail to: >> To switch to the DIGEST mode, E-mail to >> >> Web Archive of this list is at: http://webdna.smithmicro.com/ >> > > > > ------------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to > > Web Archive of this list is at: http://webdna.smithmicro.com/ > ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ Tim Robinson

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:

Re[2]: POSTing to a secure server ... (2000) RequiredFields and MacOS X Server? (2000) Need relative path explanation (1997) Bug Report, maybe (1997) [WebDNA] WebDNA vs. php war ;-) (2010) Tags on root directory files? (1998) Been meaning to ask... (1997) Appending problem (still) on Solaris (2000) Close-to Comparison Code (1998) list/menus (2000) Associative lookup style? + bit more (1997) WebDNA Grep help wanted (2004) [Sum] function? (1997) More news on 5.0 (2003) PCS Emailer's role ? (1997) DON'T use old cart file! (1997) Running 2 two WebCatalog.acgi's (1996) [CART] inside a [LOOP] (1997) 40,000+ items = mutiple dbs? (1999) Strange intermittent WebDNA problems (2008)