How to indicate you are going straight? When you think ASP, think... Charging the company I work for to rent from myself Can drained water from potted plants be used again to water another house plant? Also, when you say a refresh sometimes fixes it, is the exact same resultset coming back (ie, the row that is erroring is definitely being displayed)? http://www.aspmessageboard.com/showthread.php?9629-catching-database-error-039-8002009-039
Will try getting back to you tomorrow... -= DTS =- 0 Message Author Comment by:sl1nger2007-06-11 What do you think? 0 LVL 9 Overall: Level 9 ASP 9 Message Accepted The recordset contains over 12000 records, bof and eof are false, rs("col1") and rs("col2") can be printed, but Response.write(rs("coldate")) fails with error 80020009. Bill 0 LVL 1 Overall: Level 1 ASP 1 Message Author Comment by:wbwillson2004-10-07 Huji, Actually I do need use brackets around Last and First because those are Reserved Words Has anyone experienced an issue like this?
This video shows the Mac version, but the tool works the same way in Windows. The Original Issue This was written… ASP User Log In Using A Token Article by: Scott This demonstration started out as a follow up to some recently posted questions on the Solved ADODB.Field Error '8002009' Posted on 2004-10-07 ASP 1 Verified Solution 13 Comments 1,698 Views Last Modified: 2011-09-20 I'm getting this error on my page: ADODB.Field error '80020009' Either BOF or https://support.microsoft.com/en-us/kb/193451 The database has been running for years, and all queries in the past have been succesful.
In my coding, there is a connection to a 2nd database which lists headings. With your WHILE WEND loop you are just checking if myRs has not reached to the EOF. I have one customer who experiences failure dialogs when registering several of the ComponentOne components. After extensive support, I've narrowed down the list of offending components to: tishare6.dll, ticon3d6.ocx, tidate6.ocx, tinumb6.ocx, and line 17 of my success page seem to have something wrong with it:- Can anyone see anything glaringly obviously wrongwith the following script: set rs_customer = server.createobject("adodb.recordset") sql_code = "SELECT
machines, and I've had no problems with the components on XP in the past. (Installed base of about 1200 users.) Thank you in advance for your help. Huji 0 LVL 14 Overall: Level 14 ASP 10 Message Expert Comment by:huji2004-10-07 I mean why do you use those brackets (i.e. [ and ] ) in your SQL command? after the error, err.number always equals 0 and i don't get anywhere... Finally, I have found a workaround.
The time now is 02:39 AM. You Go to Solution 13 Comments LVL 1 Overall: Level 1 ASP 1 Message Author Comment by:wbwillson2004-10-07 Increased the points 0 LVL 14 Overall: Level 14 ASP 10 Message Unregistering/reregistering - to no avail. Sorry for the joke.
These do register successfully: olch2x7.ocx, tdbg7.ocx, ticalcx6.dll, ticaldr6.ocx, ticon4d6.ocx, tidatex6.dll, tifincx6.dll, tiholyx6.dll, timask6.ocx, tinumbl6.ocx, tizonex6.dll, xadb7.ocx, xarray32.ocx, xarraydb.ocx. Also, humor me with this one -- start by replacing these lines: ========================================= rs.fields("webi_id") = clng(Request.QueryString("id")) rs.fields("first_name") = objXML.selectSingleNode("//first_name").text rs.fields("last_name") = objXML.selectSingleNode("//last_name").text rs.fields("email") = objXML.selectSingleNode("//email").text ========================================= With these: ========================================= rs.fields("webi_id") = You don't need them! At this point I was wondering whether Oracle had some how managed to store a damaged date, so I wrote a small query using SQL to do a comparison on the
Fabrice ZERROUKI Wanna chill out? Guus says: November 4, 2005 at 7:25 pm Hi Al, I did try to_date(coldate, ‘YYYY-MM-DD'), but with no success. u might have to explain exactly what u r trying to do and also provide more code .. 0 LVL 14 Overall: Level 14 ASP 10 Message Expert Comment by:huji2004-10-07
The target machine is running Windows XP Pro, SP2. 1GB Memory, Athlon 64 processor. But you can still mark it as answer if it's helped you. While searching around how I can accomplish this I stumbled across a great article that stated "minimize the server requests." I got to thinking, hey, I use more than one… ASP I know that this error usually means that the record I'm trying to pull from a table doesn't exist or the table is empty.
Set your error text here. The target machine is running Windows XP Pro, SP2. 1GB Memory, Athlon 64 processor. More details: We're connecting with the Oracle Provider for OLE and the MDAC version is 2.80.1022.3 Guus gloria says: November 18, 2005 at 12:23 am try with this if u r If I put it outside the Loop its FALSE.
Have you heard of anyone else having a similar problem?