Filtering records from Access DB

andy24 · July 22nd, 2003, 06:41 AM

I am trying to retrieve records by a certain type from my Access Database. I can retrieve all the records in the database but I only want a certain type. I have tried using the code from my Wrox book, Beginning Active Server Pages 3.0 and modifying it but it either does not work or it retrieves all records.
Can anyone help me with this problem?
I can't post my code as it is pretty tatty as I am all over the place with it at the minute.
Nearly forgot, I am new to ASP and only just getting the hang of certain aspects of it.
Any help would be appreciated.

Andy

pgtips · July 22nd, 2003, 08:26 AM

Its hard to say for sure since you give us nothing to go on. No code and no table structures. Have you tried using a WHERE clause in your SQL string (are you using SQL?).

Code:

SELECT Field1, Field2, ... FROM TableName
WHERE FieldN = 'TheTypeYouWant'