error "80020009"

All that I get is this error: error '80020009' . No description, or anything
else. The error is generated on this line:

getconn.execute("insert into tts_detail values ('" & trim(request("probid"))
& "','1','Assigned','" & RsAssign("priority") & "','" & ttDate & "','" &
RsAssign("phone") & "','Original ticket assignments.','" & session("whois") &
"','n','" & trim(request("assigned")) & "')")

It's a MYSQL Database. I've gone through and checked that all of the
requested variable names are correct, that the RsAssign recordset field names
exist, that there is one value for each field in my tts_detail table, and
that my connection object is valid. Any other ideas of why this error is
coming up. (I also checked to make sure all of the data being entered into
the database is valid.)

Re: error "80020009"

Erica wrote:
> All that I get is this error: error '80020009' . No description, or
> anything else.

Really??? Not even an error source??
Do you have an error handler that's masking this information? I've never
seen an error message consisting solely of an error number with no error
source or description.

> The error is generated on this line:
>
> getconn.execute("insert into tts_detail values ('" &
> trim(request("probid")) & "','1','Assigned','" & RsAssign("priority")
> & "','" & ttDate & "','" & RsAssign("phone") & "','Original ticket
> assignments.','" & session("whois") & "','n','" &
> trim(request("assigned")) & "')")
>
> It's a MYSQL Database. I've gone through and checked that all of the
> requested variable names are correct, that the RsAssign recordset
> field names exist, that there is one value for each field in my
> tts_detail table, and that my connection object is valid. Any other
> ideas of why this error is coming up. (I also checked to make sure
> all of the data being entered into the database is valid.)

Do this:
----------------------------------------------------
Dim sql
sql="insert into tts_detail values ('" & trim(request("probid")) & _
"','1','Assigned','" & RsAssign("priority") & "','" & ttDate & "','" & _
RsAssign("phone") & "','Original ticket assignments.','" & _
session("whois") & "','n','" & trim(request("assigned")) & "')"
'comment out the following 2 lines when finished debugging
Response.write sql
response.end

getconn.execute sql,,129 '129 = adExecuteNoRecords
------------------------------------------------------

Make sure the statement written to the browser window is a valid sql
statement. If MySQL has a native query execution tool, try running the query
in that environment: you may get a better error message, or at least verify
that you've built the sql statement correctly.
If that does not help, check out this article:
http://www.aspfaq.com/show.asp?id=2421

You may wish to try using this easier and more secure method of running your
sql statements:

http://groups-beta.google.com/group/microsoft.public.inetser ver.asp.db/msg/72e36562fee7804e

HTH,
Bob Barrows
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

Re: error "80020009"

Wierd, right? I always get descriptions. It's really frusterating. No error
handler that I know of.

"Bob Barrows [MVP]" wrote:

> Erica wrote:
> > All that I get is this error: error '80020009' . No description, or
> > anything else.
>
> Really??? Not even an error source??
> Do you have an error handler that's masking this information? I've never
> seen an error message consisting solely of an error number with no error
> source or description.
>
> > The error is generated on this line:
> >
> > getconn.execute("insert into tts_detail values ('" &
> > trim(request("probid")) & "','1','Assigned','" & RsAssign("priority")
> > & "','" & ttDate & "','" & RsAssign("phone") & "','Original ticket
> > assignments.','" & session("whois") & "','n','" &
> > trim(request("assigned")) & "')")
> >
> > It's a MYSQL Database. I've gone through and checked that all of the
> > requested variable names are correct, that the RsAssign recordset
> > field names exist, that there is one value for each field in my
> > tts_detail table, and that my connection object is valid. Any other
> > ideas of why this error is coming up. (I also checked to make sure
> > all of the data being entered into the database is valid.)
>
> Do this:
> ----------------------------------------------------
> Dim sql
> sql="insert into tts_detail values ('" & trim(request("probid")) & _
> "','1','Assigned','" & RsAssign("priority") & "','" & ttDate & "','" & _
> RsAssign("phone") & "','Original ticket assignments.','" & _
> session("whois") & "','n','" & trim(request("assigned")) & "')"
> 'comment out the following 2 lines when finished debugging
> Response.write sql
> response.end
>
> getconn.execute sql,,129 '129 = adExecuteNoRecords
> ------------------------------------------------------
>
> Make sure the statement written to the browser window is a valid sql
> statement. If MySQL has a native query execution tool, try running the query
> in that environment: you may get a better error message, or at least verify
> that you've built the sql statement correctly.
> If that does not help, check out this article:
> http://www.aspfaq.com/show.asp?id=2421
>
> You may wish to try using this easier and more secure method of running your
> sql statements:
>
> http://groups-beta.google.com/group/microsoft.public.inetser ver.asp.db/msg/72e36562fee7804e
>
> HTH,
> Bob Barrows
> --
> Microsoft MVP - ASP/ASP.NET
> Please reply to the newsgroup. This email account is my spam trap so I
> don't check it very often. If you must reply off-line, then remove the
> "NO SPAM"
>
>
>

Re: error "80020009"

I found out what it was. I had already moved to the next record of the
RsAssign recordset (which was EOF). When I tried to insert the
RsAssign('priority') value it threw up the error (but still, the no
description thing killed me.) It should of at least read 'EOF or BOF
encountered' and I would of caught it right away. Oh well. All is well that
ends well.

"Bob Barrows [MVP]" wrote:

> Erica wrote:
> > All that I get is this error: error '80020009' . No description, or
> > anything else.
>
> Really??? Not even an error source??
> Do you have an error handler that's masking this information? I've never
> seen an error message consisting solely of an error number with no error
> source or description.
>
> > The error is generated on this line:
> >
> > getconn.execute("insert into tts_detail values ('" &
> > trim(request("probid")) & "','1','Assigned','" & RsAssign("priority")
> > & "','" & ttDate & "','" & RsAssign("phone") & "','Original ticket
> > assignments.','" & session("whois") & "','n','" &
> > trim(request("assigned")) & "')")
> >
> > It's a MYSQL Database. I've gone through and checked that all of the
> > requested variable names are correct, that the RsAssign recordset
> > field names exist, that there is one value for each field in my
> > tts_detail table, and that my connection object is valid. Any other
> > ideas of why this error is coming up. (I also checked to make sure
> > all of the data being entered into the database is valid.)
>
> Do this:
> ----------------------------------------------------
> Dim sql
> sql="insert into tts_detail values ('" & trim(request("probid")) & _
> "','1','Assigned','" & RsAssign("priority") & "','" & ttDate & "','" & _
> RsAssign("phone") & "','Original ticket assignments.','" & _
> session("whois") & "','n','" & trim(request("assigned")) & "')"
> 'comment out the following 2 lines when finished debugging
> Response.write sql
> response.end
>
> getconn.execute sql,,129 '129 = adExecuteNoRecords
> ------------------------------------------------------
>
> Make sure the statement written to the browser window is a valid sql
> statement. If MySQL has a native query execution tool, try running the query
> in that environment: you may get a better error message, or at least verify
> that you've built the sql statement correctly.
> If that does not help, check out this article:
> http://www.aspfaq.com/show.asp?id=2421
>
> You may wish to try using this easier and more secure method of running your
> sql statements:
>
> http://groups-beta.google.com/group/microsoft.public.inetser ver.asp.db/msg/72e36562fee7804e
>
> HTH,
> Bob Barrows
> --
> Microsoft MVP - ASP/ASP.NET
> Please reply to the newsgroup. This email account is my spam trap so I
> don't check it very often. If you must reply off-line, then remove the
> "NO SPAM"
>
>
>