想把数据插入到一个mysql表中出现..高手快来看看吧
Microsoft OLE DB Provider for ODBC Drivers 错误 '80040e14'
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Index,Type,ItemID,ItemVer,Money,ChrID,time) values ('6429',1,'135447738,431,0,0,' at line 1
/admin/auSave.asp，行 20
下面是整个代码,,,
<% if Session("test_status") <> "login" then response.redirect "login.asp" %>
<!--#include file="config.asp" -->
<%
Response.expires = 0
Response.expiresabsolute = Now() - 1
Response.addHeader "pragma", "no-cache"
Response.addHeader "cache-control", "private"
Response.CacheControl = "no-cache"
strconnection="driver={mysql odbc 3.51 driver};database="&FsoName&";server="&ServerName&";uid="&dataLogName&";password="&dataPwd&""
set adodataconn = server.createobject("adodb.connection")
adodataconn.open strconnection
index= request("id")+3000
itemid=Request.Form("items")
money=Request.Form("Gold")
ChrID= request("id")
strsql="insert into t_auction_result(Index,Type,ItemID,ItemVer,Money,ChrID,time) values ('"&Index&"',1,'"&ItemID&"',11,'"&Money&"','"&ChrID&"',3600)"
adodataconn.execute(strsql)
rs.close
response.Write"<script language='javascript'>alert('ok!');history.back();</script>"
response.End
%>