ADO recordset contains

[tictaclam]

Hi
I have a recordset and I want to find out if a particular row is in the set is there anyways i can do this? My code is
strSQL = "SELECT * FROM Program Information"
set objRS = Server.CreateObject( "ADODB.recordset" )
objRS.CursorLocation = adUseClient
objRS.Open strSQL, objConn, adOpenStatic, adLockOptimistic

I need the entire objRS for various reasons but at some point I need to check to see if objRS has a "ProgramID" that equals "AAA" (programID is in the table Program Information). Is there anyway to do this. I feel like it should be easy but i'm having a hard time with it
thanks

 

[pweegar]

This should work:


strSQL = "SELECT * FROM [Program Information] WHERE ProgramId = 'AAA'"

If that doesn't work, try this:

SELECT *
FROM [Program Information]
WHERE ProgramID = 'AAA'