www.webdeveloper.com
Results 1 to 2 of 2

Thread: Trouble searching strings in database with ASP

  1. #1
    Join Date
    Oct 2011
    Posts
    1

    Trouble searching strings in database with ASP

    Hi all, first time posting to any forum, anywhere, ever. Apologies in advance if any mis-steps.

    I'm using this code to search a MS-Access database:

    Rs.Open "SELECT * FROM products WHERE ACTIVE = TRUE AND TITLE LIKE '%" & Request.Form("KEYWORDSEARCH") & "%' ORDER BY VENDORPN ASC", OBJdbConnection

    If I search for something numberic, like 325, works great. If I search for something purely text, like hat, it seems to run for a long time and then I get an error, I think some sort of buffer overflow. If anyone can help I'd be indebted.

  2. #2
    Join Date
    Jan 2008
    Location
    Florida
    Posts
    1,227
    How many records and columns does your database contain?

    I would first replace the "select *" with "select columnname"

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

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



Recent Articles