读书人

请问一个asp有关问题

发布时间: 2012-02-17 17:50:42 作者: rapoo

请教一个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语句看看有毛病没?

读书人网 >ASP

热点推荐