Using recordsets for searching?

[beardawg]

I am trying to use a recordset to search for a record in a database. By passing a sql statement to the recordset, requerying, and then checking to see if it is empty. For example.

sqlString = "select * from dbo.EM where emLastName = '"& LastName & "'"
Recordset2.setSQLText(sqlString)
Recordset2.requery

if Recordset2.getCount() = 0 then
Response.Redirect("first_page.asp?Result=Failed&quot
End if

Correct me if I am wrong, but shouldn't this recordset be empty if LastName does not exist? Any suggestions on a better way to approach this?

 

[culshaja]

Depends on where you are getting the data from. Some databases return a row informing the number of rows selected/ modified. Thhis is usually in a second recordset though.

James James Culshaw
jculshaw@active-data-solutions.co.uk

http://www.active-data-solutions.co.uk

http://www.brainbench.com/transcript.jsp?pid=193305

 

[palbano]

Assuming you are working with a DTC.Recordset object, you might try doing this: ( Javascript )

if ( !Recordset1.getRecordSource().EOF)
Recordset1.getRecordSource().Filter = "emLastName like 'R%'";

while( !Recordset1.getRecordSource().EOF){
.... rest of your stuff
}

Hope this helps
-pete