|
 |
| |
มันผิดตรงไหนคร้าบ Error Type: Microsoft JET Database Engine (0x80040E14) Syntax error i |
| |
 |
|
|
 |
 |
|
Error Type:
Microsoft JET Database Engine (0x80040E14)
Syntax error in INSERT INTO statement.
/ase/csspss_editE.asp, line 220
************************************************************************
SQL = "INSERT INTO Csspss (dte, eTime, CompanyName, ContactName,Position,Category,CompanyAddress,Tel) VALUES (" &_
Request.Form("dte") & ",'" &_
ChkStr(Request.Form("tim")) & "', '" & _
ChkStr(Request.Form("Company")) & "','" & _
ChkStr(Request.Form("Contact")) & "','" & _
ChkStr(Request.Form("Position")) & "','" & _
Request.Form("cat") & "','" & _
ChkStr(Request.Form("address")) & "','" & _
ChkStr(Request.Form("Tel")) & "')"
*************************************************************************
มันผิดตรงไหนคร้าบ
Tag : - - - -
|
|
|
 |
 |
 |
 |
| Date :
1 Apr 2547 09:25:19 |
By :
monnakrub |
View :
2993 |
Reply :
1 |
|
 |
 |
 |
 |
|
|
|
|
 |
 |
|
 |
 |
| |
|
|
|
| |
|
ผมว่าแบบนี้ง่ายกว่านะครับ
Set Conn=Server.Createobject("ADODB.Connection")
Conn.Open "DRIVER=Microsoft Access Driver (*.mdb);DBQ=" & Server.MapPath("db/product.mdb"),"" , ""
'หรือจะใช้เป็น Conn.Open "product","",""
sql ="Select * From product"
Set RS =Server.CreateObject("ADODB.Recordset")
RS.open Sql,Conn,1,3
barcode="P006"
description="หนังสือเล่มที่ 6"
price=350
page=450
writer= "ผู้แต่งคนที่ 6"
Rs.AddNew
Rs("barcode") = barcode
Rs("description") = description
Rs("price") = price
Rs("page") = page
Rs("writer") = writer
Rs.Update
Conn.Close
|
| |
|
|
| |
| Date :
15 Apr 2547 19:08:59 |
By :
webmaster |
|
|
| |
|
|
|
|
|
| |
|
|
|
|
|
| |
|
 Load balance : Server 05
|
