Re: range vs greater than/less than
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 48332
interpreted = N
texte = thanks mate - Alain was just telling me the same thing.definitely better than me having to write ranges for each of my eight selects but having to write code to check if both min and max values were present first to do the range otherwise doing a greater than/less than if one wasn't present.wasn't looking forward to that.----- Original Message ----- From: Brian Fries
To: WebDNA Talk Sent: Wednesday, March 05, 2003 10:55 AM Subject: Re: range vs greater than/less than > 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. > > - brian > > On 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/ ------------------------------------------------------------- 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:
thanks mate - Alain was just telling me the same thing.definitely better than me having to write ranges for each of my eight selects but having to write code to check if both min and max values were present first to do the range otherwise doing a greater than/less than if one wasn't present.wasn't looking forward to that.----- Original Message ----- From: Brian Fries To: WebDNA Talk Sent: Wednesday, March 05, 2003 10:55 AM Subject: Re: range vs greater than/less than > 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. > > - brian > > On 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/ ------------------------------------------------------------- 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/
Andrew Simpson
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:
WC2.0 Memory Requirements (1997)
UH OH (1999)
Country & Ship-to address & other fields ? (1997)
my price won't move (1997)
WebCat as POP mail client? (2002)
ATTN:SMITH MICRO (2001)
WebCat preferences caching problem (2000)
Rounding question (2002)
SiteGaurd file Cache vs webcatalog cache (1997)
WebCat2 beta 11 - new prefs ... (1997)
[WebDNA] API Integration (2010)
How is it done? (1998)
ReplaceFoundItems Problem (2003)
WebDNA Grep help wanted (2004)
[date format] w/in sendmail (1997)
Closing db's & caching templates (was: Shippingcalculations) (1997)
[math] are you there? (1999)
[Sum] function? (1997)
Progress !! WAS: Trouble with formula.db (1997)
Advice on MacOS & TCP Connects (2000)