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:
[WebDNA] DNA suffix (2008)
Showing unopened cart (1997)
[WebDNA] [ReturnRaw] problem (2010)
(2000)
more on prefs not being written (2000)
WebCat2 Append problem (B14Macacgi) (1997)
RAM variables (1997)
Running _every_ page through WebCat-error.html (1997)
[append] vs. [appendfile] delta + question? (1997)
Multi Colonns (1998)
[Sum] function? (1997)
[MATH SHOW=F]. show=f does what? (1999)
Virtual hosting and webcatNT (1997)
5.0 features (2001)
[shownext] (2002)
Re:Encyption mail was Suggestions for Topics ... (1998)
WebDNA Life Cycle (was Form POSTing with LONG variable) (2007)
Permission Deny (2003)
# fields limited? (1997)
no template caching (1997)