hi,
plz have a look at my code following:
contacts = "exec smvcontacts '" & request.form("tehid") & "'"
set contacts_rs = conn.execute(contacts)

now i want to check whether contacts_rs record set have fetched any record or not. how can i check? because my if it has fetched any record against the procedure then i'll call this recordset otherwise i'll not call this recordset. bcause when record set has no record it in, browser shows me the error msg
Error Type:
ADODB.Field (0x80020009)
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.

can any1 help me.

You can check for EOF:

If contacts_rs.EOF Then
 'No records found..
else
 'Records found..
End if

Om Prakash