ÔÚaspÖÐɾ³ýtableÖеÄÊý¾Ý
ÔÚtableÖÐÏÔʾÊý¾Ý£º±àºÅ(id)£¬Ñ§ºÅ...£¬ÈçºÎµÃµ½Ò»ÐÐÊý¾ÝµÄidÖµ£¬È»ºó°ÑÕâÒ»ÐÐɾ³ýÁË£¿
ͬʱҲÓÐÈëѧÈÕÆÚ£¬ÈçºÎµÃµ½ÈÕÆÚ£¬°ÑÊý¾Ý½øÐÐÅúÁ¿É¾³ý£¿
nan
²»ÊÇÌ«Ã÷°×ÎÊÌâ¡£
SQL code:
delete from table1 where id=1
delete from table1 where date = '2009-01-01'
HTML code:
<table>
<tr>
<td>ID</td>
<td>ѧԱÐÕÃû</td>
<td>ÈëѧÈÕÆÚ</td>
<td>²Ù×÷</td>
</tr>
<%
set rs=********
rs.open "select * from ±í",conn,1,1
Ñ»·
%>
<td><%=Rs("id")&></td>
<td><%=Rs("name")&></td>
<td><%=Rs("time")&></td>
<td><a href="del.asp?id=<%=Rs("id")%>">ɾ³ý</a></td>
</table>
<%
sql = "SELECT * from [table_name]"
rs.open sql, conn, 1, 1
sql = "DELETE from [table_name] where id=" & rs("id")
conn.execute("sql")
%>
VBScript code:
rs.open "select * from table",conn,1,3
whil
Ïà¹ØÎÊ´ð£º
<%@language="vbscript"%>
<%option explicit%>
<html>
<head> <title>xxx </title> </head>
<script language=vbs>
'×¢Òâ±äÁ¿ ......
ÎÒÃÇÓÐÒ»¸öÍøÕ¾Ä£°å£¬www.c111.com.cn,Ï£ÍûÐÞ¸ÄһЩµØ·½£º
1£©µã»÷×ó²à¡°·þÎñÆ·ÅÆ¡±µÄÆäÖÐÒ»¸öС·ÖÀ࣬Èç¡°×ãÇò¡±£¬½çÃæµÄÓÒ²à¾Í³öÏÖÈçwww.c111.com.cn/1.jpg£¬µã»÷1.jpgÉÏ·½µÄÆäÖÐÒ»¸öÆ·ÅÆlogo£¬ÏÂÃæ¾Í³öÏÖÏà¹ØµÄÍ ......
<%if request.QueryString("start") <>"" then%>
<%if cint(start)>0 then%>
<a href="search.asp?q= <%=q%>&start= <%if request.Query ......
ÎÒÔ±¾ÊÇѧjspµÄ¿ÉÕÒÁËÒ»¸öASPµÄ¹«Ë¾£¡ÎÒÒªÖØÐÂѧϰ£¡ ѧϰASP£¡ Ï£Íû´ó¼ÒÍÆ¼öÒ»±¾ºÃÊ鏸ÎÒлл
<ASP3.0¸ß¼¶±à³Ì> ÍøÉÏÓеç×Ó°æµÄ
·¢ÏÖÍøÉÏaspÐÅϢʱ×î¶àµÄ ±ÈÆäËûµÄ¶¼¶àºÃ¶à
yun
ÕÒ±¾ÓÐÓ¦ÓÃÊÂÀýµÄA ......
ÎÒÕÒÁËÒ»¸öα¾²Ì¬´úÂ룬ÈçÏ£º
index.asp
<!--#include file="config.asp"-->
<ol>
<%
Set rs=server.CreateObject("adodb.recordset") & ......