inster into错误
<%
dim username
dim text
username=request.Form( "name ")
text1=request.Form( "text ")
db= "db1.mdb "
Set conn = Server.CreateObject( "ADODB.Connection ")
connstr= "Provider=Microsoft.Jet.OLEDB.4.0;Data Source= " & Server.MapPath(db)
'connstr= "driver={Microsoft Access Driver (*.mdb)};dbq= " & Server.MapPath(db)
conn.Open connstr
Set con = Server.CreateObject( "ADODB.Recordset ")
sql= "insert into user(name,text) values ( ' " & username & " ', ' " & text1 & " ') "
con.open sql,conn,1,3
sql1= "select * from user "
con.open sql1,conn,1,3
response.write con( "name ")
set con=nothing
set conn=nothing
%>
错误类型:
Microsoft JET Database Engine (0x80040E14)
INSERT INTO 语句的语法错误。
/liuyan.asp, 第 22 行
数据库中就NAME和TEXT两个字段,望大家帮帮小第。
------解决方案--------------------保留字问题sql= "insert into [user]([name],[text]) values ( ' " & username & " ', ' " & text1 & " ') "