Multiple search fields

Results 1 to 3 of 3

Thread: Multiple search fields

  1. #1
    Agitated Guest

    Default Multiple search fields

    How do i go about creating multiple search fields? alright i have users seaching for information in a database. they only need records from three fields in the database. say they are seaching for tracking numbers. They enter 123-456 into a text field. they need to search multiple tracking numbers to save time. so they enter <BR>123-456, 123-479<BR>789-785, 987-512<BR>how do i do this?<BR>

  2. #2
    Sathiya Guest

    Default RE: Multiple search fields

    I can give u a algol to work with, try and see you can get some idea. <BR>1. Get the values from text box<BR>2. Replace the comma(,) with &#039 or Num1 = &#039(ie num1 is the column name which u need to search). Using replace function (VBscript).<BR>3.Run a query select * from T where Num1=123-456 or Num1=123-479<BR>( here , is replaced by or Num1=)<BR>

  3. #3
    Agitaged Guest

    Default nevermind

    I figured it out

Posting Permissions

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