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's different between yours and mine: i changed neskudata=find_all to neskudata=[blank]... and... it worked.How weird is that!If that's not a bug...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> 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] > > > > > > > > [/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] >>>> >>>> >>>> >>>> >>>> >>>> [/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] >>>>
[sku]$[price] width=20>[description]
[SKU]$[price][description]
>>>> >>>> >>>> >>>> >>>> >>>> [founditems] >>>> >>>> >>>> >>>> >>>> >>>> [/founditems] >>>>
ZoneChargeDescription
[SKU]$[price][description]
>>>> [/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:

    
  1. Re: [table] strange behaviour REAL solution (Joe D'Andrea 2003)
  2. Re: [table] strange behaviour REAL solution (Tim Robinson 2003)
  3. Re: [table] strange behaviour REAL solution (dbrooke 2003)
  4. Re: [table] strange behaviour REAL solution (Joe D'Andrea 2003)
  5. Re: [table] strange behaviour REAL solution (Tim Robinson 2003)
  6. Re: [table] strange behaviour REAL solution (WJ Starck 2003)
  7. Re: [table] strange behaviour REAL solution (Tim Robinson 2003)
  8. Re: [table] strange behaviour (Tim Robinson 2003)
  9. Re: [table] strange behaviour (WJ Starck 2003)
  10. Re: [table] strange behaviour (Tim Robinson 2003)
  11. Re: [table] strange behaviour (WJ Starck 2003)
  12. [table] strange behaviour (Tim Robinson 2003)
The $ didn't make any difference. So I tried the only thing that's different between yours and mine: i changed neskudata=find_all to neskudata=[blank]... and... it worked.How weird is that!If that's not a bug...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> 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] > > > > > > > > [/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] >>>> >>>> >>>> >>>> >>>> >>>> [/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] >>>>
[sku]$[price] width=20>[description]
[SKU]$[price][description]
>>>> >>>> >>>> >>>> >>>> >>>> [founditems] >>>> >>>> >>>> >>>> >>>> >>>> [/founditems] >>>>
ZoneChargeDescription
[SKU]$[price][description]
>>>> [/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:

Limit to Field Length in DB (1998) Emailer (WebCat2) (1997) RE: Answer: WebDelivery downloads alias, not original ? (1997) 2nd try: possible to weight results of grouped fieldssearch? (1998) nested ListWords? (2003) Problems passing [SKU] with $Replace in 2.0 (1997) Feature req. (2002) test (2004) Two submit buttons ? (1997) forms (2001) Sorting Numbers (1997) real beginner stumped (2000) customizing the color of user's pages (1997) Web* 4.2 (2000) Re:Emailer and encryption (1997) Categories and Sub-categories (2003) AJAX with WebDNA (2006) Major bug report on rootbeer (1997) back button loses cart (2000) Why does this not work? (2002)