asp·À¶ñÒâ×¢²á¼°¹àË®
֮ǰд¹ýÒ»¸ö²»ÓÃÑéÖ¤ÂëµÄ·À×¢²á»ú·½·¨£¬Ê¹ÓÃÁ˽«½ü2Äêºó£¬³¹µ×ʧЧ¡£
½ñÌìżȻײ¼ûÒ»¸ö·ÀÖ¹¶ñÒâ×¢²áµÄ·½·¨£¬ÕýÔÚ˼¿¼ing¡£ÏȰѷ½·¨ÁÐÏ£º
»ñÈ¡¿Í»§¶ËÌá½»µÄÐÅÏ¢£»
½«ÐÅÏ¢´æÈë Session£»
Éú³ÉÒ»¸öËæ»úÊý£¨³ÆÎª ticket£©£»
½«Ëæ»úÊýÒ²´æÈë Session£»
Óà JavaScript µÄÐÎʽ½«Ëæ»úÊýÒÔÁ´½ÓµÄÐÎʽÊä³ö£¬²¢Ìáʾ¿Í»§µã»÷ÉÏÒ»²½Éú³ÉµÄÁ´½Ó£»
document.write("<a
href="process.asp?ticket=<%=ticket%>">µã»÷È·ÈÏÌí¼Ó</a>");
¿Í»§µã»÷Á´½Ó£¬Ëæ»úÊýÓÖ±»·¢ËͻطþÎñÆ÷¶Ë£»
·þÎñÆ÷¶ËÑéÖ¤·¢ËÍ»ØÀ´µÄËæ»úÊýÓë Session ÖеÄËæ»úÊýÊÇ·ñÏàͬ£»
ÈôÏàͬ£¬½«ÐÅÏ¢´Ó Session ÖÐÈ¡³öÀ´´æÈëÊý¾Ý¿â£¬Íê³É¡£
ÕýÈçÄÇλleenÍøÓÑËù˵£¬ÕâÊÇÒ»¸ö³¤ÆÚ¶ø¼è¾ÞµÄÈÎÎñ¡£ËùνµÀ¸ßÒ»³ß£¬Ä§¸ßÒ»ÕÉ¡£¹àË®»ú£¬×¢²á»úÖ®ÀàµÄ¶«¶«Ò²ÔÚ²»Í£µÄÍêÉÆ¡£½ñÌìÄãʤ£¬Ã÷ÌìÎÒÓ®¡£·À·¶´ëʩҲÐèÒª²»Í£µÄ¸Ä½ø¡£ÏÈÈ¥Ñо¿Ò»ÏÂÔÀí¡£
Ïà¹ØÎĵµ£º
¡¡¡¡7. ·µ»Ø¶à¸ö¼Ç¼¼¯µÄ´æ´¢¹ý³Ì
¡¡¡¡±¾ÎÄ×îÏȽéÉܵÄÊÇ·µ»Ø¼Ç¼¼¯µÄ´æ´¢¹ý³Ì¡£ÓÐʱºò£¬ÐèÒªÒ»¸ö´æ´¢¹ý³Ì·µ»Ø¶à¸ö¼Ç¼¼¯£¬ÔÚASPÖУ¬ÈçºÎͬʱȡµÃÕâЩ¼Ç¼¼¯ÄØ£¿ÎªÁË˵Ã÷ÕâÒ»ÎÊÌ⣬ÔÚuserinfo±íÖÐÔö¼ÓÁ½¸ö×ֶΣºusertel¼°usermail£¬²¢É趨ֻÓеǼÓû§¿ÉÒԲ鿴ÕâÁ½ÏîÄÚÈÝ¡£
/*SP7*/
CREATE PROCEDURE dbo.getUserInfo
......
Ò»:
<FORM name=RedForm action=# >
<INPUT name=textfield2>
<INPUT type=image height=19 width=53 src="xxx.gif" align=absMiddle border=0 name=RedImg onclick="this.form.submit()">
<INPUT type=image height=19 width=53 src="xxx.gif" align=absMiddle border=0 name=RedImg3 onclick= ......
ÌâÍâ»°£ºÈ¥ÄêÖÁ½ñÄêÒÔÀ´£¬Â½ÐøÐ´¹ýһЩԴ´µÄÎÄÕÂÁË£¬ºÜ¶àÊǶÔÔÀ´Ëù×öÏîÄ¿µÄ×ܽᡣËùÒÔ²¢²»ÊǺÜϵͳºÜÈ«Ãæ£¬¶¼ÊÇÕë¶Ô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 ......
´Ó×Ö·û´®Öзµ»ØÖ¸¶¨ÊýÄ¿µÄ×Ö·û¡£
Mid(string, start, length)
²ÎÊý
string
×Ö·û´®±í´ïʽ£¬´ÓÖзµ»Ø×Ö·û¡£Èç¹û string °üº¬ Null£¬Ôò·µ»Ø Null¡£
Start
string Öб»ÌáÈ¡µÄ×Ö·û²¿·ÖµÄ¿ªÊ¼Î»Öá£Èç¹û start ³¬¹ýÁË string ÖÐ×Ö·ûµÄÊýÄ¿£¬Mid ½«·µ»ØÁ㳤¶È×Ö·û´® ("")¡£
Length
Òª·µ»ØµÄ×Ö·ûÊý¡£Èç¹ûÊ¡ ......