add new data in ms access using asp

this is my coding..when i run this coding, it give me an error

Microsoft JET Database Engine (0x80040E07)
Data type mismatch in criteria expression.

anybody can help me

Expand|Select|Wrap|Line Numbers

 
<head>

<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">

<title>processor</title>

</head>
 
<body>

<!--#include file="adovbs.inc"-->
 
<%

dim cstrdes 

dim ccurprice 
 
cstrdes = request.form("des")

scurprice = request.form("price") 
 
dim objconn

set objconn = server.createobject("ADODB.connection")

objconn.provider = "Microsoft.Jet.OLEDB.4.0"

objconn.ConnectionString = "Data Source=" & Server.MapPath("product.mdb")

objconn.mode = 3

objconn.open
 
mysql= "insert into processor(description,price) values ('cstrdes','ccurprice');"

objconn.execute(mysql)
 
 response.redirect("home.asp") %>
 
</body>

</html>

Sep 18 '07 #1

Follow Post Reply

1413

jhardman

3,406

Expert 2GB

The problem is in the line:

mysql= "insert into..."

I try to avoid using insert statemnets (you can accomplish the same effects with codes that seem simpler to me) but I believe that you need something more like this:

Expand|Select|Wrap|Line Numbers

 mysql = "INSERT INTO processor(description, price) VALUES ('"

mysql = mysql & cstrdes & "','" & ccurprice & "');"

This may still cause an error if I understand your code right. Only strings are supposed to be in single quotes and ccurprice is probably numeric. I can't tell cstrdes is supposed to be, but I will assume it is a string, in which case the line should look like this (I'm just taking out the single quotes around ccurprice)

Expand|Select|Wrap|Line Numbers

 mysql = "INSERT INTO processor(description, price) VALUES ('"

mysql = mysql & cstrdes & "'," & ccurprice & ");"

Let me know if this works.

Jared

Sep 18 '07 #2

najmi

The problem is in the line:

mysql= "insert into..."

I try to avoid using insert statemnets (you can accomplish the same effects with codes that seem simpler to me) but I believe that you need something more like this:

Expand|Select|Wrap|Line Numbers

mysql = "INSERT INTO processor(description, price) VALUES ('"

mysql = mysql & cstrdes & "','" & ccurprice & "');"

This may still cause an error if I understand your code right. Only strings are supposed to be in single quotes and ccurprice is probably numeric. I can't tell cstrdes is supposed to be, but I will assume it is a string, in which case the line should look like this (I'm just taking out the single quotes around ccurprice)

Expand|Select|Wrap|Line Numbers

mysql = "INSERT INTO processor(description, price) VALUES ('"

mysql = mysql & cstrdes & "'," & ccurprice & ");"

Let me know if this works.

Jared

thanks Jared..your already help me..your code work perfectly..thank again
erm..maybe you can give me your email so i can ask your help again

Sep 19 '07 #3

jhardman

3,406

Expert 2GB

thanks Jared..your already help me..your code work perfectly..thank again
erm..maybe you can give me your email so i can ask your help again

I'd like to keep questions in the forum in case it would help someone else, but if you want my help in particular, feel free to send me a PM asking me to look into a particular thread. Of course if you want me to look over sensitive information I guess we can bend the rules a bit...

Jared

Sep 19 '07 #4

Post your reply

Similar topics