Re: [table] strange behaviour REAL solution
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 49929
interpreted = N
texte = Of course, this still doesn't explain why it only happens when the sort is on the PRICE field and not the sku field....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 22:10:27 > To: (WebDNA Talk) > Subject: Re: [table] strange behaviour REAL solution > > Makes sense, but no, I just get one set. > > Hmm... > > > On Wednesday, April 30, 2003, at 10:04 PM, Tim Robinson wrote: > >> 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] >>>> >>>> | [sku] | >>>> | >>>> $[price] | >>>> width=20> | >>>> [description] | >>>>
>>>> [/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] >>>>>>> >>>>>>> | [SKU] | >>>>>>> $[price] | >>>>>>> [description] | >>>>>>>
>>>>>>> [/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] >>>>>>> >>>>>>> >>>>>>> | Zone | >>>>>>> Charge | >>>>>>> Description | >>>>>>>
>>>>>>> [founditems] >>>>>>> >>>>>>> | [SKU] | >>>>>>> $[price] | >>>>>>> [description] | >>>>>>>
>>>>>>> [/founditems] >>>>>>>
>>>>>>> [/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/ >> >> > -- > > 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/
Associated Messages, from the most recent to the oldest:
Of course, this still doesn't explain why it only happens when the sort is on the PRICE field and not the sku field....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 22:10:27 > To: (WebDNA Talk) > Subject: Re: [table] strange behaviour REAL solution > > Makes sense, but no, I just get one set. > > Hmm... > > > On Wednesday, April 30, 2003, at 10:04 PM, Tim Robinson wrote: > >> 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] >>>> >>>> | [sku] | >>>> | >>>> $[price] | >>>> width=20> | >>>> [description] | >>>>
>>>> [/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] >>>>>>> >>>>>>> | [SKU] | >>>>>>> $[price] | >>>>>>> [description] | >>>>>>>
>>>>>>> [/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] >>>>>>> >>>>>>> >>>>>>> | Zone | >>>>>>> Charge | >>>>>>> Description | >>>>>>>
>>>>>>> [founditems] >>>>>>> >>>>>>> | [SKU] | >>>>>>> $[price] | >>>>>>> [description] | >>>>>>>
>>>>>>> [/founditems] >>>>>>>
>>>>>>> [/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/ >> >> > -- > > 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/
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:
[WebDNA] Cheers (2008)
Orderfile context problem (1998)
WC Database Format (1997)
Cleaner URLs (2003)
Mac Lockup Problems (1998)
Re:2nd WebCatalog2 Feature Request (1996)
Apache 2.2 (2007)
Extended [ConvertChars] (1997)
Extended [ConvertChars] (1997)
Date sorting (1997)
[SHOWIF]s and empty arguments (1997)
weird happenings (1997)
[cart] Taxrate - seriously .. (2002)
Pricing based on quantity (2000)
Looking for a Manual (1997)
users change an email address (2002)
Re:Emailer setup (1997)
Implementing Gift Certificates in online store (1998)
[WriteFile] problems (1997)
4.5.1 upgrade? (2003)