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:
Paths, relative paths, webstar server setup and security (Mac) (1997)
[WebDNA] max number of searches and lookups on a page (2016)
[Announce]: Web server security and password protection (1997)
Couple of questions (1999)
[WebDNA] CMS in WEBDNA (2009)
WC2b15 - [HTMLx]...[/HTMLx] problems (1997)
WebDNA-Talk Digest mode broken (1997)
includes and cart numbers (1997)
[WebDNA] WebDNA version 7 feature list? (2011)
Major Security Hole (1998)
survey builder code (2003)
auto-stripping of spaces (1997)
FW: ANother SHOWIF problem (1997)
Feature Request [TABLE ... &delimiters=] (2007)
Trouble with formula.db (1997)
Emailer (WebCat2) (1997)
Can this be done? (2004)
Null Chars (1999)
Generating Options for a Form. (1997)
New WebCatalog site! (1997)