numero = 33090
interpreted = N
texte = Hello, This should be a simple one for you folks... I need to do a kindof backwards range comparison in a search context.Backwards in that the user submits a single number to match a range oftwo fields in a database, rather than submitting a range of two numbersto match a single field in the database.I have a database that contains a field named zipstart & a field namedzipendI 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 whichcontains a search context. I need to match one result in the databasethat their input will fall between the zipstart and zipendI have tried the following and it returns 0:[searchdb=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 WadeCABIN6 Design|[ //\ ||} || ||\| V|http://www.cabin6.comrobert@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:
Hello, This should be a simple one for you folks... I need to do a kindof backwards range comparison in a search context.Backwards in that the user submits a single number to match a range oftwo fields in a database, rather than submitting a range of two numbersto match a single field in the database.I have a database that contains a field named zipstart & a field namedzipendI 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 whichcontains a search context. I need to match one result in the databasethat their input will fall between the zipstart and zipendI have tried the following and it returns 0:[searchdb=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 WadeCABIN6 Design|[ //\ ||} || ||\| V|http://www.cabin6.comrobert@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
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...