question: search return in order
This WebDNA talk-list message is from 1997
It keeps the original formatting.
numero = 12711
interpreted = N
texte = Hi,I have been having problems with my email but it looks as if it is OK now.Situation:When I have the thankyou.tmpl page do a search for serial numbers basedupon whether they were sold or not, the search results are random and notnecessarily in the order that they appear on the db. For instance, SKU1,2,3,4,5,6 can be all marked as Sold=F but the search result of the dbwith a max=2 will give me back SKU 3 and 5 or if I do it again results comeback as 1 and 4.Question:Is there a way to set the search up so that it when a max=2 that it willgive me SKU 1 and 2? And if SKU 1 is Sold=T then the results would then beSKU 2 and 3? Not the random results.Thanks.Kevin
Associated Messages, from the most recent to the oldest:
Hi,I have been having problems with my email but it looks as if it is OK now.Situation:When I have the thankyou.tmpl page do a search for serial numbers basedupon whether they were sold or not, the search results are random and notnecessarily in the order that they appear on the db. For instance, SKU1,2,3,4,5,6 can be all marked as Sold=F but the search result of the dbwith a max=2 will give me back SKU 3 and 5 or if I do it again results comeback as 1 and 4.Question:Is there a way to set the search up so that it when a max=2 that it willgive me SKU 1 and 2? And if SKU 1 is Sold=T then the results would then beSKU 2 and 3? Not the random results.Thanks.Kevin
Kevin Furuta
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:
HomePage Caution (1997)
please unsubscribe me! (2000)
RE: Ongoing group search problems ... (1997)
WebCat2b12 CGI Mac -- Problems propagating the cart through frames...still (1997)
Emailer help....! (1997)
Append database (1999)
[OT] Appropriate Signature??? (2003)
WebDNA Life Cycle (was Form POSTing with LONG variable) (2007)
[ListFiles] & [loop] (1998)
Sorting by date (1997)
WebCat2b13 Mac plugin - [sendmail] and checkboxes (1997)
[LOOKUP] (1997)
WebCatalog Technical Reference (1997)
remove line item (2000)
Adding multiple items to Cart at one time, & append contextproblem (1998)
writefile - continued (1997)
Cart Numbers (1997)
More questions about serial number dishing (1997)
no global [username] or [password] displayed ... (1997)
still having shipCost.db Problem (1997)