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:
Need relative path explanation (1997)
Re[2]: Bugs still *not* fixed as promised ... (2000)
what run level should S90WebCatalog be at? (2003)
problem serving foreign languages text (1997)
change curly quotes (2008)
syntax question, not in online refernce (1997)
Math with Time (1997)
JavaScript Image Problem (1998)
Modifying databases manually (was Banner DNA) (1997)
ShowNext (1997)
Dealing with da back button (1999)
re: date search problem (1999)
Default admin bug and how tech support reacted to it. (2000)
question about checkboxes (1999)
Search/sort in URL Was: GuestBook example (1997)
Running 2 two WebCatalog.acgi's (1996)
Please please help (2001)
Emailer (1997)
Code database (1998)
Banner DNA (1997)