J
John Smith
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
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