Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

dealing with multiple selection from list box

Status
Not open for further replies.

digitaldude

Programmer
May 23, 2000
1
CA
Thanks in advance for time<br><br>I would like some advice in dealing with the following:<br><br>a user makes multiple selections on a web page list box which might return something like<br><br>&quot;12,234,9&quot; lets say these are city id's.<br><br>What might be the best way to record and later search on these id's. <br><br>Thanks again<br>Andre S. <br><br><br><br>
 
One thought is:<br><br>If you can insert single quotes at the appropriate places, you could use that as an argument to the IN clause, such as:<br><br><FONT FACE=monospace>select * from mytable where cityid in @myvar</font> <p>Robert Bradley<br><a href=mailto: > </a><br><a href= - Visual FoxPro Development</a><br>
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top