August 13th, 2004, 08:47 AM
|
|
Contributing User
|
|
Join Date: Jul 2003
Posts: 65
Time spent in forums: 34 m 56 sec
Reputation Power: 6
|
|
|
Empty Recordset Error
I am trying to run the following asp function:
Code:
Private Function GetAbs(dThisDate, lPartID)
sql_abs = "SELECT AbsCode FROM Absence WHERE AbsDate = '" & dThisDate & "' AND PartID = " & lPartID
Set rs_abs = conn.Execute(sql_abs)
GetAbs = rs_abs(0).Value
Set rs_abs = Nothing
End Function
It works fine if it finds a record but returns an error if it doesn't. How can I avoid this error?
Thanks!
|
ASP Free Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
