Re: [table] strange behaviour REAL solution
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 49951
interpreted = N
texte = Hi Joe,You missed the point.There were only ever 12 items in the db. The problem was in creating the table which added the additional lines and therefore the resulting search on the table causing the problem. So taking out a cr when creating the table meant it was created correctly.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: Joe D'Andrea
> Reply-To: (WebDNA Talk) > Date: Thu, 1 May 2003 07:23:48 > To: (WebDNA Talk) > Subject: Re: [table] strange behaviour REAL solution > > At 1:22 PM 5/1/03, Tim Robinson wrote: >> Of course, this still doesn't explain why it only happens when the sort is >> on the PRICE field and not the sku field.... > > Because you have empty records in your database. WebDNA does not > require a CR after a [founditems] in order for the records to display > properly. In fact you can test this by removing your entire > [founditems] context. > > If you just do [search ...][numfound][/search] you will see that the > number of items returned depends on your search criteria and has > nothing to do with what is or isn't in your [founditmes] context or > whether there even is or isn't a [founditems] context. > > This is from a previous post of your's: > At 12:43 PM 5/1/03, Tim Robinson wrote: >> 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. > > Of course it worked. In the first search you're finding all records. > That's why you get 24 records and why the html table appears to > display improperly. But the html table is not displaying > improperly... you're seeing blank records. > > When you change the search parameter in your second try above, you > are saying find all records where the SKU is not equal to [blank] > ..... which is the same as saying find all records that are NOT empty > in the SKU field. You get 12 records and the html table appears (and > is) as expected. > > Your problem is that you have blank records in your database most > likely the result of an incorrect line ending characters for your > operating system(s). > > Good luck. > > ~joe > > -- > ____________________________________________________________ > Joseph D'Andrea ~ http://www.west21.com/ ~ JoeDan@West21.com > WEST21.com Internet services for the 21st Century > webhosting ~ co-location ~ wireless access > WebCat and MGI database programming > ____________________________________________________________ > > ------------------------------------------------------------- > 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:
Hi Joe,You missed the point.There were only ever 12 items in the db. The problem was in creating the table which added the additional lines and therefore the resulting search on the table causing the problem. So taking out a cr when creating the table meant it was created correctly.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: Joe D'Andrea > Reply-To: (WebDNA Talk) > Date: Thu, 1 May 2003 07:23:48 > To: (WebDNA Talk) > Subject: Re: [table] strange behaviour REAL solution > > At 1:22 PM 5/1/03, Tim Robinson wrote: >> Of course, this still doesn't explain why it only happens when the sort is >> on the PRICE field and not the sku field.... > > Because you have empty records in your database. WebDNA does not > require a CR after a [founditems] in order for the records to display > properly. In fact you can test this by removing your entire > [founditems] context. > > If you just do [search ...][numfound][/search] you will see that the > number of items returned depends on your search criteria and has > nothing to do with what is or isn't in your [founditmes] context or > whether there even is or isn't a [founditems] context. > > This is from a previous post of your's: > At 12:43 PM 5/1/03, Tim Robinson wrote: >> 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. > > Of course it worked. In the first search you're finding all records. > That's why you get 24 records and why the html table appears to > display improperly. But the html table is not displaying > improperly... you're seeing blank records. > > When you change the search parameter in your second try above, you > are saying find all records where the SKU is not equal to [blank] > ..... which is the same as saying find all records that are NOT empty > in the SKU field. You get 12 records and the html table appears (and > is) as expected. > > Your problem is that you have blank records in your database most > likely the result of an incorrect line ending characters for your > operating system(s). > > Good luck. > > ~joe > > -- > ____________________________________________________________ > Joseph D'Andrea ~ http://www.west21.com/ ~ JoeDan@West21.com > WEST21.com Internet services for the 21st Century > webhosting ~ co-location ~ wireless access > WebCat and MGI database programming > ____________________________________________________________ > > ------------------------------------------------------------- > 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:
[/application] error? (1997)
WebCatalog2 Feature Feedback (1996)
HTML Editors (1997)
More than one db with the same namn (was: WC2f3) (1997)
Sendmail and textarea (1998)
FYI: SmithMicro Financial Report (2000)
[carts] and databases (1997)
WebCat 4.0x database losing data? (2003)
multi-paragraph fields (1997)
formatting dates from a field ... (1997)
wrong authentication (1998)
Problems getting parameters passed into email. (1997)
bug in [SendMail] (1997)
the dreaded unitShipCost (2003)
b12 cannot limit records returned and more. (1997)
Searchable WebCat (etc.) Docs ? (1997)
Fun with Dates - any progress? (1997)
Signal Raised Error (1997)
Close-to Comparison Code (1998)
[SHOWIF AND/OR] (1997)