Re: [table] strange behaviour REAL solution

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 49927
interpreted = N
texte = OK. Turns out that the previous solution wasn't actually working, only displaying properly... there IS a difference. When I did a [numFound] it was showing 24 founditems when there should have been only 12. Therefore we have deduced that this below, as previously posted, is not correct:[table name=delivery&fields=sku,price,DESCRIPTION][!] [/!][search db=delivery.db&geskudata=0&asSKUsort=1&SKUtype=num][!] [/!][founditems] [sku] [price] [DESCRIPTION] [/founditems][!] [/!][/search] [/table]And this IS correct: [table name=delivery&fields=sku,price,DESCRIPTION][!] [/!][search db=delivery.db&geskudata=0&asSKUsort=1&SKUtype=num][!] [/!][founditems] [sku] [price] [DESCRIPTION][/founditems][!] <<< ** HERE ** [/!][/search] [/table]The [founditems] needs a cr before the data, just like following a header, and no cr at the end of the data, otherwise it creates double the number of items.Will, you should try and do a [numFound] with yours to see if it says twice the number it should.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: Tim Robinson > Reply-To: (WebDNA Talk) > Date: Thu, 01 May 2003 12:43:54 > To: (WebDNA Talk) > Subject: Re: [table] strange behaviour > > 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/ > ------------------------------------------------------------- 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)
OK. Turns out that the previous solution wasn't actually working, only displaying properly... there IS a difference. When I did a [numFound] it was showing 24 founditems when there should have been only 12. Therefore we have deduced that this below, as previously posted, is not correct:[table name=delivery&fields=sku,price,DESCRIPTION][!] [/!][search db=delivery.db&geskudata=0&asSKUsort=1&SKUtype=num][!] [/!][founditems] [sku] [price] [DESCRIPTION] [/founditems][!] [/!][/search] [/table]And this IS correct: [table name=delivery&fields=sku,price,DESCRIPTION][!] [/!][search db=delivery.db&geskudata=0&asSKUsort=1&SKUtype=num][!] [/!][founditems] [sku] [price] [DESCRIPTION][/founditems][!] <<< ** HERE ** [/!][/search] [/table]The [founditems] needs a cr before the data, just like following a header, and no cr at the end of the data, otherwise it creates double the number of items.Will, you should try and do a [numFound] with yours to see if it says twice the number it should.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: Tim Robinson > Reply-To: (WebDNA Talk) > Date: Thu, 01 May 2003 12:43:54 > To: (WebDNA Talk) > Subject: Re: [table] strange behaviour > > 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/ > ------------------------------------------------------------- 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:

Protecting webdelivery (1997) E-mailer error codes (1997) A multi-processor savvy WebCatalog? (1997) WebCat2: Formulas.db question (1997) Searching a field and returning the highest value (1997) Re:Variable Math (1998) Purchased cart being overwritten - still !?? (1997) Store Builder (2000) searchable list archive (1997) [WebDNA] Does not understand 'search' command? (2014) Non-Cart Files in Shopping Cart Folder (1997) Re[2]: Re[2]: WebCatalog keeps quiting on Solaris, and suppo (2000) Security Issue (2000) encrypt/decrypt failing (2000) TCPSEND (1999) Unknown error: OrderNotCreated (1997) Sort Order on a page search (1997) BannerAds demo (1998) Upgrade Pricing? (2003) RE: Can a database get stomped by simultaneous access? (1997)