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:
WebMerchant Problem... (1999)
[WebDNA] Gulf Coast WebDNA programmers (2010)
Dreamweaver extensions [reprise] (2000)
Can't use old cart file (was One more try) (1997)
Orders coming up blank (2004)
Which [index]? (1997)
eCommerce Idea Patented? (2002)
Flat-file to XML converter (2006)
# fields limited? (1997)
WebCatalog/Mac 2.1b2 New Features (1997)
Smart caching problems with 2.1b3? (1997)
RAM variables (1997)
Num Sort Descending (2004)
calculating unique time (1998)
Verifying both name and password (was: THANKS) (1997)
Three new problems, maybe a fourth (1997)
[taxRate] [TaxTotal] ? (1997)
Re:What file? (1997)
Re2: frames & carts (1997)
off topic - dna snipets (1997)