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:
emailer w/F2 (1997)
Recalculating Shipping Costs (1997)
Re:Review comparison by PC Magazine: Open for On-line Business (1997)
Plugin or CGI or both (1997)
Who owns the code? (2002)
[closeDataBase myDataBase.db] not working? (1997)
off topic - dna snipets (1997)
How do I make this faster???? (2000)
MasterCounter Weirdness -Resolved! (1997)
When is unitShipCost calculated? (1998)
Possible Bug in 2.0b15.acgi (1997)
Include a big block of text (1997)
HomePage Caution (1997)
show all problem (1997)
WebCat2 - [include] tags (1997)
[writefile] (1997)
Getting total number of items ordered (1997)
Execute Applescript (1997)
WebDelivery downloads alias, not original ? (1997)
[WebDNA] OT: How is this being done? Curious. (2009)