Question

insert into语句的语法错误。。 用的是ASP和ACCESS

<%
If Request.Form("book")<>"" And Request.Form("author")<>"" Then
book=Request.Form("book")
author=Request.Form("author")
If Request.Form("price")<>"" Then
price=Request.Form("price")
Else
price=0
End If
txtcalss=Request.Form("class")
publish=Request.Form("publish")
photo=Request.Form("photo")
num=Request.Form("num")
txtIntro=Request.Form("memo")
Dim conn,strConn
Set conn=Server.CreateObject("ADODB.Connection")
strConn="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("../db/db1.mdb")
conn.Open strConn
Dim strSql
strSql="Insert Into Book(book,author,price,class,publish,photo,num,memo) Values('" & book & "','" & author & "'," & price & ",'" & txtclass & "','" & publish & "','" & photo & "'," & num & ",'" & txtIntro & "')"
conn.Execute(strSql)
Response.Redirect "update_form.asp"
End If
%>
系统说 conn.Execute(strSql) 这行错误，请各位大虾帮忙解决下，谢谢

Answer 1

这句改为
strSql="Insert Into Book(book,author,price,class,publish,photo,num,memo) Values('" & book & "','" & author & "','" & price & "','" & txtclass & "','" & publish & "','" & photo & "','" & num & "','" & txtIntro & "')"

Answer 2

电话号码不是字符型吧.还有NIM等 如果不是就不要用引号

Answer 3

strSql
把这个打印出来看下sql语句有没有问题