asp ÇóÖú£¡£¡£¡¼±¼±¼± - Web ¿ª·¢ / ASP
´íÎóÈçÏ£º
Microsoft OLE DB Provider for SQL Server ´íÎó '80040e14'
µÚ 1 ÐÐ: '=' ¸½½üÓÐÓï·¨´íÎó¡£
/detail.asp£¬ÐÐ 11
´úÂ룺
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!--#include file="Connections/con_bbs.asp" -->
<%
set Command1 = Server.CreateObject("ADODB.Command")
Command1.ActiveConnection = MM_con_bbs_STRING
Command1.CommandText = "UPDATE dbo.bbs_main SET hits =hits+1 where main_id ="&request("main_id")
Command1.CommandType = 1
Command1.CommandTimeout = 0
Command1.Prepared = true
Command1.Execute()
%>
ÕæÐÄÇó½Ì£¡£¡£¡Ð»Ð»£¡£¡£¡{{----
Ïà¹ØÎÊ´ð£º
ÎÒÓÐÁ½¸ödropdownlist¶¼°óºÃÁËÖµ£¬ÏëÑ¡ÖÐÒ»¸ödropdownlistÖеÄÖµ£¬È»ºóÔÚÁíÒ»¸ödropdownlistÖÐÑ¡ÖÐÏàÓ¦µÄÒ»Ïî¡£
²»ÊÇ´Óа󶨵ڶþ¸ödropdownlist£¬ÊÇÔÚÒѾ°óºÃµÄÖµµ±ÖÐÑ¡ÖÐÒ»¸ö¡£
ÎÒÏëÓÃjsд
ÇóÖú
Äã¿ÉÒÔ°Ñdrop ......
ÏÖÓÐÒ»¸ö±í¸ñ£¬ÓкܶàÐÐÊý×é¡£
ÏëÒªÒ»¸ö½Å±¾£¬¶ÁÈ¡ËùÓÐÐеÄÊý×éºóÊä³ö¡£
Êä³öÇ°²»ÏÔʾÕý³£Ë³ÐòµÄ±í¸ñÊý×飬¶øÖ±½ÓÏÔʾ³ö¶ÁÈ¡ºóµÄÊý×é¡£
Â¥Ö÷µÄ±í´ïʵÔÚ³ÉÎÊÌ⣡£¡
ÊDz»ÊÇÕâ¸öÒâ˼£¿
<%
Dim ArrDNA£¨10£¬10£ ......
O O O O O O
|.......| |........| |.......|
| | |
O O ......
ÔÚPHPÖÐÓÐûÓÐÏñASPÖеļǼ¼¯(ADODB.Recordset )ÕâÖÖÀàÐ͵ĶÔÏó?¿É²»¿ÉÒÔÏñÔÚASPÖÐÒ»Ñùͨ¹ý¼Ç¼¼¯À´¸üÐÂÊý¾Ý¿â.ÈçÏÂÃæÕâÑù.
VBScript code:
set rs=server.createobject("adodb.recordset")
......
SQL code:
rs.open "select * from guide where city_name='±±¾©' order by pai desc",conn,1,1
do while not rs.eof or rs.bof
¡£¡£
¡£¡£
¡£¡£
rs.movenext
loop
Õâ¸ösqlÓï¾äÔÚwapÕ¾Àï ±¾ÉíÓÐ ......