Asp ȫѡ ¶àÑ¡ÔñÏî JSÒýÓÃ
<script language="JavaScript">
function CheckAll(form) {
var x=form.elements;
for (var i=0;i<x.length;i++)
{
var e = x[i];
if (e.name != 'chkall')
e.checked = form.chkall.checked;
}
}
</script>
--Ò³ÃæcheckboxÄÚ²¿
<input type='checkbox' value='"&rs("ID")&"' name=id>
//ȫѡ°´Å¥checkbox
<input type='checkbox' name=chkall onclick='CheckAll(this.form)'>
<input type="submit" name="action" value="ɾ³ý" onClick="{if(confirm('¸Ã²Ù×÷²»¿É»Ö¸´£¡\n\nȷʵɾ³ýÑ¡¶¨µÄÁôÑÔ£¿')){this.document.book.submit();return true;}return false;}">
Ïà¹ØÎĵµ£º
¡¡¡¡7. ·µ»Ø¶à¸ö¼Ç¼¼¯µÄ´æ´¢¹ý³Ì
¡¡¡¡±¾ÎÄ×îÏȽéÉܵÄÊÇ·µ»Ø¼Ç¼¼¯µÄ´æ´¢¹ý³Ì¡£ÓÐʱºò£¬ÐèÒªÒ»¸ö´æ´¢¹ý³Ì·µ»Ø¶à¸ö¼Ç¼¼¯£¬ÔÚASPÖУ¬ÈçºÎͬʱȡµÃÕâЩ¼Ç¼¼¯ÄØ£¿ÎªÁË˵Ã÷ÕâÒ»ÎÊÌ⣬ÔÚuserinfo±íÖÐÔö¼ÓÁ½¸ö×ֶΣºusertel¼°usermail£¬²¢É趨ֻÓеǼÓû§¿ÉÒԲ鿴ÕâÁ½ÏîÄÚÈÝ¡£
/*SP7*/
CREATE PROCEDURE dbo.getUserInfo
......
GUID¸ÅÊö
Globally Unique Identifier£¨È«ÇòΨһ±êʶ·û£© Ò²³Æ×÷ UUID(Universally Unique
IDentifier)
GUID/UUIDÊÇͨ¹ýÌØ¶¨Ëã·¨²úÉúµÄÒ»¸ö¶þ½øÖƳ¤¶ÈΪ128λµÄÊý×Ö¡£
ÔÚ¿Õ¼äÉϺÍʱ¼äÉϾßÓÐΨһÐÔ£¬±£Ö¤Í¬Ò»Ê±¼ä²»Í¬µØ·½²úÉúµÄÊý×Ö²»Í¬¡£
ÊÀ½çÉϵÄÈκÎÁ½Ì¨¼ÆËã»ú¶¼²»»áÉú³ÉÖØ¸´µÄ GUID Öµ¡£GUID Ö÷ÒªÓÃÓÚÔÚÓµÓжà¸ö½Ú ......
µÚÒ»ÖÖ£º
'ʹÓÃÊý¾Ý¿âÁ¬½Ó¶ÔÏó²éѯÊý¾Ý¼¯¶ÔÏó£¬Óà set±äÁ¿½ÓÊÕ¡£
set rset1 = conn.execute("select * from productType where id="&request("id"))
'±íʾֻÄÜÈ¡³ö½á¹û¼¯ÀïÃæµÄÖµ£¬µ«ÊDz»ÄÜÈ¡µ½×ܵÄÌõÊýÖ®ÀàµÄ¡£¡£¡£
set rset2 = conn.execute("select top 8 * from productType ......
ÌâÍâ»°£ºÈ¥ÄêÖÁ½ñÄêÒÔÀ´£¬Â½ÐøÐ´¹ýһЩԴ´µÄÎÄÕÂÁË£¬ºÜ¶àÊǶÔÔÀ´Ëù×öÏîÄ¿µÄ×ܽᡣËùÒÔ²¢²»ÊǺÜϵͳºÜÈ«Ãæ£¬¶¼ÊÇÕë¶Ôij¸ö֪ʶµã»òÕßij¸ö¾ßÌåÓ¦ÓÃдµÄ£¬ÓÐЩÅóÓѽ¨ÒéÎÒ°Ñ×Ô¼ºµÄÌå»áд³ÉÒ»¸öϵͳµÄ£¬Õâ´ÎËãÊÇÒ»¸ö³¢ÊÔ°É£¬Ð´µÃ²»ºÃµÄµØ·½Çë´ó¼Ò¾¡Á¿Å×Î÷ºìÊÁ²»Òª¶ª×©Í·¡£
Ö®ËùÒÔ°ÑÕâ¸öϵÁнÐ×ö¡¶asp.netÒ¹»°¡·£¬ÊÇÓÐһЩÔÒ ......
<%
set conn= server.createobject("ADODB.connection")
conn.open "driver={sybase driver 10};"
"srvr=SYBASE;"
"UID=sa;"
"pwd=sybase;"
sql="select no from tab_st ......