Re: Search bug. Help
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 43528
interpreted = N
texte = Marc,What if your CT field contained NO decimals? You could multiply all your carat sizes by 100 before they go into the database. Then, divide by 100 and wrap the result in a [format] tag to get the 2 decimal places in the [founditems] loop.This might help with the sorting issues. [search db=loose-dia.db&eqSHAPEdatarq=rd&woCTdatarq=20,25&CTword=ww&CTwbrk=,&CTtype= num&woCOLORdatarq=a,b,c&woCLARITYdatarq=vvs1,vvs2&asCOLORsort=1&asCLARITYsor t=2&asCTsort=3&startat=[startat]&max=[themax]]On 9/17/02 11:20 PM, marc malacarme
wrote:> First I'd like to thank you for tacking the time to help. > > The reason I can't do multiple searches is because the results has about 100 > results per search and the sorting is critical. > > Here is the full search: > [search db=loose-dia.db&eqshapedatarq=rd&woCTdatarq=.20, > .25&CTword=ww&CTwbrk=,&CTtype=num&wocolordatarq=a,b,c&woclaritydatarq=vvs1,v > vs2&colorsort=1&colorsdir=as&claritysort=2&claritysdir=as&ctsort=3&ctsddir=a > s&startat=[startat]&max=[themax]] > > You see that ct is the last to be sorted. I thought about nesting searches > but it is not feasible because the of the amount of searches it would have > to perform. This is my main search page meaning that many users will be > accessing the page simultaneously and 100 searches per request would be too > much for my server. Not to mention that the page is already littered with > lookups and 3 other searches on other databases. > > I can't do a range search because I want users to be able to omit certain > values that might fit in the range. The way the user decides what values to > search Ct with is with check boxes in the form .25 .33 .50 .60 .50 .75 .100. > They can select any combination not necessarily in order. --------------------------------------------------------------------- Clint Davis Webmaster / Interactive Media Specialist Gray Loon Marketing Group, Inc. http://www.grayloon.com 204 Main Street | Evansville, IN 47708 | Phone:812-422-9999 --------------------------------------------------------------------- ------------------------------------------------------------- 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://search.smithmicro.com/
Associated Messages, from the most recent to the oldest:
Marc,What if your CT field contained NO decimals? You could multiply all your carat sizes by 100 before they go into the database. Then, divide by 100 and wrap the result in a [format] tag to get the 2 decimal places in the [founditems] loop.This might help with the sorting issues. [search db=loose-dia.db&eqSHAPEdatarq=rd&woCTdatarq=20,25&CTword=ww&CTwbrk=,&CTtype= num&woCOLORdatarq=a,b,c&woCLARITYdatarq=vvs1,vvs2&asCOLORsort=1&asCLARITYsor t=2&asCTsort=3&startat=[startat]&max=[themax]]On 9/17/02 11:20 PM, marc malacarme wrote:> First I'd like to thank you for tacking the time to help. > > The reason I can't do multiple searches is because the results has about 100 > results per search and the sorting is critical. > > Here is the full search: > [search db=loose-dia.db&eqshapedatarq=rd&woCTdatarq=.20, > .25&CTword=ww&CTwbrk=,&CTtype=num&wocolordatarq=a,b,c&woclaritydatarq=vvs1,v > vs2&colorsort=1&colorsdir=as&claritysort=2&claritysdir=as&ctsort=3&ctsddir=a > s&startat=[startat]&max=[themax]] > > You see that ct is the last to be sorted. I thought about nesting searches > but it is not feasible because the of the amount of searches it would have > to perform. This is my main search page meaning that many users will be > accessing the page simultaneously and 100 searches per request would be too > much for my server. Not to mention that the page is already littered with > lookups and 3 other searches on other databases. > > I can't do a range search because I want users to be able to omit certain > values that might fit in the range. The way the user decides what values to > search Ct with is with check boxes in the form .25 .33 .50 .60 .50 .75 .100. > They can select any combination not necessarily in order. --------------------------------------------------------------------- Clint Davis Webmaster / Interactive Media Specialist Gray Loon Marketing Group, Inc. http://www.grayloon.com 204 Main Street | Evansville, IN 47708 | Phone:812-422-9999 --------------------------------------------------------------------- ------------------------------------------------------------- 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://search.smithmicro.com/
Clint Davis
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:
Upload files script (2003)
Apache on Windows (2005)
[shownext max=?] armed (1997)
page redirect in webDNA (1997)
WebCat2 - many [carts] on one template page? (1997)
SV: Mass Mail (2000)
WebDNA Solutions ... sorry! (1997)
Merging databases (1997)
What kind of request is this? (2002)
ooops...WebCatalog [FoundItems] Problem - LONG - (1997)
WebCat2b13MacPlugin - nested [xxx] contexts (1997)
'Document Contains No Data' (1999)
[WebDNA] Date and Time as numbers (2009)
Thanks for Encrypt.tpl - A Question (1999)
Enhancement Request for WebCatalog-NT (1996)
No luck with taxes (1997)
[WebDNA] how to clear the [username] and [password] values the browser has stored? (2008)
[TaxableTotal] - not working with AOL and IE (1997)
creating a 60 fields database (1997)
Problems appending to database (1997)