(ADODB.Command)对象的用法,用CASE调用的REM/DEL/UPDATE/
!--#include file=conn.asp-- %set rs=server.createobject(adodb.recordset) sql=select * from jtopic order by j_id desc rs.open sql,conn,1,1 % script language=javascript function check1(i,o) { document.form.text2.value=i; document.form.word2.va
<!--#include file="conn.asp"-->
<%set rs=server.createobject("adodb.recordset")
sql="select * from jtopic order by j_id desc"
rs.open sql,conn,1,1
%>
<script language="javascript">
function check1(i,o)
{
document.form.text2.value=i;
document.form.word2.value=o;
}
</script>
<form name="form" method="post" action="sort_in.asp">
<br><b> 专题类别:</b>
<input type="hidden" name="options" value=''>
<select name="jtop" id="jtop" onchange="check1(document.form.jtop.options[document.form.jtop.selectedIndex].lable,document.form.jtop.options[document.form.jtop.selectedIndex].title)">
<% do while not rs.eof %>
<option value="<%=rs("j_id")%>" lable="<%=rs("j_name")%>" title="<% =rs("j_flag") %>"><%=rs("j_name")%></option>
<%
rs.movenext
loop
%></select>
<input type="submit" name="Submit" value="删 除" onclick="form.options.value='del'"><p>
<input type="text" name="word1" size=57 value="" maxlength="50" style="width: 369; height: 22">
<input name="tui1" type="radio" id="tui" value="0" checked>默认<font color=red><b>0</b></font>
<input name="tui1" type="radio" id="tui" value="1">推荐<font color=red><b>1</b></font>
<input type="submit" name="Submit1" value="添 加" onclick="form.options.value='new'"> </p><p>
<%set rs=server.createobject("adodb.recordset")
sql="select * from jtopic order by j_id desc"
rs.open sql,conn,1,1
%>
<script language="javascript">
function check1(i,o)
{
document.form.text2.value=i;
document.form.word2.value=o;
}
</script>
<form name="form" method="post" action="sort_in.asp">
<br><b> 专题类别:</b>
<input type="hidden" name="options" value=''>
<select name="jtop" id="jtop" onchange="check1(document.form.jtop.options[document.form.jtop.selectedIndex].lable,document.form.jtop.options[document.form.jtop.selectedIndex].title)">
<% do while not rs.eof %>
<option value="<%=rs("j_id")%>" lable="<%=rs("j_name")%>" title="<% =rs("j_flag") %>"><%=rs("j_name")%></option>
<%
rs.movenext
loop
%></select>
<input type="submit" name="Submit" value="删 除" onclick="form.options.value='del'"><p>
<input type="text" name="word1" size=57 value="" maxlength="50" style="width: 369; height: 22">
<input name="tui1" type="radio" id="tui" value="0" checked>默认<font color=red><b>0</b></font>
<input name="tui1" type="radio" id="tui" value="1">推荐<font color=red><b>1</b></font>
<input type="submit" name="Submit1" value="添 加" onclick="form.options.value='new'"> </p><p>
- 上一篇:ASP错误代码说明
- 下一篇:ASP 编程中 20 个非常有用的例子――适合初学者
精彩图集