mismatch error

[psyren]

Sorry i got a problem in this page its actually an action page for a insertin page.. but when i insert values in the insert page and the action page responded i'm gettin a mismatch criteria... what is that anyways? but i thoroughly checked all the phrases i use are the same.... well if theres any way u guys can explain to me i appreciate the help or point out what ive done wrong? TANKX here's da source code ive done in the page





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

<%
'On Error Resume Next

proj_id= Request("proj_id")
proj_title = Request("proj_title")
submission_date= Request("submission_date")
nameA= Request("nameA")
s1_class= Request("s1_class")
planned_d =Request("planned_d")
planned_d2 =Request("planned_d2")
planned_d3 =Request("planned_d3")
planned_d4 =Request("planned_d4")
planned_d5 =Request("planned_d5")
planned_d6 =Request("planned_d6")
dc =Request("dc")
dc2 =Request("dc2")
dc3 =Request("dc3")
dc4 =Request("dc4")
dc5 =Request("dc5")
dc6 =Request("dc6")
status_r =Request("status_r")
status_r2 =Request("status_r2")
status_r3 =Request("status_r3")
status_r4 =Request("status_r4")
status_r5 =Request("status_r5")
status_r6 =Request("status_r6")
cap =Request("cap")
cap2 =Request("cap2")
cap3 =Request("cap3")
cap4 =Request("cap4")
cap5 =Request("cap5")
cap6 =Request("cap6")




set rs = server.createObject("ADODB.Recordset")
RS.open "pr", canvasDB, adLockOptimistic, adCmdTable

theSQL = "insert into pr"
theSQL = theSQL & "([proj_id], [proj_title], [submission_date], [name], [s1_class], [planned_d], [planned_d2], [planned_d3], [planned_d4], [planned_d5], [planned_d6], [dc], [dc2], [dc3], [dc4], [dc5], [dc6], [status_r], [status_r2], [status_r3], [status_r4], [status_r5], [status_r6], [cap], [cap2], [cap3], [cap4], [cap5], [cap6])"
theSQL = theSQL & " values ('"&proj_id&"', '"&proj_title&"', '"&submission_date&"', '"&nameA&"', '"&s1_class&"', '"&planned_d&"', '"&planned_d2&"', '"&planned_d3&"', '"&planned_d4&"', '"&planned_d5&"', '"&planned_d6&"', '"&dc&"', '"&dc2&"', '"&dc3&"', '"&dc4&"', '"&dc5&"', '"&dc6&"', '"&status_r&"', '"&status_r2&"', '"&status_r3&"', '"&status_r4&"', '"&status_r5&"', '"&status_r6&"', '"&cap&"', '"&cap2&"', '"&cap3&"', '"&cap4&"', '"&cap5&"', '"&cap6&"') "
canvasDB.execute(theSQL)

rs.close
set rs=nothing
canvasDB.close
set canvasDB=nothing
%>







Error Type:
Microsoft JET Database Engine (0x80040E07)
Data type mismatch in criteria expression.
/beta_250204/TMP1psbfucdre.asp, line 49


Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; .NET CLR 1.1.4322)

Page:
GET /beta_250204/TMP1psbfucdre.asp

 

[Genimuse]

Third new topic with the same post, no answer for you.

 

[meckeard]

What is line 49?

Did you try to response.write your SQL string to ensure it is correct?

Mark