Range Comparisons

This WebDNA talk-list message is from

2000


It keeps the original formatting.
numero = 33090
interpreted = N
texte = Hello, This should be a simple one for you folks... I need to do a kind of backwards range comparison in a search context. Backwards in that the user submits a single number to match a range of two fields in a database, rather than submitting a range of two numbers to match a single field in the database.I have a database that contains a field named zipstart & a field named zipendI then have a form on a page that contains only one input tag: The user inputs their zip code and the form posts the next page which contains a search context. I need to match one result in the database that their input will fall between the zipstart and zipendI have tried the following and it returns 0: [search db=firms.db&gezipstartdatarq=[zipcode]&lezipenddatarq=[zipcode]&max=1&zipstartdata=num&zipenddata=num]There must be a simple way to do this that I have overlooked.Any help is appreciated.Robert Wade CABIN6 Design|[ //\ ||} || ||\| V|http://www.cabin6.com robert@cabin6.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://search.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: Range Comparisons (Kenneth Grome 2000)
  2. Re: Range Comparisons (Robert Wade 2000)
  3. Re: Range Comparisons (Bob Sneidar 2000)
  4. Re: Range Comparisons (John Peacock 2000)
  5. Re: Range Comparisons (Robert Wade 2000)
  6. Re: Range Comparisons (Aaron Lynch 2000)
  7. Re: Range Comparisons (Robert Wade 2000)
  8. Re: Range Comparisons (Paul Fowler 2000)
  9. Range Comparisons (Robert Wade 2000)
Hello, This should be a simple one for you folks... I need to do a kind of backwards range comparison in a search context. Backwards in that the user submits a single number to match a range of two fields in a database, rather than submitting a range of two numbers to match a single field in the database.I have a database that contains a field named zipstart & a field named zipendI then have a form on a page that contains only one input tag: The user inputs their zip code and the form posts the next page which contains a search context. I need to match one result in the database that their input will fall between the zipstart and zipendI have tried the following and it returns 0: [search db=firms.db&gezipstartdatarq=[zipcode]&lezipenddatarq=[zipcode]&max=1&zipstartdata=num&zipenddata=num]There must be a simple way to do this that I have overlooked.Any help is appreciated.Robert Wade CABIN6 Design|[ //\ ||} || ||\| V|http://www.cabin6.com robert@cabin6.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://search.smithmicro.com/ Robert Wade

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:

Cookies and webcat (1997) $Replace with [founditems] (1997) Time Until (1999) Sorting (2005) searching by date range help needed (1997) hmmm (2006) WC2b15 - [HTMLx]...[/HTMLx] problems (1997) form data submission gets truncated (1997) RequiredFields template (1997) WebCat2b12 CGI Mac -- Problems propagating the cart through (1997) Too many wrong answers! (1998) Protect vs Authenicate (1997) [WebDNA] Crashing again (2008) Help- WebCat won't parse pages! (2002) Forms Search Questions (1997) Stats (2001) Running _every_ page through WebCat ? (1997) Emailer help needed (1998) grep question - removing spaces (2005) [ot] Securing PHP & MySQL (2003)