【在线求助】ASP插入数据SQL语句问题

如果你的字段不是数字类型 要使用 '"&XX&"' 而不是 "&XX&"
如果全是数字型当我没说 但是我怎么看也不像吧
那就是下面这样
<%
set conn=server.createobject("adodb.connection")
conn.open "driver={microsoft access driver (*.mdb)};dbq="&server.mappath("../data/DongZhouOpen.mdb")

nameStr = request.Form("nameStr")
titleStr = request.Form("title")
authorStr = request.Form("author")
dateStr = request.Form("date")
originStr = request.Form("origin")
amountStr = request.Form("amount")
textStr = request.Form("content1")

dim sql
sql="insert into "&nameStr&"(title,author,date,origin,amount,text) values('"&titleStr&"','"&authorStr&"','"&dateStr&"','"&originStr&"',"&amountStr&",'"&textStr&"')"

conn.execute sql
conn.close
set conn=nothing

response.redirect "../admin/admin.asp?nameStr="&nameStr

%>