28,390
社区成员
发帖
与我相关
我的任务
分享
<%
ID=Request.Form("ID")
stitle1=request.form("title1")
stitle2=request.form("title2")
Action=request("Action")
set rs=server.createobject("adodb.recordset")
select case Action
case "Add"
sql="select * from cname where (id is null)"
rs.open sql,conn,1,3
rs.addnew
rs("stitle1")=stitle1
rs("stitle2")=stitle2
rs.update
rs.close
set rs=nothing
response.redirect "index.asp"
Case else
founderr=true
errmsg=errmsg+" <li>没有选定参数 </li>"
call WriteErrMsg()
end select
call CloseConn()
%>
sub SaveData()
rs("stitle1")=stitle1
rs("stitle2")=stitle2
end sub
select case Action
case "Add"
sql="select * from cname where (id is null)"
rs.open sql,conn,1,3
rs.addnew
call SaveData()
rs.update
rs.close
set rs=nothing
response.redirect "index.asp"
Case else
founderr=true
errmsg=errmsg+" <li>没有选定参数 </li>"
call WriteErrMsg()
end select
<form method="POST" name="myform" onSubmit="return CheckForm();" action="save.asp?action=Add" target="_self" >
<select name="title1" size="1" >
<%while not rs.eof%>
<option selected value=" <%=fields(rs("title"))%>"> <%=rs.fields("title")%> </option>
<%rs.movenext
wend%>
</select>
<%
rs.movefirst
%>
<select name="title2" size="1" >
<%while not rs.eof%>
<option selected value=" <%=fields(rs("title"))%>"> <%=rs.fields("title")%> </option>
<%rs.movenext
wend%>
</select>
<input type="submit" name="Submit" value="提交" class="input">
</form>