David
|
| Posted: 11/02/2004, 8:03 AM |
|
This is something that has worked flawlessly until today.
When I log into the application using the login page created with ccs; I receive the following error.
ADODB.Recordset error '800a0e78'
Operation is not allowed when the object is closed.
/intranet/Common.asp, line 1745
The line in bold below is the line it is referring to:
Function CCLoginUser(Login, Password)
Dim Result
Dim SQL
Dim RecordSet
Dim Connection
Set Connection = New clsDBSVMS
Connection.Open
SQL = "SELECT [employeeautoID], [SecGroupID] FROM [ActiveUsers] WHERE userid='" & Replace(Login, "'", "''") & "' AND password='" & Replace(Password, "'", "''") & "'"
Set RecordSet = Connection.Execute(SQL)
Result = NOT RecordSet.EOF
If Result Then
Session("UserID") = RecordSet("employeeautoID")
Session("UserLogin") = Login
Session("GroupID") = RecordSet("SecGroupID")
End If
RecordSet.Close
Set RecordSet = Nothing
Connection.Close
Set Connection = Nothing
CCLoginUser = Result
Any ideas why I would get this error???
|
|
|
 |
David
|
| Posted: 11/02/2004, 8:52 AM |
|
Never mind..... oops..... Would help if my sql view was created correclty.
|
|
|
|
|
