Forums > WebThang Tutorials

Subject: Error Type: ADODB.Field (0x800A0BCD)

Posted By	Message
rush2004 Sun 1st Aug '09 19:17 user	Tutorial: The Dreamweaver MX Files part 3 [View Tutorial] Hi, I have been trying to edit my record and getting this error message: Error Type: ADODB.Field (0x800A0BCD) Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record. The fields of my form are as below: First Name Second Name Company Email Website Date Joint User Name Password I have no problem in updating the fields - all work fine BUT when I try to update "User Name" field, it give me such error. This gave me reall headache and just wondering if this got anything to do with reserved words or something which I am not sure what to do with this. Please help .... Thank You, Bono
suehami Tue 3rd Aug '09 21:25 user	thats an odd error for an update, can you post a bit more code particularly the line the error is indicating.
rush2004 Wed 4th Aug '09 15:59 user	Hi sue, Thanks for d reply. This is the page for member updating their profile after they login. The fields of my form are as below: First Name Second Name Company Email Website Date Joint User Name Password They can update all fields except the User Name field which gave the error msg. This how it work. member login to member section member update info - thankyou message appear saying its been succesfuly updated within 5 sec the thankyou page refresh back to welcome.asp and this when the error message appear. Error Type: ADODB.Field (0x800A0BCD) Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record. Thank you Sue n looking forward for the solution :)
suehami Wed 4th Aug '09 16:44 user	Hi rush so the error is appearing on the welcome page not the updating page? I'd suspect the userID thats being used to grab the details isn't being passed back to the welcome page. Also if you think there's a problem with the field name then try changing that and any corresponding code. Sue
rush2004 Sat 7th Aug '09 19:17 user	Thanks for your reply again Sue:) I think the best way why dont u look at the site yourself n try to login. Can u gimme ur email add, so I can let u know ur login :) dont want the whole world login to my under construction site n giving error message:P It just dont look preety :) ha Can u send me an email. Thanxs
rush2004 Sun 1st Aug '09 18:54 user	Hi Sue, ------------ Also if you think there's a problem with the field name then try changing that and any corresponding code. ------------ I have try to do that by changing the field of name of that particluar field ie.user name into my_username thinking that username maybe one of the reserve word for access but still giving me that error when refresh to welcome.asp Send me an email and I will send u the test user name n password so u can see it better. Thanks, Rush
suehami Sun 1st Aug '09 1:19 user	Hi rush sorry but not sure how i can give you an email address without giving my email address to everyone :o) Not sure that me running through the login process is really going to tell me anything more than you've already explained here anyway. As I said it looks to me like the problem is that the userID isn't being passed back to the welcome page after the update Sue
suehami Sun 1st Aug '09 1:21 user	doh !! are you using the username field for the restricted access ? i.e. is it a DW login you've used? If so then the new username wont be recognised as its has been changed! you need to be using the userID rather than the username to grab the recordset. Sue
rush2004 Fri 6th Sep '09 15:52 user	ahhh...that could b the problem Sue. mmmm..i will have alook at that n let u know:) ha...its cool not giving me yerr email add otherwise u know one thing lead to another ...sue can I have your phone number as well..hehhe just kidin` am 1/2 way accross the world from ya.
rush2004 Tue 3rd Sep '09 14:08 user	Hi Sue, I have change welcome.asp record set to be filtered by Filter ID = Session variable MM_UserName but this gave me an error message Error Type: ADODB.Command (0x800A0D5D) Application uses a value of the wrong type for the current operation. /websites/fj/welcome.asp, line 62 While when I was using the original setting ie. Filter UserName= Session Variable MM_Username it works BUT when I need to Edit the information such as User Name then all the trouble started as mentioned to u earlier. From your question: "are you using the username field for the restricted access ?" I am using a field called "access" that restrict access base on username, password and acces level. In that access field, I setup 1 and 2 where 1 is admin and 2 are visitors. Thanks Sue n looking forward for ur solution. RS
suehami Wed 4th Sep '09 23:17 user	Hi Rush See that's what i think the problem is, your using the username that the user logged in with within the Session Username/access, but the user is then changing that username so the recordset is not returning the values, hence nullifying the access, if you follow me :o) My guess is you're going to need to change the system Session user_ID and not the username. On the login do the checks for username password combo but then grab the user_ID thereafter. Sue
rush2004 Wed 4th Sep '09 12:19 user	Hi Sue, Thanks for the reply. Yes I got wot u talkin` about :p Thats what I figure it out too and do i just need to tweek the welcome page only or the login page as well? Rush
suehami Wed 4th Sep '09 18:02 user	Hi Rush I think what you need to do is swap the login and access protection code to use session("User_ID") rather than Session("User_Name") Sue
rush2004 Thu 5th Oct '09 14:04 user	Hi Sue, Yes, its working and thanks for all your help. I will buy u beer next time I cya :P Webthag still the best! Rs
suehami Thu 5th Oct '09 17:29 user	Hi Rush I'm glad you finally managed to get it sorted :o) I'll hold you to that beer ;o) Sue
rush2004 Fri 6th Oct '09 12:07 user	Hi Sue, Actually it did not work ( i was thinking it was) when I filter the record set using, id= seasion variable=MM_username it gave me an error message like this Error Type: ADODB.Command (0x800A0D5D) Application uses a value of the wrong type for the current operation. /websites/creativerush/welcome.asp, line 41 the reason why i filter using Username because when loged in I want to bind their 1st name into the welcome.asp. So when u login the page greeted you like Hi Sue, welcome to my page. This one worked as one of Gordon example using Filter ------ username= Seassion Variable ---------- MMUsername but the problem back to square one again where user can not edit their username. Sorry Sue this may sound very confusing. Hope u get my drift:) May hold the beer at the moment :) Let me know wot do u think. Thank You
suehami Fri 6th Oct '09 18:25 user	Hi Rush Maybe I've got the wrong end of the stick here but what I'm explaining to you will work if you do it properly. 1. User logs in using current username and password - once they login in you grab the user_ID and use this to fill a session var i.e Session("UserID") this would then replace any instances where you use this Filter ------ username=Seassion Variable ---------- MMUsername so this would become Filter ------ userID=Seassion Variable ---------- MMUserID You can then grab any info you want from that users details filtering by UserID, you can access their real name, username, current or updated, password any other details that are held in the table. Hope that makes some sense Sue
rush2004 Sat 7th Oct '09 5:46 user	Hi Sue, I have change the binding recordser setting as your instruction Filter ID = Seassion Variable...........MMUserID but gave me this error Error Type: ADODB.Field (0x800A0BCD) Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record. /websites/creativerush/welcome.asp, line 273 Any idea? thxs, RS
suehami Tue 3rd Oct '09 1:20 user	Hi Rush I think I need to see some more code :o) We do seem to be going around in circles here .... I'm really not sure where to suggest looking next! Sue
rush2004 Sun 1st Oct '09 17:58 user	Hi Sue, Thanks for all ur support ;) Rush
rush2004 Wed 4th Nov '09 16:03 user	Hi Sue, I have recently try again this problem and now I know wot is the problem. The reason why It did not work cos I applied the wrong filter in the recordset into on the wrong pages. Duh....silly moi :P Anyway its working again the way I want it and thanks for all ur support. By the way Web Thag still going to publish new tutorial in the near future? Thanks Sue, the beer is on me again ..... cheeers, Rush