Keyword search

Results 1 to 2 of 2

Thread: Keyword search

  1. #1
    Paul Jordan Guest

    Default Keyword search

    Hi All,<BR><BR>I need some ASP/SQL/HTML code.<BR><BR>I have set up ASP, and linked to an Access database.<BR><BR>I need some code to do a search on a field in the database. For example, in Access I have a table named "Table1" and a field in that table named "Resoltions". From the Web page I want to enter a keyword in the Web page textbox and if the keyword matches any words contained in the field "Resolution" they are pulled out and displayed on the Web page.<BR><BR>Can you send me this code, but not VBscript, only SQL/HTML.<BR><BR>Thank you<BR>Paul.<BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: Keyword search

    You can use the SQL LIKE operator:<BR><BR>SELECT * FROM TABLE WHERE RESOLUTION LIKE &#039*keyword*&#039<BR><BR>Good Luck!<BR><BR>Mike

Posting Permissions

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