numero = 33107
interpreted = N
texte = 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&zipstart > > 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/
Associated Messages, from the most recent to the oldest:
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&zipstart > > 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/
Robert Wade
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...