i have the a stored procedure that has some conditional updates to different tables and after updates has select statements to return the updated data. Not all the selects return results.
However in my asp code i want to display a success message if any of the selects return results.
Here is what i have which doesn't work;
'my connection object and string
'my stored procedure
storedProc = "exec myStoreProc"
'my recordset object and stored procedure
rs = New ADODB.Recordset
rs.Open storedProc, dbCon1
If rs.state > 0 Then