asp ÅúÁ¿update ÎÊÌ⣡
----´íÎóÌáʾ--------------
Microsoft OLE DB Provider for ODBC Drivers ´íÎó '80004005'
»ùÓÚ²éѯµÄ¸üÐÂʧ°Ü£¬ÒòΪû·¢ÏÖÒª¸üеÄÐС£
/admin/inboundSQL.asp£¬ÐÐ 406
-----´úÂë------------------------
If Not PLFHRS.EOF Then
While Not PLFHRS.EOF
PLFHRS("FHSL") = Trim(PLFHRS("SL"))&"="&Trim(PLFHRS("YSCMFB"))
PLFHRS("FHSJ") = Now()
PLFHRS("FHR") = request.Cookies("loginname")
PLFHRS.update
PLFHRS.movenext
Wend
End If
while 4 ´Îºó¾Í»á³ö´í£¡
ÄÄλÄܰï°ï棬¸Ðл
ûÈËÄܻشð´ËÎÊÌ⣿
ÉÏÏÂÎÄÌùһϿ´¿´£¬ÕâЩ´úÂëËÆºõû´í
Set PLFHRS = server.CreateObject("ADODB.recordset")
PLFHRS.open "select FHSL,FHR,FHSJ,SL,YSCMFB from BM_ProcurementSystem where (FHSL='' or FHSL is null) and (FHSJ='' or FHSJ is null) and (YSCMFB <>'' or YSCMFB is not null) and FLAG <>1 and (RQ between '"&starttime&"' and '"&endtime&"')",conn,1,3
If Not PLFHRS.EOF Then
While Not PLFHRS.EOF
PLFHRS("FHSL")
Ïà¹ØÎÊ´ð£º
HTML code:
dim jf
set conn=server.createobject("adodb.connection")
connstr="Driver={Sql Server};Server="&Sqlip&";Database="&Sqldb&";Uid="& ......
ÎÒÃÇÓÐÒ»¸öÍøÕ¾Ä£°å£¬www.c111.com.cn,Ï£ÍûÐÞ¸ÄһЩµØ·½£º
1£©µã»÷×ó²à¡°·þÎñÆ·ÅÆ¡±µÄÆäÖÐÒ»¸öС·ÖÀ࣬Èç¡°×ãÇò¡±£¬½çÃæµÄÓÒ²à¾Í³öÏÖÈçwww.c111.com.cn/1.jpg£¬µã»÷1.jpgÉÏ·½µÄÆäÖÐÒ»¸öÆ·ÅÆlogo£¬ÏÂÃæ¾Í³öÏÖÏà¹ØµÄÍ ......
<%On Error Resume Next
Set conn=Server.CreateObject("ADODB.Connection")
conn.begintrans
conn.Open ("Driver={SQL Server};server=(local);uid=sa;database=student;pwd=")
......
½øÀ´Î¬»¤ÁËÓÃÀà±àдµÄASPÍøÕ¾£¬¿ªÊ¼Á˽âÁË Ò»µãÀàµÄ²Ù×÷¡£
ÒÔǰ×öÍøÕ¾¶¼ÊÇÔÚ¡¶% %¡·Ð´´úÂëµÄ£¿
¿´¿´ CMSºÃÏñ¶¼ÊÇÓÃÀàдµÄ£¬×Ô¼ºÒ²¿´ÁË´úÂë ºÃÏñ±È½ÏÄÑ£¬ ¿´µÃ¶®¶¼²»ÖªµÀÒªµ½Ê²Ã´Ê±ºò²ÅÃ÷°×¡£
Í·Ôΰ¡£¡ ......