carnedv
05-23-2003, 02:02 PM
I am writing my first ASP/Access driven search engine and am having a weird problem with the records being returned.
The following is the sql statement I'm using:
sql="SELECT books.bookTitle FROM books WHERE books.bookTitle LIKE '" & request.form("criteria") & "%' ORDER BY books.bookTitle;"
This searchs for a book title that begins with a supplied criteria.
The problem is that a majority of my records that match the criteria supplied are not returned, though some of them are. For example. If you supply the criteria 'A' it only returns 7 of the 58 records where the title starts with 'A'. However, if I run the query locally just through Access, it returns all 58. What's the deal?
Thanks in advance.
dvc
The following is the sql statement I'm using:
sql="SELECT books.bookTitle FROM books WHERE books.bookTitle LIKE '" & request.form("criteria") & "%' ORDER BY books.bookTitle;"
This searchs for a book title that begins with a supplied criteria.
The problem is that a majority of my records that match the criteria supplied are not returned, though some of them are. For example. If you supply the criteria 'A' it only returns 7 of the 58 records where the title starts with 'A'. However, if I run the query locally just through Access, it returns all 58. What's the deal?
Thanks in advance.
dvc