主题:asp写入access的问题
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Syntax error in FROM clause.
/Save.asp, line 7
这是错误代码
<!--#include file="Inc/Conn.asp"-->
<!--#include file="Inc/articleCHAR.INC"-->
<%
Set rs=Server.CreateObject("ADODB.Recordset")
sql="select * from Order"
rs.open sql,conn,1,3 //[color=FF0000]这是第7行[/color]
rs.addnew
rs("BigClass")=trim(request.form("BigClass"))
rs("SmallClass")=trim(request.form("SmallClass"))
rs("Names")=trim(request.form("Names"))
rs("Email")=trim(request.form("Email"))
rs("Sex")=trim(request.form("Sex"))
rs("Coutry")=trim(request.form("Coutry"))
rs("Nation")=trim(request.form("Nation"))
rs("Address")=trim(request.form("Address"))
rs("Calendar")=trim(request.form("Calendar"))
rs("Years")=trim(request.form("Years"))
rs("Months")=trim(request.form("Months"))
rs("Days")=trim(request.form("Days"))
rs("Hours")=trim(request.form("Hour"))
rs("Minutes")=trim(request.form("Minutes"))
rs("PhoneQu")=trim(request.form("PhoneQu"))
rs("PhoneNo")=trim(request.form("PhoneNo"))
rs("Mobile")=trim(request.form("Mobile"))
rs("Remark")=trim(request.form("Remark"))
rs.update
rs.close
set rs=nothing
Response.Write("<script language='JavaScript'>alert('信息提交成功');this.location='Sub.asp';</script>")
%>
是哪里的问题。
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Syntax error in FROM clause.
/Save.asp, line 7
这是错误代码
<!--#include file="Inc/Conn.asp"-->
<!--#include file="Inc/articleCHAR.INC"-->
<%
Set rs=Server.CreateObject("ADODB.Recordset")
sql="select * from Order"
rs.open sql,conn,1,3 //[color=FF0000]这是第7行[/color]
rs.addnew
rs("BigClass")=trim(request.form("BigClass"))
rs("SmallClass")=trim(request.form("SmallClass"))
rs("Names")=trim(request.form("Names"))
rs("Email")=trim(request.form("Email"))
rs("Sex")=trim(request.form("Sex"))
rs("Coutry")=trim(request.form("Coutry"))
rs("Nation")=trim(request.form("Nation"))
rs("Address")=trim(request.form("Address"))
rs("Calendar")=trim(request.form("Calendar"))
rs("Years")=trim(request.form("Years"))
rs("Months")=trim(request.form("Months"))
rs("Days")=trim(request.form("Days"))
rs("Hours")=trim(request.form("Hour"))
rs("Minutes")=trim(request.form("Minutes"))
rs("PhoneQu")=trim(request.form("PhoneQu"))
rs("PhoneNo")=trim(request.form("PhoneNo"))
rs("Mobile")=trim(request.form("Mobile"))
rs("Remark")=trim(request.form("Remark"))
rs.update
rs.close
set rs=nothing
Response.Write("<script language='JavaScript'>alert('信息提交成功');this.location='Sub.asp';</script>")
%>
是哪里的问题。