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:
Using [Include] Context (1999)
New public beta available (1997)
[OT] Australian Dial-Up Access (2006)
WebCatalog 2.0 b 15 mac (1997)
Show if time tags (1997)
autosensing lanague selection (1997)
Separate SSL Server (1997)
Not really WebCat- (1997)
Email and name capture (1999)
WebCatalog for guestbook ? (1997)
Credit Card Number checking (1997)
WebDelivery downloads alias, not original ? (1997)
[shownext max (1997)
Secure Server (1997)
Server Slowdown (1999)
The beginning (1997)
Email (1998)
Renumbering Database Records (1999)
WebCat2b13MacPlugIn - [include] (1997)
WebCat2b13MacPlugIn - more [date] problems (1997)