Re: searching a range
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 30801
interpreted = N
texte = >I want to search a range, but I want the user to enter a minimum and a >maximum, in two separate drop menus, so I can't use one field >rnpricedata=2+9 > >but when I try gepricedatarq=2&lepricedatarq=9&pricetype=num my result >includes 1 which is less than 9 and 10 which is more than 2. >>How can I make it return records between 2 and 9?One rule that seems counter-intuitive in webcatalog is that you CANNOT search the same database field using two or more search parameters. Too bad they don't enable webcat to handle more than one parameter per db field, right?In the meantime ...Rule #1: Always use search contexts, not commands, then you can put both values into a single search parameter using rn as the comparison operator:[search db=xxx.db&rnpricedatarq=[lowprice],[highprice]&pricetype=num ...Rule #2: If you refuse to follow rule #1, you'll just have to use group field technique to pass the appropriate group field search parameter values in your form fields. The group field technique is explained in the docs under Searching ... ================================ Kenneth Grome, WebDNA Consultant 808-737-6499 http://webdna.net ================================------------------------------------------------------------- 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
Associated Messages, from the most recent to the oldest:
>I want to search a range, but I want the user to enter a minimum and a >maximum, in two separate drop menus, so I can't use one field >rnpricedata=2+9 > >but when I try gepricedatarq=2&lepricedatarq=9&pricetype=num my result >includes 1 which is less than 9 and 10 which is more than 2. >>How can I make it return records between 2 and 9?One rule that seems counter-intuitive in webcatalog is that you CANNOT search the same database field using two or more search parameters. Too bad they don't enable webcat to handle more than one parameter per db field, right?In the meantime ...Rule #1: Always use search contexts, not commands, then you can put both values into a single search parameter using rn as the comparison operator:[search db=xxx.db&rnpricedatarq=[lowprice],[highprice]&pricetype=num ...Rule #2: If you refuse to follow rule #1, you'll just have to use group field technique to pass the appropriate group field search parameter values in your form fields. The group field technique is explained in the docs under Searching ... ================================ Kenneth Grome, WebDNA Consultant 808-737-6499 http://webdna.net ================================------------------------------------------------------------- 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
Kenneth Grome
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:
2.0 Info (1997)
Disappearing HTML/WebDNA (1998)
Migrating to NT (1997)
Separate SSL Server (1997)
[WebDNA] Apple nixes Mac OS Server ("websites") and other (2018)
Have I lost my mind? uhmm... (2002)
pc (1997)
[WebDNA] Pretty URLS (2011)
Help name our technology! I found it (1997)
wierd [cart] action! (1997)
Thanks Grant (1997)
WC2b15 - [HTMLx]...[/HTMLx] problems (1997)
Dreamweaver and WebDNA (2003)
Initiating NewCart (1997)
Multiple Pulldowns/Gary (1997)
Replace context problem ... (1997)
Mailer (2006)
WC Database Format (1997)
Show shoppingcart after remove last item (1997)
Quick Question (1997)