Adam Boyce
|
| Posted: 01/05/2006, 10:57 AM |
|
hi,
accessing any page on my site that isnt secure is fine. i can access the table drill down into the record amend it ok. but when attempting to login to my site i am getting the following error:
Error Type:
ADODB.Recordset (0x800A0E78)
Operation is not allowed when the object is closed.
/urnwebsite/Common.asp, line 1805
line 1805 pertains:
Result = NOT RecordSet.EOF
the surrounding code is:
Set Connection = New clsDBARMS
Connection.Open
SQL = "SELECT record_id, Security_Group FROM sys_resources_tbl WHERE [User Name]='" & Replace(Login, "'", "''") & "' AND [Password]='" & Replace(Password, "'", "''") & "'"
Set RecordSet = Connection.Execute(SQL)
Result = NOT RecordSet.EOF
If Result Then
UserIDField = CStr(RecordSet("record_id").Value)
Session("UserID") = UserIDField
Session("UserLogin") = Login
Set GroupIDField = RecordSet("Security_Group")
Select Case GroupIDField.Type
|
|
|
 |
peterr
Posts: 5971
|
| Posted: 01/05/2006, 1:58 PM |
|
This probably means that your "sys_resources_tbl " table doesn't contain a field named "record_id" or "Security_Groups" or "User Name" or "Login" or "Password". Actually it looks strange to use so many standards in one table (lower cases, upper cases, underscores, spaces). Are you sure that all such fields exist in your table?
I recommend that you review your security settings in CCS and select correct/existing fields.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
 |
|
|
