searching databases

Results 1 to 2 of 2

Thread: searching databases

  1. #1
    Join Date
    Dec 1969

    Default searching databases

    I want to search a database with multiple text input boxes, i.e.<BR>name<BR>department<BR>location<BR><BR>does anyone know of a good article on how to do this<BR><BR>Thanks

  2. #2
    Join Date
    Dec 1969

    Default RE: searching databases

    why not add the text to your SQL string? I know that SQL 7 does have full text search capabilities (and I&#039;m not a SQL guru, so I couldnt tell you how to do this), but why not do:<BR><BR>SELECT * FROM yourtable WHERE name = &#039;nametextboxvalue&#039; AND department = &#039;departmenttextboxvalue&#039; AND location = &#039;locationtextboxvalue&#039; ORDER BY name<BR><BR>You would probably have to do a little client and server data validation to ensure search integrity (apostrophes and junk like that)...

Posting Permissions

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