Error with insert into statement

[Ben]

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

 

[Ray at]

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

 

[Bob Barrows [MVP]]

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

 

[Ben]

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.

 

[Bob Barrows [MVP]]

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?

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-us/ado270/htm/dasdkadooverview.asp

In particular, the Execute command is explained here:
http://msdn.microsoft.com/library/en-us/ado270/htm/mdmthcnnexecute.asp

HTH,
Bob Barrows

 

[Ray at]

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