ورود

View Full Version : insert



enteraks13
جمعه 23 مرداد 1388, 14:54 عصر
sqltxt = "INSERT INTO flyinf (Flynumber, Company , Airplane , FlyingTime , State , From,To) VALUES (" & Request.Form("Flynember") & "," & Request.Form("Company") & "," & Request.Form("Airpane") & ","&Request.Form("Flying Time") & "," & Request.Form("Flying Date") & ","&Request.Form("State") & ","&Request.Form("From") & "," & Request.Form("To")
objconn.Execute(sqltxt)




این دستور این ارور رو داره



Error Type:
Microsoft JET Database Engine (0x80040E14)
Syntax error in INSERT INTO statement.
/insert.asp, line 11




در حالیکه مشکل سینتکسی نداره ؟!

smderfan
شنبه 24 مرداد 1388, 14:19 عصر
سلام
کد مورد نظر رو به یک کوئری اضافه کن و در کوئری تست کن. (SQL View)