numero = 33110
interpreted = N
texte = Your Honor; on 6/12/00 4:37 PM, the Defendant, Robert Wade, confessed:> Thanks for looking at this, Paul. I changed the type=num fields (whoops!), > but I still > can't get it to work. No matter what I enter, I still get numfound=0, whether > it falls > within the range or is equal to the start or end of the range. > > Any more takers? > > Robert Wade > CABIN6 Design > > |[ //\ ||} || ||\| V| > > http://www.cabin6.com > robert@cabin6.com > > > Paul Fowler wrote: > >> I don't know if I missed something, as I don't see any answers for you. >> But at least I can see that: >> [search >> db=firms.db&gezipstartdatarq=[zipcode]&lezipenddatarq=[zipcode]&max=1&zipsta >> rt >> data=num&zipenddata=num] >> >> should be: >> >> [search >> db=firms.db&gezipstartdatarq=[zipcode]&lezipenddatarq=[zipcode]&max=1&zipsta >> rt >> type=num&zipendtype=num] >> >> But other than that it should work. >> >> Paul >> >> >>> 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 >>> zipend >>> >>> I then have a form on a page that contains only one input tag: >> type=text name=zipcode size=5 maxlength=5> >>> 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 zipend >>> >>> I have tried the following and it returns 0: >>> [search >>> db=firms.db&gezipstartdatarq=[zipcode]&lezipenddatarq=[zipcode]&max=1&zipsta >>> rt >>> data=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/ >> >> ------------------------------------------------------------- >> 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/ > > > ------------------------------------------------------------- > 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/ > Your exact premise is in the docs: rnzipcodedata=92069 93090&zipcodetype=numor you could use clzipcodedata=92069&clzipcodedata=10 to find all records within '10'or, you can use mr for min and xr for the max values.(don't feel bad, I missed this recently as well, the M is too hard ri F'ing R or I'd just be condescending and say... well, you know RT*M :) ****************************************************************** * Digital Speed Networks, and NineWire Productions have merged!! * * We are now NineWire Digital Solutions * * * ******************************************************************------------------------------------------------------------- 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:
Your Honor; on 6/12/00 4:37 PM, the Defendant, Robert Wade, confessed:> Thanks for looking at this, Paul. I changed the type=num fields (whoops!), > but I still > can't get it to work. No matter what I enter, I still get numfound=0, whether > it falls > within the range or is equal to the start or end of the range. > > Any more takers? > > Robert Wade > CABIN6 Design > > |[ //\ ||} || ||\| V| > > http://www.cabin6.com > robert@cabin6.com > > > Paul Fowler wrote: > >> I don't know if I missed something, as I don't see any answers for you. >> But at least I can see that: >> [search >> db=firms.db&gezipstartdatarq=[zipcode]&lezipenddatarq=[zipcode]&max=1&zipsta >> rt >> data=num&zipenddata=num] >> >> should be: >> >> [search >> db=firms.db&gezipstartdatarq=[zipcode]&lezipenddatarq=[zipcode]&max=1&zipsta >> rt >> type=num&zipendtype=num] >> >> But other than that it should work. >> >> Paul >> >> >>> 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 >>> zipend >>> >>> I then have a form on a page that contains only one input tag: >> type=text name=zipcode size=5 maxlength=5> >>> 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 zipend >>> >>> I have tried the following and it returns 0: >>> [search >>> db=firms.db&gezipstartdatarq=[zipcode]&lezipenddatarq=[zipcode]&max=1&zipsta >>> rt >>> data=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/ >> >> ------------------------------------------------------------- >> 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/ > > > ------------------------------------------------------------- > 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/ > Your exact premise is in the docs: rnzipcodedata=92069 93090&zipcodetype=numor you could use clzipcodedata=92069&clzipcodedata=10 to find all records within '10'or, you can use mr for min and xr for the max values.(don't feel bad, I missed this recently as well, the M is too hard ri F'ing R or I'd just be condescending and say... well, you know RT*M :) ****************************************************************** * Digital Speed Networks, and NineWire Productions have merged!! * * We are now NineWire Digital Solutions * * * ******************************************************************------------------------------------------------------------- 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/
Aaron Lynch
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...