Re: [table] strange behaviour REAL solution
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 49928
interpreted = N
texte = 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/
Associated Messages, from the most recent to the oldest:
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/
WJ Starck
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 Engine Won't Start (2003)
Passing WebCat data to SSL server (1997)
Emailer (1997)
Backwards list behavior ... (1997)
More on the email templates (1997)
Pithy questions on webcommerce & siteedit (1997)
test mail (2004)
Error Lob.db records error message not name (1997)
Re:Emailer Set Up (1997)
Nesting WebDNA in JavaScript (2003)
2cd pare of eyes. (2001)
WebDNA Windows 5.0 sendmail bug (2003)
Keep away (1997)
OT: Collaborative Browsing (2000)
Search Command, multiple dbs, etc. --further elucidation needed (2000)
Q: writefile and uploads. (1998)
WebCat2b13MacPlugIn - [shownext method=post] ??? (1997)
Couple of questions (1999)
Date search and sendmail (1997)
Requiring that certain fields be completed (1997)