...After I open the connection, I have the following code:
Set RS = Server.CreateObject("ADODB.Recordset")
strq = "SELECT * FROM Customer Where CustLicenseNum = '" & custlnum & "'"
set RS = conn.Execute(strq)
if (RS.RecordCount < 1) then
'"There were no records found. Please try your query again."
response.redirect "searchcust.asp"
else
msg = "1 record found."
end if
It finds the record but the Recordcount is -1. Shouldn't the Recordcount = 1 if a record is found?
Please advise, thx.
Set RS = Server.CreateObject("ADODB.Recordset")
strq = "SELECT * FROM Customer Where CustLicenseNum = '" & custlnum & "'"
set RS = conn.Execute(strq)
if (RS.RecordCount < 1) then
'"There were no records found. Please try your query again."
response.redirect "searchcust.asp"
else
msg = "1 record found."
end if
It finds the record but the Recordcount is -1. Shouldn't the Recordcount = 1 if a record is found?
Please advise, thx.