请教一个asp问题
错误类型：
Microsoft VBScript 编译器错误 (0x800A0408)
无效字符
/xitong/lunwen/addsave.asp, line 6, column 20
rs.open sql,conn,1,3
代码:
<%@LANGUAGE= "VBScript " codepage= "936 "%>
<!--#include file= "conn.asp "-->
<%
set rs=server.CreateObject( "adodb.recordset ")
sql= "select user,email,content from main "
rs.open sql,conn,1,3
rs.addnew
rs( "user ")=request.form( "user ")
rs( "email ")=request.form( "email ")
rs( "content ")=request.form( "content ")
rs.update
rs.close
set rs=nothing
conn.close
set conn=nothing
%>
数据库已设计为完全控制状态,完全用半角
[解决办法]
conn打开没?
[解决办法]
这样写试试
select [user],email,content from main
[解决办法]
<%
set rs=server.CreateObject( "adodb.recordset ")
sql= "select [user],email,content from main where 1=0 "
rs.open sql,conn,1,3
rs.addnew
rs( "user ")=request.form( "user ")
rs( "email ")=request.form( "email ")
rs( "content ")=request.form( "content ")
rs.update
rs.close
set rs=nothing
conn.close
set conn=nothing
%>
[解决办法]
如果conn连接是对的
把
sql= "select user,email,content from main "
rs.open sql,conn,1,3
换成这样试试
Rs.Open "select * from main ",conn,1,3
[解决办法]
sql= "select user,email,content from main "
response.write(sql)
response.end()
这样输出一下SQL语句看看有毛病没？
