ASP³£ÓÃÄÚÖú¯Êý
¡¡ÔÚASPÖУ¬°Ñ´øÓзµ»ØÖµµÄÕâÑùµÄÒ»¶Î´úÂë½Ð×öº¯Êý¡£ÀýÈçͨ¹ý±àдһ¶Î´úÂë¼ÆËã³öÒ»¸ö×ÔÈ»ÊýÊÇ·ñÊÇÖÊÊý£¬·µ»Ø¸øµ÷ÓóÌÐò£¬ÓÉÓÚµ÷ÓóÌÐòÐèÒªÖªµÀÄǸö×ÔÈ»ÊýÊÇ·ñÊÇÖÊÊý£¬ËùÒÔ±ØÐëÒª·µ»ØÒ»¸öÖµ¡£
¡¡¡¡1£¬ÈÕÆÚ/ʱ¼äº¯Êý
¡¡¡¡ÕâЩº¯Êý°üÀ¨¶Ô“Äꔡ¢“Ô”¡¢“ÈÕ”¡¢“ʱ”¡¢“·Ö”¡¢“Ã딡¢“ÐÇÆÚ”µÈµÄÏÔʾ¡£
¡¡¡¡£¨1£©Nowº¯Êý£º¸ù¾Ý¼ÆËã»úϵͳÉ趨µÄÈÕÆÚºÍʱ¼ä£¬·µ»Øµ±Ç°µÄÈÕÆÚºÍʱ¼äÖµ¡£Ê¹Ó÷½·¨now()£»
¡¡¡¡£¨2£©Dateº¯Êý£ºÖ»·µ»Øµ±Ç°¼ÆËã»úϵͳÉ趨µÄÈÕÆÚÖµ¡£Ê¹Ó÷½·¨£ºdate()£»
¡¡¡¡£¨3£©Timeº¯Êý£ºÖ»·µ»Øµ±Ç°¼ÆËã»úϵͳÉ趨µÄʱ¼äÖµ¡£Ê¹Ó÷½·¨£ºtime()£»
¡¡¡¡£¨4£©Yearº¯Êý£º·µ»ØÒ»¸ö´ú±íijÄêµÄÕûÊý¡£Ê¹Ó÷½·¨£ºyear(date)£¬ÆäÖÐdate²ÎÊýÊÇÈÎÒâµÄ¿ÉÒÔ´ú±íÈÕÆÚµÄ²ÎÊý£¬±ÈÈç“year(date())”¾Í±íʾÊÇ´Ó“date()”µÃ³öµÄÈÕÆÚÖÐÌáÈ¡ÆäÖГÄꔵÄÕûÊý¡£
¡¡¡¡ÁíÍ⣬»¹¿ÉÒÔÕâÑùÓ¦Ó㺓year(#5 20,2006#)”±íʾÌáÈ¡“2006Äê5ÔÂ20ÈÕ”ÖГÄꔵÄÕûÊýÖµ¡£¹ØÓÚ“5 20,2006”£¬Ò²¿ÉʹÓÓ5-20-2006”¡¢“5/20/2006”µÈÐÎʽ±íÏÖ£¬¼´“ijÔÂijÈÕ”ºÍ“ijÄꔵÄ×éºÏ¡£Í¬Ê±×¢ÒâʹÓÓ#”½øÐаüÀ¨ÒÔ±íʾÈÕÆÚÖµ¡£
¡¡¡¡£¨5£©Monthº¯Êý£º·µ»Ø1µ½12Ö®¼äµÄÕûÊýÖµ£¬±íʾһÄêÖÐijÔ¡£Ê¹Ó÷½·¨£ºmonth(date)¡£¹ØÓÚ²ÎÊýdateµÄ˵Ã÷ºÍyearº¯ÊýÏàͬ¡£µ«Òª×¢ÒâÈÕÆÚµÄÕýÈ·ÐÔ£¬±ÈÈç“#13-31-2006#”£¬¸ù±¾¾ÍûÓГ13”Ô£¬¿Ï¶¨ÊÇ´íÎóµÄÁË¡£
¡¡¡¡£¨6£©Dayº¯Êý£º·µ»Ø1µ½31Ö®¼äµÄÕûÊýÖµ£¬±íʾһ¸öÔÂÖеÄijÌ졣ʹÓ÷½·¨£ºday(date)¡£¹ØÓÚ²ÎÊýdateµÄ˵Ã÷ºÍyearº¯ÊýÏàͬ¡£Í¬ÑùҪעÒâÈÕÆÚµÄÕýÈ·ÐÔ£¬±ÈÈç“#2-30-2006#”ÆäÖжԓ2”Ô¶¨ÒåµÄ“30”ÈÕÕâÌì¾ÍÊÇ´íÎóµÄ¡£
¡¡¡¡£¨7£©Hourº¯Êý£º·µ»Ø0µ½23Ö®¼äµÄÕûÊýÖµ£¬±íʾһÌìÖеÄij¸öСʱ¡£Ê¹Ó÷½·¨£ºhour(time)¡£ÆäÖвÎÊýtimeÊÇÈÎÒâµÄ¿É´ú±íʱ¼äµÄ±í´ïʽ¡£±ÈÈç“hour(time())”¾Í±íʾÊÇ´Ó“time()”µÃ³öµÄʱ¼äÖÐÌáÈ¡ÆäÖГСʱ”µÄÕûÊý¡£Í¬Ñù£¬²ÎÊýtime»¹¿ÉÒÔÕâÑùÓ¦ÓÓhour(#11:45:50#)”±íʾ´Ó“11”ʱ“45”·Ö“50”ÃëÖÐÌáÈ¡µ±Ç°Ð¡Ê±Êý¡£µ±È»£¬¶¨ÒåµÄʱ¼äÒª·ûºÏʱ¼äµÄ¹æ·¶¡£
¡¡¡¡£¨8£©Minuteº¯Êý
Ïà¹ØÎĵµ£º
Õ⼸ÌìºÃ¶àÈËÎÊÎÒÈçºÎÔÚasp³ÌÐòÖпØÖÆÉãÏñÍ·È¥×¥ÅÄÕÕÆ¬£¬asp¼¼Êõ»¹ÊÇ99ÄêµÄʱºò¿´¹ýÒ»µãµã£¬Ôç¾Í×ÅÃ×·¹³ÔÁË£¬²»¹ý¼ÈÈ»ÓÐÈËÎÊ£¬ÄǾÍÊÇ¿´µÃÆðÔÛ£¬»¨ÁËÒ»¸öÍíÉϵÄʱ¼ä°Ñasp³ÌÐòµ÷ÓÃÉãÏñÍ·ÅÄÕÕµÄÎÊÌâ¸ã¶¨ÁË£¬ÏּǼÈçÏ£¬ÈÃÓÐÀàËÆÐèÇóµÄͬѧ¿ÉÒÔÉÙ×ßЩÍä·¡£
Óõ½µÄ¼¼Êõ£º
1.asp³ÌÐòÖÐ×÷base64±àÂëºÍ½âÂ룬ʹÓõÄÊÇmsxml×é¼þ£ ......
ÔÎÄÁ´½Ó:http://www.iwapr.cn/article/daima/30.html
ASP/Visual Basic´úÂë
<%
dim picurl,all_picurl
'½ÔÊÇÈ«¾Ö±äÁ¿:·Ö±ð¶¨ÒåͼƬµÄÁ´½ÓµØÖ·;ËùÓÐÖ¸¶¨Îļþ¼Ð(°üÀ¨Ö¸¶¨Îļþ¼ÐµÄ×ÓÎļþ¼ÐÏÂͼƬurlµØÖ·)
picurl="" &n ......
<!--#include file="conn.asp"-->
<%
if request.Form("username")="" or request.form("password")="" then
response.Write("<script>alert('ÄúºÃ£¬²»ÄÜΪ¿Õ
');location.href='index.html';</script>")
end if
%>
<%
di ......
ʹÓÃDreamweaver²âÊÔÁ¬½Ó³É¹¦£¬µ«ÊÇIISÀïÃæÔËÐÐÈ´×ÜÊÇ´íÎó°Ù³ö£¬¿´ÁËÏÂÃæÕâÆª²©ÎÄÎÊÌâ²ÅµÃÒÔ½â¾ö¡¢¡¢¡¢
Ò»°ãÇé¿öÏÂasp¿ÉÒÔÕý³£ÔËÐÐ,µ«Ö»ÒªÁ¬½ÓÊý¾Ý¿â¾ÍÌáʾ,Microsoft JET Database Engine ´íÎó
'80004005',ÎҵĵçÄÔÒòΪÓÃÅú´¦ÀíÇåÀíÎļþ,ËùÒÔ²»ÄÜÔËÐÐÁË£¬ Ö»
1.²é¿´Êý¾Ý¿âÁ¬½ÓÓï¾äûÓз¢ÏÖ´íÎó£»
2.²é¿´Îļþ¼ÐµÄȨÏÞÒÑ ......
asp ÖÐÎÄÂÒÂë,asp access ÂÒÂë,asp ˢкóÂÒÂë,asp utf 8ÂÒÂë,ajax ÂÒÂë asp,asp ºº×ÖÂÒÂë,aspÂÒÂëÔõô°ì
ÓÃutf-8±àÂëÓÃÔÚеÄÍøÕ¾ÉÏ£¬²»ÏëÎÊÌâ»¹Õæ¶à£¬ËùÒÔÕÒÁËЩÎÄÕ£¬Ìû×Ó£¬¿´ÁË¿´£¬µÈÏÂÓÐÓõľÍÌùÏÂÃæÁË¡£
½ñÌ죬ÎÒ¿ªÊ¼°Ñ CODEPAGE="936" ¸Ä³É CODEPAGE="65001"
°Ñcharset=gb2312¸Ä³É charset=utf-8
¿ÉÊÇ»¹ÊÇÂÒÂë ......