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:
WebCat2.0 acgi vs plugin (1997)
Using ticks (2000)
Email Formatting and Encryption (1998)
Nested tags count question (1997)
Encrypting userid for email (2000)
Searching with a form (2000)
RE: ANother SHOWIF problem (1997)
Emailer port change (1997)
RE: Any limit to [include] (1997)
[OT] XServe networking PITA (2004)
HELP WITH DATES (1997)
Re:listfiles-looking for slick solution (1997)
Exclamation point (1997)
OT : Virus (2000)
Help! WebCat2 bug (1997)
WebCat2 - [format thousands] (1997)
different ship dates and shopping carts -- how to? (1997)
Help! WebCat2 bug (1997)
Date stamp and purging (1998)
MATH (1998)