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 based upon whether they were sold or not, the search results are random and not necessarily in the order that they appear on the db. For instance, SKU 1,2,3,4,5,6 can be all marked as Sold=F but the search result of the db with a max=2 will give me back SKU 3 and 5 or if I do it again results come back as 1 and 4.Question:Is there a way to set the search up so that it when a max=2 that it will give me SKU 1 and 2? And if SKU 1 is Sold=T then the results would then be SKU 2 and 3? Not the random results.Thanks.Kevin Associated Messages, from the most recent to the oldest:

    
  1. Re: question: search return in order (Kenneth Grome 1997)
  2. question: search return in order (Kevin Furuta 1997)
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 based upon whether they were sold or not, the search results are random and not necessarily in the order that they appear on the db. For instance, SKU 1,2,3,4,5,6 can be all marked as Sold=F but the search result of the db with a max=2 will give me back SKU 3 and 5 or if I do it again results come back as 1 and 4.Question:Is there a way to set the search up so that it when a max=2 that it will give me SKU 1 and 2? And if SKU 1 is Sold=T then the results would then be SKU 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:

[ot] New List. Was: Webcat no longer supported? (2006) [WebDNA] Greetings to all (2016) Grep Question - MAY NEVER BE SOLVED (2003) Using Plug-In while running 1.6.1 (1997) [WebDNA] Seriously what is wrong here? (2011) error: Too many nested [xxx] contexts (1997) Database on the same server but with different domains (2000) absolute paths for databases? (1997) [ListFiles] context & alias (1997) Transferring [cart] to Database (1997) all records returned. (1997) Need Advice for Setting up a Database (1999) OT: JavaScript question (2001) problem with [Format Days_To_Date] (2000) Forms Search Questions (1997) WebCatalog Mac and cgi-bin (WebSTAR 2.0) (1997) sandbox is hogging 99% cpu cycles (2004) The max=0 issue is a bug ... CALL TO ACTION (2000) showif comparison begins w/ and contains (1997) BUG?-.html extention not working. (2000)