为什么一种可以,一种不可以呢?大家能看看吗?
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!-- #include file="connect.asp" -->
<%
if Request.QueryString("action")="add" then
level=Request.form("level")
describe=Request.form("describe")
' response.write level&" "&describe
set rs=Server.CreateObject("ADODB.Recordset")
sql="select count(*) as num from tab_prize_info where p_info_level='"&level&"' and p_info_describe='"&describe&"'"
rs.open sql,conn,1,3
'response.write rs("num")
if rs("num")=0 then
'sql="insert into tab_prize_info (p_info_id,p_info_level,p_info_describe) values('','"&level&"','"&describe&"')"
'rs.open sql,conn,1,3
'conn.execute(sql)
set rs=Server.CreateObject("ADODB.Recordset")//这句和下句随便去掉一句都显示错误,两句都去掉也错,为什么?唉,弄不清楚
sql="select * from tab_prize_info"
rs.open sql,conn,1,3
rs.addnew
'rs("p_info_level")=level
'rs("p_info_describe")=describe
rs("p_info_level")=level
rs("p_info_describe")=describe
rs.update
else
end if
Response.Redirect "prize.asp"
end if
%>