«

Im trying to insert some information into a database, but every time that I
try, I get this error. Any ideas?

----Error----
0x80040E07, activity_log.asp, line 967

----Code-----
strSQL= "INSERT INTO tblUsers (rufitPoints, totalPoints, intLevel) VALUES ( '"
& intRufitPoints & "' , '" & intTotalPoints & "' , '" & rufitLevel & "')"
-= 967=- Set rsPointsUpdate = adoCon.Execute(strSQL)

----Table----
-------------------------------------
rufitPoints | totalPoints | intLevel |
-------------------------------------
All of the Field Names are of datatype number.

Thanks

Ben

If all the fields are numeric, do not delimit the values with '.

Also, when posting an error, post the description too. Most people don't
have the codes memorized.

Also, when doing an INSERT, don't do a SET RS =. You don't need anything
returned, do you? Instead, do:

adoCon.Execute strSQL,,129

Ray at work

"Ben" <> wrote in message
news: om...
> Im trying to insert some information into a database, but every time that
I
> try, I get this error. Any ideas?
>
> ----Error----
> 0x80040E07, activity_log.asp, line 967
>
> ----Code-----
> strSQL= "INSERT INTO tblUsers (rufitPoints, totalPoints, intLevel) VALUES
( '"
> & intRufitPoints & "' , '" & intTotalPoints & "' , '" & rufitLevel & "')"
> -= 967=- Set rsPointsUpdate = adoCon.Execute(strSQL)
>
> ----Table----
> -------------------------------------
> rufitPoints | totalPoints | intLevel |
> -------------------------------------
> All of the Field Names are of datatype number.
>
> Thanks
>
> Ben

Ben wrote:
> Im trying to insert some information into a database, but every time
> that I try, I get this error. Any ideas?
>
> ----Error----
> 0x80040E07, activity_log.asp, line 967
>
> ----Code-----
> strSQL= "INSERT INTO tblUsers (rufitPoints, totalPoints, intLevel)
> VALUES ( '" & intRufitPoints & "' , '" & intTotalPoints & "' , '" &
> rufitLevel & "')" -= 967=- Set rsPointsUpdate = adoCon.Execute(strSQL)
>
> ----Table----
> -------------------------------------
> rufitPoints | totalPoints | intLevel |
> -------------------------------------
> All of the Field Names are of datatype number.
>
> Thanks
>
> Ben

The first thing you should ALWAYS do when debugging is:
Response.Write strSQL

Look at the statement written to the browser window. Any obvious problems?
If not, copy and paste it from the browser window into the SQL View window
of the Access Query Builder and try and run it. If it is constructed
correctly, it should run witrhout modification. If this still fails to
reveal the problem, post the result of the response.write here.

Bob Barrows

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

Thanks for the information, I finally got it to work.

Bob:
I printed out the strSQL statement and realized that I was
assigning my values incorrectly, after fixing that it
worked perfectly.

Ray:
What does the 129 in this line mean?
>adoCon.Execute strSQL,,129




-=Ben
-=To email me take out the joke.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Ben wrote:
> Thanks for the information, I finally got it to work.
>
> Bob:
> I printed out the strSQL statement and realized that I was
> assigning my values incorrectly, after fixing that it
> worked perfectly.
>
> Ray:
> What does the 129 in this line mean?
>> adoCon.Execute strSQL,,129
>

Since I'm here I'll answer for Ray:

129 is the combination of two values: 1 and 128

1 = adCmdText. It tells ADO that you want it to execute a sql statment
contained in a string. Always supply this argument. Don't make ADO guess
what the command type is:
a) It wastes programming cycles
b) It may (rarely) guess wrong

128 = adExecuteNoRecords This tells ADO that you do not expect to get any
records back from the query you are executing, so it will not waste
resources and processing cycles creating a recordset behind the scenes to
receive a non-existent resultset.

If you are not using Visual Studio, you can find the ADO documentation at
msdn:
http://msdn.microsoft.com/library/en...dooverview.asp

In particular, the Execute command is explained here:
http://msdn.microsoft.com/library/en...cnnexecute.asp

HTH,
Bob Barrows

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

"Bob Barrows [MVP]" <> wrote in message
news:...
>
>
> Since I'm here I'll answer for Ray:

That's good. Your answer is much better than what mine would have been. :]

Ray at home