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:
Email notification to one of multiple vendors ? (1997)
Emailer Problem (2000)
Text vs. Math (2000)
Snake Bites (1997)
Error Lob.db records error message not name (1997)
Writing to PDF (2003)
browser info.txt and SSL (1997)
Sort Order on a page search (1997)
RAM variables (1997)
shipcost (1997)
Mac Lockup Problems (1998)
Search probl. since change WebCatalog from 2.1.3 to 3.0 (1998)
Multiple fields on 1 input (1997)
Protect (1997)
Date Calulation (1997)
Press Release hit the NewsWire!!! (1997)
Re:One more time (1997)
One Hour Email (2002)
[WebDNA] HTML/OS vs. WebDNA ? (2008)
[OT] HTML render (2003)