How do I see if a recordset contains a particular value?
Posted on 2004-08-25
I'm a bit of a quagmire ... I need to find a way to see if a recordset contains a particular value for a field, and I need to be able to do this over and over again. Here's my situation:
On a particular web page (ASP) I'm doing a query on an Access DB to get the field PROPID for a particular USERID. So,
SELECT propId FROM table WHERE userID = x
In the DB table there may be multiple lines for a particular USERID, so the results might look like:
Then listed on the web page are all of the possible PROPID's:
What I want to do is make the PROPID displaying on the web page a link IF the current user (USERID) has a record that contains that PROPID. Otherwise, the PROPID on the web page just remains regular text.
Please let me know your thoughts on an answer to this. Thanks.