Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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´ÓÊý¾Ý¿âÖÐÊä³öµÄ¶«Î÷»»ÐÐ

 <%  
Set rs=Server.CreateObject("ADODB.RecordSet")
sql="select * from 0791idc_News where BigClassName='¼Ò×°¿ÎÌÃ' order by ID desc"
rs.Open sql,Conn,1,1
if rs.eof and rs.bof then
  response.Write("ÔÝʱûÓмǼ")
else
%>
         ......

ASPÖÐÈçºÎ±íµ¥ÔªËصĴ«µÝ

¡¡¡¡Ñ§Ï°Ä¿µÄ£ºÑ§»áÓÃ±íµ¥ÔªËØÏò·þÎñÆ÷´«ËͱäÁ¿£¬È»ºóÏÔʾ±äÁ¿ÔÚ¿Í»§¶ËµÄä¯ÀÀÆ÷¡£
¡¡¡¡Ê×ÏÈ£¬ÈÃÎÒÃÇÀ´¿´Ò»ÏÂDREAMWEAVERµÄ±íµ¥ÔªËØÃ«Ë¢¡£
¡¡¡¡ÏÂÃæÎÒÃÇÀ´Ò»¸öÒ»¸ö¿´±íµ¥ÔªËØ¡£1¡¢Îı¾Óò£¬Õâ¸öÊÇ×î»ù±¾µÄ£¬´«Ë͵ÄÊÇÎı¾ÐÅÏ¢£¬Ò»°ãÓû§Ãû£¬ÃÜÂë¶¼ÒªÓÃÕâ¸ö´«ËÍ£¬²»¹ýÒªÊÇÃÜÂëµÄ»°ÒªÔÚÀàÐÍÀïÃæÑ¡ÔñÃÜÂ룬ÕâÑù¾Í»áÒÔ*´úÌæÏÔʾ³ ......

asp»ñȡһ¸öÎļþ¼Ð¼°Æä×ÓÎļþ¼ÐϵÄËùÓÐͼƬµØÖ·

Ô­ÎÄÁ´½Ó:http://www.iwapr.cn/article/daima/30.html
ASP/Visual Basic´úÂë
<%   
dim picurl,all_picurl   
 
'½ÔÊÇÈ«¾Ö±äÁ¿:·Ö±ð¶¨ÒåͼƬµÄÁ´½ÓµØÖ·;ËùÓÐÖ¸¶¨Îļþ¼Ð(°üÀ¨Ö¸¶¨Îļþ¼ÐµÄ×ÓÎļþ¼ÐÏÂͼƬurlµØÖ·)   
 
picurl=""   &n ......

asp¶ÁÈ¡word ÎĵµÄÚÈÝת»»Îª¶þ½øÖÆÊý¾ÝÁ÷

Dim FilePath,FileName
Set ObjFileStream = Server.CreateObject("ADODB.Stream")
ObjFileStream.Type = 1
ObjFileStream.Mode = 3
ObjFileStream.open
ObjFileStream.LoadfromFile FilePath&"\"&FileName&".doc"
ObjFileStream.Position = 0
response.binarywrite  ......

aspÍøÕ¾´ÓACCESSתSQLSERVER


ǰ¼¸ÌìÎªÖÆ×÷Ò»¸öÍøÕ¾£¬ÐèÒª´ÓACCESSתÖÁSQLSERVER£¬´ÓÍøÕ¾Éϲ鿴Á˺ܶàµÄ×ÊÁÏ£¬µ«¾õµÃûÓÐÒ»¸öÄܹ»È«Ã渲¸ÇÒªµãµÄ£¬ËùÒÔÎÒ×ܽáһϣ¬Ë³±ã
¸ø³öһЩ¾­Ñé¡£
   
Ê×ÏÈÈç¹ûÒ»¿ªÊ¼¾ÍÐèÒªÖÆ×÷SQLSERVERµÄÍøÕ¾£¬ÄÇô×îºÃ½«ÄãµÄ°®»ú×°ÉÏWINDOWS2000»òÕß2003ÕâÑùµÄSERVER°æ£¬ÕâÑùµÄ°æ±¾ÊÇÖ§³Ö
SQLSERVERÕýʽ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ