|
| |
|
|
xterradane
Posts: 143
From: Mobile, AL USA
Status: offline
 |
ASP problems-any ideas? - 8/22/2001 18:39:00
Here is my error message:
ADODB.Recordset error '800a0bcd' Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record. (line 29) Here is my code: <% Dim rsUsers
Set rsUsers = Server.CreateObject ("ADODB.Recordset")
rsUsers.Open "UserRegistration", objConn, adOpenForwardOnly, adLockOptimistic, adCmdTable
If Session("EMail") <> " " Then
rsUsers.Filter = "EMail = '" & Session("EMail") & "'"
Else
rsUsers.Filter = "EMail = ' " & Request.Form("EMail") & "'" &_
"AND Password = '" & Request.Form("Password") & "'"
If rsUsers.EOF Then
rsUsers.AddNew
End If
End If
(line 29) rsUsers("EMail") = Request.Form("EMail")
rsUsers("Password") = Request.Form("Password")
rsUsers("FirstName") = Request.Form("FirstName")
rsUsers("LastName") = Request.Form("LastName")
rsUsers.Update
Dim strName, strValue
For each strField in rsUsers.Fields
strName =strField.Name
strValue =strField.Value
Session(strName)= strValue
Next
Session("blnValidUder")=True
Response.Redirect "MyProfile.asp"
%>
Thanks,
Gail
|
|
|
|
xterradane
Posts: 143
From: Mobile, AL USA
Status: offline
|
RE: ASP problems-any ideas? - 8/23/2001 20:50:00
I've tried several other ways as well. I got the code from Wrox's Beg ASP 3.0 and it just doesn't want to work for me. I actually posted a question on their site forums hoping for some help. But all I got was some rude answers because I could not fix the problem after their first response. It made me appreciate this forum all the more! I know I will figure it our eventually, just thought someone could take a quick look and save me some time.Gail
| |
|
|
|
Spooky
Posts: 26599
Joined: 11/11/1998
From: Middle Earth
Status: offline
|
RE: ASP problems-any ideas? - 8/23/2001 20:30:00
Its not a format Id use, but try this :If Session("EMail") <> " " Then
rsUsers.Filter = "EMail = '" & Session("EMail") & "'"
Else
rsUsers.Filter = "EMail = ' " & Request.Form("EMail") & "'" &_
"AND Password = '" & Request.Form("Password") & "'"
End If If rsUsers.EOF OR rsUsers.BOF Then
rsUsers.AddNew
End If
Youve got the latest mdac ? Id prefer using SQL rather than the .filter or table.
http://www.aspfaqs.com/aspfaqs/ShowFAQ.asp?FAQID=106
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
