Re: [table] strange behaviour
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 49926
interpreted = N
texte = The $ didn't make any difference. So I tried the only thing that'sdifferent between yours and mine: i changed neskudata=find_all toneskudata=[blank]... and... it worked.How weird is that!If that's not a bug...Regards,Tim-- Tim RobinsonIDFK Web Developmentstim@idfk.com.au114a/40 Yeo StreetNeutral Bay 2089AustraliaPhone +612 9908 2134Fax +612 9908 4837> From: WJ Starck
> Reply-To: (WebDNA Talk)> Date: Wed, 30 Apr 2003 21:31:53> To: (WebDNA Talk)> Subject: Re: [table] strange behaviour> > HTML escape codes.> > $ would be $> > Here's a good reference:> > http://www.tangent.org/~brian/dict/ascii-codes.html> > I 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 Starck> NovaDerm Skincare Science> http://www.novaderm.com> wjs@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/> -------------------------------------------------------------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:
The $ didn't make any difference. So I tried the only thing that'sdifferent between yours and mine: i changed neskudata=find_all toneskudata=[blank]... and... it worked.How weird is that!If that's not a bug...Regards,Tim-- Tim RobinsonIDFK Web Developmentstim@idfk.com.au114a/40 Yeo StreetNeutral Bay 2089AustraliaPhone +612 9908 2134Fax +612 9908 4837> From: WJ Starck > Reply-To: (WebDNA Talk)> Date: Wed, 30 Apr 2003 21:31:53> To: (WebDNA Talk)> Subject: Re: [table] strange behaviour> > HTML escape codes.> > $ would be $> > Here's a good reference:> > http://www.tangent.org/~brian/dict/ascii-codes.html> > I 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 Starck> NovaDerm Skincare Science> http://www.novaderm.com> wjs@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/> -------------------------------------------------------------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/
Tim Robinson
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] Handling passwords in WebDNA (2010)
Shopping Cart Problem (1998)
WebCatalog Use Question (1997)
Pop-Up Redirects (1998)
MacAuthorize and WebMerchant (1997)
RE: textarea question (1998)
Netscape Cache and Linux (2001)
[WebDNA] Snow Leoopard and v7 (2011)
[OT] Form Check java problem (2003)
WebCatalog Mac and cgi-bin (WebSTAR 2.0) (1997)
More on the email templates (1997)
emailer on Windows Beta 18 (1997)
[SearchString] problem with [search] context (1997)
RE: protect tag not working (1998)
[WebDNA] Encrypted password issue (2009)
Re:2nd WebCatalog2 Feature Request (1996)
Country & Ship-to address & other fields ? (1997)
grouping fields (1999)
MacActivity and PCS (1997)
Autoreturn Submit? (1997)