Multiple Select Search Help

Results 1 to 2 of 2

Thread: Multiple Select Search Help

  1. #1
    Join Date
    Dec 1969

    Default Multiple Select Search Help

    Hello,<BR><BR> Not sure if this is more database orienated queston or not but here is my problem. I have a multiple select box. But when I do a search for more than 1 field it messes everything up.<BR><BR>From what I can tell is if you do a search for more than one Item it writes the Request.QueryString("City") as ALEX, MUNC, ALBAY in that format. <BR><BR>Is there a simple solution to fix the sql so it will search all the selected fields?<BR><BR>thanks,<BR>ryan

  2. #2
    Join Date
    Dec 1969

    Default RE: Multiple Select Search Help

    use the IN keyword<BR><BR>SELECT * FROM [table] where city IN (" & Request.QueryString("City") & ")"

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts