Re: question: search return in order

This WebDNA talk-list message is from

1997


It keeps the original formatting.
numero = 12714
interpreted = N
texte = >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. Try adding &asskusort=1&skutype=num to your search parameters. The &asskusort=1 tells WebCat to sort the matching sku values in ascending order, and the skutype=num tells WebCat that the sku values are numbers and should be sorted as numbers instead of being sorted as text.Sincerely, Ken Grome WebDNA Solutions http://www.hui.net/dna/webdna.html. 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)
>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. Try adding &asskusort=1&skutype=num to your search parameters. The &asskusort=1 tells WebCat to sort the matching sku values in ascending order, and the skutype=num tells WebCat that the sku values are numbers and should be sorted as numbers instead of being sorted as text.Sincerely, Ken Grome WebDNA Solutions http://www.hui.net/dna/webdna.html. Kenneth Grome

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:

RE: Languages (1997) WCS Newbie question (1997) Multiple catalog databases and showcart (1997) Safari browser and WebDNA set-cookies (2003) [Webcat 2]Next (1997) attn: smitmicro - cart limitation (2002) Mauthonly followed by mauthcapture (2002) Version f1 status (1997) RE: Cart Template (1997) RE: Personal Web Server combined with Webcatalog 2.1 (1998) Change Subtotal (2000) How to set suffix mapping on IIS 5.1 ... (2004) Followup question re: checksum for credit cards? (1997) Ken's Data Manager (was dbQuickView 2.0) (2005) Searching multiple fields from one form field (1997) Where is f2? (1997) Memory Error message (1998) Mac Scheduling (1998) WebCat2 - storing unformatted date data? (1997) WebCat2b13MacPlugIn - [showif][search][/showif] (1997)