Re: [table] strange behaviour
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 49925
interpreted = N
texte = HTML escape codes.$ would be $Here's a good reference:http://www.tangent.org/~brian/dict/ascii-codes.htmlI 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 StarckNovaDerm Skincare Sciencehttp://www.novaderm.comwjs@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:
HTML escape codes.$ would be $Here's a good reference:http://www.tangent.org/~brian/dict/ascii-codes.htmlI 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 StarckNovaDerm Skincare Sciencehttp://www.novaderm.comwjs@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:
Date problems (1997)
What am I missing (1997)
WebCat for Unix?? (1997)
wc 2 pro users - sites, quotes wanted (1997)
list items (1998)
WebCat B13 Mac CGI -- Frames question (1997)
SKU (1997)
Sending order notification by fax (1999)
Where is f2? (1997)
bug ? causes NT event log to fill (1997)
WebCat2b15MacPlugin - [protect] (1997)
Email within tmpl ? (1997)
For those of you not on the WebCatalog Beta... (1997)
Date search and sendmail (1997)
[ShowIf] and empty fields (1997)
php + WebCatalog in same files (2001)
Test (2002)
Code sample - links.tpl (2002)
[Sum] function? (1997)
changing order number (1998)