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:
Summing fields (1997)
Where has WebDNA shown up in your life? (2003)
IE Cache Problems... (1999)
HTML tags inside textarea (2000)
Pulldown Menu Problem (2000)
PIXO Support (1997)
Show shoppingcart after remove last item (1997)
Signal Raised (1997)
Help name our technology! (1997)
Emailer (WebCat2) (1997)
Trouble with Showif and Search (1998)
[ot] html question (2000)
OT: Outsourcing & copyrights (2005)
Automated FTP from Shell - Update (2004)
killer-format in cart (1998)
XML Syntax, Cookies and Variables.... (2004)
WebCat2 - storing unformatted date data? (1997)
[Fwd: Rotating Banners ... (was LinkExchange)] (1997)
Running _every_ page through WebCat ? (1997)
database size? (1997)