Re: range vs greater than/less than
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 48331
interpreted = N
texte = This sounds like a job for the Group Field Workaround! Defining a groupfield that contains a field you're already searching lets you search that field again...[search db=...&group1field=ABC&leABCdata=[max]&geGROUP1data=[min]...]It's kinda ugly and tricker to write in a generic fashion, but it works.- brianOn Tuesday, March 4, 2003, at 01:46 PM, Andrew Simpson wrote:> This is just a comment really on the way webcat does something that i > don't > like. > > I have just finished writing a search page that lets you select from > drop > down lists to refine your search. The company sells projectors. The > search > criteria are > > min / max price > min / max resolution > min / max weight > min / max lumens (brightness) > > with a drop down for both min and max values for each item. > > You select your mins and maxiums and hopefully you get a set of > products > returned that are within the range. > > So I wrote some nice generic code that should handle all > eventuallities: > > [formvariables name=min&exact=false] > [showif [value]!#] > [text]search_string=[search_string]ge[getchars > start=5][name][/getchars]data=[value]&[getchars > start=5][name][/getchars]type=num&[/text] > [/showif] > [/formvariables] > > [formvariables name=max&exact=false] > [showif [value]!#] > [text]search_string=[search_string]le[getchars > start=5][name][/getchars]data=[value]&[getchars > start=5][name][/getchars]type=num&[/text] > [/showif] > [/formvariables] > > So depending on how many options the user chooses, the search_string > slowly > gets built up to the point where you run it and the found items loop > does > the rest. It works great if you only select a min for one field or a > max for > one field > > BUT IT DOESN'T WORK IF YOU SELECT BOTH MIN AND MAX FROM ONE FIELD! > > Because of the way webcat works with Ranges when comparing multiple > values > on the same field of the database, this code is toast and now i have to > write some not so nice generic code to handle the same search job. > > Argh! > > okay - sorry, i didn't get much sleep last night. -- Brian Fries, BrainScan Software -- http://www.brainscansoftware.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:
This sounds like a job for the Group Field Workaround! Defining a groupfield that contains a field you're already searching lets you search that field again...[search db=...&group1field=ABC&leABCdata=[max]&geGROUP1data=[min]...]It's kinda ugly and tricker to write in a generic fashion, but it works.- brianOn Tuesday, March 4, 2003, at 01:46 PM, Andrew Simpson wrote:> This is just a comment really on the way webcat does something that i > don't > like. > > I have just finished writing a search page that lets you select from > drop > down lists to refine your search. The company sells projectors. The > search > criteria are > > min / max price > min / max resolution > min / max weight > min / max lumens (brightness) > > with a drop down for both min and max values for each item. > > You select your mins and maxiums and hopefully you get a set of > products > returned that are within the range. > > So I wrote some nice generic code that should handle all > eventuallities: > > [formvariables name=min&exact=false] > [showif [value]!#] > [text]search_string=[search_string]ge[getchars > start=5][name][/getchars]data=[value]&[getchars > start=5][name][/getchars]type=num&[/text] > [/showif] > [/formvariables] > > [formvariables name=max&exact=false] > [showif [value]!#] > [text]search_string=[search_string]le[getchars > start=5][name][/getchars]data=[value]&[getchars > start=5][name][/getchars]type=num&[/text] > [/showif] > [/formvariables] > > So depending on how many options the user chooses, the search_string > slowly > gets built up to the point where you run it and the found items loop > does > the rest. It works great if you only select a min for one field or a > max for > one field > > BUT IT DOESN'T WORK IF YOU SELECT BOTH MIN AND MAX FROM ONE FIELD! > > Because of the way webcat works with Ranges when comparing multiple > values > on the same field of the database, this code is toast and now i have to > write some not so nice generic code to handle the same search job. > > Argh! > > okay - sorry, i didn't get much sleep last night. -- Brian Fries, BrainScan Software -- http://www.brainscansoftware.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/
Brian Fries
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:
customer info (2001)
syntax question, not in online refernce (1997)
More on the email templates (I like it) (1997)
4.5.1 on Panther? (2004)
Searching an Email database (1997)
authenticating a second user (1997)
WebCatb15 Mac CGI -- [purchase] (1997)
Quick Question About Sorting (1997)
Bug or syntax error on my part? (1997)
Multiple Pulldowns (1997)
notification solutions (1997)
!!!! WebCat Programmer Opening for Growth eCommerce Startup!!!! (1999)
ANSWER to: CC Merchant suggestions?? (1997)
RE: IIS4b2 and WebCatalog b19 (1997)
[TaxableTotal] - not working with AOL and IE (1997)
File not found error message (1998)
Setting up shop (1997)
Price override - solved (2004)
WebCat2b13MacPlugin - nested [xxx] contexts (1997)
Multiple catalog databases and showcart (1997)