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:
decrypt trouble (2006)
migrating from MacOS to unix (2000)
Search in 2 or more catalogs (1997)
Download capabilities (1997)
taxRate is fine but taxTotal isn't (1997)
totals (1997)
about this server and links to who (1997)
Share cost of training videos! (1998)
Unexpected error (1997)
Just Testing (1997)
Where can I find hex equivalents for ASCII characters? (2000)
[WebDNA] Processor Maxing out (2010)
Time for a hard questions. (1997)
Webten&Webcat (1998)
Help! WebCat2 bug (1997)
WebCat2b15MacPlugin - showing [math] (1997)
Question (1997)
Download URL & access on the fly ? (1997)
plugin-acgi, different results (1997)
Multiple security dbs (1997)