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:
Is everybody getting all the posts? (2002)
Filemaker Pro and [convertchars] (2000)
NT Email Stops Sending (2000)
The Classifieds template set (2003)
Express Lane (2000)
SKU (1997)
RE: File Uploads (1998)
setting taxable to true (1997)
[showif] / [hideif] (1997)
Generating a random image, but avoiding repeated images. (1999)
[searchString] (1997)
Hiding Email Addresses (2003)
# fields limited? (1997)
[FoundItems] solved - thanks (1997)
Re:quit command on NT (1997)
Function defined inside Scope context (2005)
Credit Card Number checking (1997)
Linux ODBC and the ODBC Bridge (2000)
Shopping cart now good (fixed it) (1997)
Calculate UnitShipCost in Formulas.db (1999)