I have converted my access database to mysql however my asp code is throwing the following error.
Microsoft VBScript runtime error '800a01a8'
Object required: 'rsObject'
/ezpoll/common/db_functions.asp, line 52
I have looked at the code and cannot try to figure out why I am getting the error to this line of code:
Code:
rsObject.Close: Set rsObject = Nothing
the full code is below;
Code:
<%
Sub ConnOpen(Conn)
Conn.Open ConnStr
End Sub
Sub ConnClose(Conn)
Conn.Close: Set Conn = Nothing
End Sub
Sub getPageRecordset(strSQL, rsObject)
'rsObject.CursorLocation = 3
rsObject.Open strSQL, Conn, 3, 1, &H0002
End Sub
Sub getPageTextRecordset(strSQL, rsObject)
'rsObject.CursorLocation = 3
rsObject.Open strSQL, Conn, 3, 2, &H0001
End Sub
Sub getPTextRecordset(strSQL, rsObject)
rsObject.Open strSQL, Conn, 3, 2, &H0001
End Sub
Sub getTextRecordset(strSQL, rsObject)
rsObject.CursorLocation = 3
rsObject.Open strSQL, Conn, 3, 3, &H0001
End Sub
Sub getTableRecordset(strSQL, rsObject)
rsObject.Open strSQL, Conn, 3, 3, &H0002
End Sub
Sub getExecuteQuery(strSQL)
Conn.Execute(strSQL)
End Sub
Sub closeRecordset(rsObject)
rsObject.Close: Set rsObject = Nothing
End Sub
Sub closeObject(oObject)
oObject.Close: Set oObject = Nothing
End Sub
%>
Any suggestions would be appreciated