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, onlydisplaying properly... there IS a difference. When I did a [numFound] it wasshowing 24 founditems when there should have been only 12. Therefore we havededuced 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 ofitems.Will, you should try and do a [numFound] with yours to see if it says twicethe number it should.Regards,Tim-- Tim RobinsonIDFK Web Developmentstim@idfk.com.au114a/40 Yeo StreetNeutral Bay 2089AustraliaPhone +612 9908 2134Fax +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/
Associated Messages, from the most recent to the oldest:
OK. Turns out that the previous solution wasn't actually working, onlydisplaying properly... there IS a difference. When I did a [numFound] it wasshowing 24 founditems when there should have been only 12. Therefore we havededuced 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 ofitems.Will, you should try and do a [numFound] with yours to see if it says twicethe number it should.Regards,Tim-- Tim RobinsonIDFK Web Developmentstim@idfk.com.au114a/40 Yeo StreetNeutral Bay 2089AustraliaPhone +612 9908 2134Fax +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/
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:
Protecting webdelivery (1997)
E-mailer error codes (1997)
A multi-processor savvy WebCatalog? (1997)
WebCat2: Formulas.db question (1997)
Searching a field and returning the highest value (1997)
Re:Variable Math (1998)
Purchased cart being overwritten - still !?? (1997)
Store Builder (2000)
searchable list archive (1997)
[WebDNA] Does not understand 'search' command? (2014)
Non-Cart Files in Shopping Cart Folder (1997)
Re[2]: Re[2]: WebCatalog keeps quiting on Solaris, and suppo (2000)
Security Issue (2000)
encrypt/decrypt failing (2000)
TCPSEND (1999)
Unknown error: OrderNotCreated (1997)
Sort Order on a page search (1997)
BannerAds demo (1998)
Upgrade Pricing? (2003)
RE: Can a database get stomped by simultaneous access? (1997)