[ÇóÖú]Óï¾äûÓнáÊø

ÌìÓïÓÆÓÆ

´íÎóÀàÐÍ£º
Microsoft VBScript ±àÒëÆ÷´íÎó (0x800A0401)
Óï¾äδ½áÊø
/luntan/zhucecg.asp, line 27, column 50
sql="insert into user values('"&u_name&"','"&u_pwd"','"&p1&"','"&p2"','"&u_email&"','"&u_adress&"','"&u_url&"')"
-------------------------------------------------^
ÕâÊÇÔõô»áʦÄØ£¬ÔõôÏÔʾÓï¾äûÓнáÊøÄØ£¿
´úÂ룺
<!--#include file="conn.asp"-->
<%
u_name=trim(request.Form("name"))
u_pwd=trim(request.Form("pwd"))
u_email=trim(request.Form("email"))
u_adress=trim(request.Form("adress"))
u_url=trim(request.Form("url"))
p1=request.Form("p1")
p2=request.Form("p2")
set rs=server.CreateObject("adodb.recordset")
sql="select * from user where u_name='"&u_name&"'"
rs.open sql,conn,1,1
if not rs.eof then
response.Write("Óû§ÒѾ­´æÔÚ£¬ÇëÖØÐÂÊäÈ룡")
rs.close
set rs=nothing
else
set rs=server.CreateObject("adodb.recordset")
sql="insert into user values('"&u_name&"','"&u_pwd"','"&p1&"','"&p2"','"&u_email&"','"&u_adress&"','"&u_url&"')"
rs.open sql,conn,1,1
rs.close
conn.close
set rs=nothingse
set conn=nothing
end if

¤×¤×

sql="insert into user values('"&u_name&"','"&u_pwd"','"&p1&"','"&p2"','"&u_email&"','"&u_adress&"','"&u_url&"')"
-------------------------------------------------^

¿´¿´´íÎóÌáʾ×îºóÄǸöÏòÉϵÄС¼ýÍ·£¬ÄÇÀïÉÙÁËÒ»¸ö&