Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > ASP General > 0x80020009 Error

Reply
Thread Tools

0x80020009 Error

 
 
John Smith
Guest
Posts: n/a
 
      06-13-2004
Hi,

I am just trying to do a fairly boring bit of DB maintainence that involves
getting the correct ID from table2 by matching it with the email field of
table2, easy I thought !

Unfortuantley I get a 0x80020009 'Exception Occured' whenever I try to run
this. I originally thought that it could be because the email from the first
table isn't actually in the second table, sadly there are too many to
manually check, so the idea might have to be completely thrown out of the
window.

Could anyone shed any light on why it wouldn't run apart from the data not
matching ?

Thanks

J.




strQuery ="SELECT email_add,userid FROM email_check"
set objRS = objConn.Execute(strQuery)

Do Until objRS.EOF

strQuery1 ="SELECT userid,email_add FROM events_one WHERE email_add='" &
objRS("email_add") & "'"
set objRS1 = objConn.Execute(strQuery1)

Response.Write(objRS1("userid") & " " & objRS1("email_add") & "<br>")

objRS.MoveNext
Loop


 
Reply With Quote
 
 
 
 
Evertjan.
Guest
Posts: n/a
 
      06-13-2004
John Smith wrote on 13 jun 2004 in
microsoft.public.inetserver.asp.general:

> Unfortuantley I get a 0x80020009 'Exception Occured'
>
> strQuery ="SELECT email_add,userid FROM email_check"
> set objRS = objConn.Execute(strQuery)
>
> Do Until objRS.EOF
>
> strQuery1 ="SELECT userid,email_add FROM events_one WHERE email_add='"
> & objRS("email_add") & "'"
> set objRS1 = objConn.Execute(strQuery1)
>
> Response.Write(objRS1("userid") & " " & objRS1("email_add") & "<br>")
>
> objRS.MoveNext
> Loop
>


strQuery ="SELECT email_add,userid FROM email_check"
set objRS = objConn.Execute(strQuery)

Do Until objRS.EOF
Response.Write "====== " & objRS("userid") & " =====<br>"

strQuery1 ="SELECT userid,email_add FROM events_one"&_
" WHERE email_add='" & objRS("email_add") & "'"

set objRS1 = objConn.Execute(strQuery1)

If not objRS1.EOF then ' could be none
Do Until objRS1.EOF 'could be more than one
Response.Write objRS1("userid") & " " &_
objRS1("email_add") & "<br>"
objRS1.MoveNext
Loop
Else
Response.Write "No corresponding email_adds found<br>"
End If
objRS.MoveNext
Loop

not tested !!

--
Evertjan.
The Netherlands.
(Please change the x'es to dots in my emailaddress)
 
Reply With Quote
 
 
 
 
John Smith
Guest
Posts: n/a
 
      06-13-2004
<snip>
>
> not tested !!
>
> --
> Evertjan.
> The Netherlands.
> (Please change the x'es to dots in my emailaddress)


Very cunning ! There was one missing & now my original code works fine as
well )

Dunno why I didn't think of that, obviously a long day !

Thanks

J.


 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0xffc Thread 0x228 DBC 0x437b94 Jet'. ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr bazzer ASP .Net 0 03-30-2006 03:16 PM
Error connecting to SQLExpress 2005 locally (error: 26 - Error Locating Server/Instance Specified) hfk0 ASP .Net 2 03-27-2006 08:43 PM
ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x8fc Thread 0x934 DBC 0x437b94 Jet'. ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr bazzer ASP .Net 1 03-24-2006 04:20 PM
ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x8fc Thread 0x934 DBC 0x437b94 Jet'. ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr bazzer ASP .Net 0 03-24-2006 02:22 PM
Error 500: ERROR: Cannot forward. Writer or Stream already obtained. Error JavaQueries Java 1 03-01-2005 06:30 PM



Advertisments