Re: range vs greater than/less than
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 48355
interpreted = N
texte = You're missing a few ampersands between your search terms at the end...- brianOn Tuesday, March 4, 2003, at 02:33 PM, Andrew Simpson wrote:> Do you have to code this so that you use the field name in one > instance and> group name in the other cause this isn't working either:>> db=/db/ > products.db&eqVISIBLEdatarq=T&GROUP1field=prod_brightness&GROUP1type=> number&GROUP2field=prod_weight&GROUP2type=number&GROUP3field=price&GROU > P3typ> e=number&geGROUP1datarq=5800geGROUP2datarq=1.5leGROUP1datarq=10000leGRO > UP2da> tarq=8>> ????>> ----- 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>> -->>>-- 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:
You're missing a few ampersands between your search terms at the end...- brianOn Tuesday, March 4, 2003, at 02:33 PM, Andrew Simpson wrote:> Do you have to code this so that you use the field name in one > instance and> group name in the other cause this isn't working either:>> db=/db/ > products.db&eqVISIBLEdatarq=T&GROUP1field=prod_brightness&GROUP1type=> number&GROUP2field=prod_weight&GROUP2type=number&GROUP3field=price&GROU > P3typ> e=number&geGROUP1datarq=5800geGROUP2datarq=1.5leGROUP1datarq=10000leGRO > UP2da> tarq=8>> ????>> ----- 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>> -->>>-- 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:
Who needs Yoda! (2002)
Server Load (2000)
[searchString] (1997)
verify online (1997)
Number of Line Items (1998)
Alternating colors (1997)
RE: Problems with shopping cart (1997)
Comments in db? (1997)
[WriteFile] problems (1997)
WebCatalog and WebMerchant reviewed by InfoWorld (1997)
UPS QuickCost and More (2000)
Re:quit command on NT (1997)
HomePage Caution (1997)
CSS problem (2000)
Setting up shop (1997)
[OT] Trying to steal databases on our server (2003)
Kaaaaahhhhhhhnnnnnnn! (1997)
range search (2002)
Date field search needs ... (1998)
WebDNA 5 - Privacy Issue (Built in sniffer) (2003)