numero = 33105
interpreted = N
texte = 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/
Associated Messages, from the most recent to the oldest:
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/
Paul Fowler
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...