searching databses

Results 1 to 2 of 2

Thread: searching databses

  1. #1
    Join Date
    Dec 1969

    Default searching databses

    does anyone know of an article that shows you how to search database feilds using multiple text boxes i.e;<BR><BR>name<BR>position<BR>location<BR><BR>ea ch with a separate text input box<BR><BR>Thanks for your time

  2. #2
    Join Date
    Dec 1969
    Los Angeles, CA

    Default RE: searching databses

    well if they are all in the same table<BR><BR>string = "where......"<BR><BR>if request.form("NameTxtBoxName") &#060;&#062; "" then<BR>string = string & " AND NameColumnName LIKE &#039;%" & request.form("NameTxtBoxName") & "%&#039;"<BR>end if<BR>...<BR>...<BR>and so on for each of them...the only thing is you MAY wnat to use OR instead of AND.<BR><BR><BR>is this what you were asking for??<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