 |
|
code คือ
<%
sRef_number=request.form("sRef_number")
sdate=request.form("sdate")
swork_to_do=request.form("swork_to_do")
sId_employee=request.form("sEMP_ID")
sstart_time_to_service=request.form("sstart_time_to_service")
send_time_to_service=request.form("send_time_to_service")
scheck_complete_or_no=request.form("scheck_complete_or_no")
sId_customer=request.form("sId_customer")
ssatified_in_service=request.form("ssatified_in_service")
slist_of_service=request.form("slist_of_service")
Sql="insert into service_report(Ref_number,[date],work_to_do,EMP_ID,start_time_to_service,end_time_to_service," & _
"check_complete_or_no,Id_customer,satified_in_service,list_of_service)values('" &sRef_number&"','"&sdate&"','"&swork_to_do& "'," & _
"'"&sEMP_ID& "','" &sstart_time_to_service& "','"&send_time_to_service& "','"&scheck_complete_or_no& "','"&sId_customer& "'," & _
"'"&ssatified_in_service& "','"&slist_of_service& "')"
Set Conn=Server.CreateObject("ADODB.Connection")
Conn.Open("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("test_project_update.mdb"))
set rs=Conn.execute(Sql)
'response.write(Sql)
response.redirect "sql_ex_main(edit).asp"
%>
------------------------------------------------------------------------------------------------
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E07)
[Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.
/project/sql_ex_insert2(edit).asp, line 19
-----------------------------------------------------------------------------------------------
Tag : - - - -
|
|
|
 |
 |
 |
 |
| Date :
27 ธ.ค. 2550 22:54:47 |
By :
beginner |
View :
1885 |
Reply :
4 |
|
 |
 |
 |
 |
|
|
|
|
 |
