searching multiple fields!

Results 1 to 2 of 2

Thread: searching multiple fields!

  1. #1
    Join Date
    Dec 1969

    Default searching multiple fields!

    Hi, <BR><BR>I have one 4 list boxes in the search page. User can selects either one or more from the list boxes. How can I make SQL statement where it will check both "OR" and "AND" condition. <BR>For example: <BR>SQL="SELECT * FROM tblname WHERE item_no=" & Request.Form("item")& OR item_name=&#039;" & Request.Form("name")& "&#039; OR description=&#039;" &Request.Form("description")&" OR item_no=" & Request.Form("item")& AND item_name=&#039;" & Request.Form("name")& "&#039; AND description=&#039;" &Request.Form("description")&"&#039;" <BR><BR>Please somebody help me on this. <BR>THANKS.

  2. #2
    Join Date
    Dec 1969

    Default half the answer

    As given to me by Bill-to create the search syntax<BR>Dont know about OR/AND<BR><BR>

Posting Permissions

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