%@LANGUAGE="VBSCRIPT"%> <% Dim Recordset1__MMColParam Recordset1__MMColParam = "0" If (Request.QueryString("ID") <> "") and check_input0(Request.QueryString("ID"),1,4)=0 Then Recordset1__MMColParam = Request.QueryString("ID") else Response.Redirect "index.htm" End If %> <% Dim Recordset1 Dim Recordset1_numRows sql="SELECT * FROM 影片库 where id="& Recordset1__MMColParam '检测是否有该影片 rs.open sql,conn,1,1 if rs.recordcount =0 then response.write "抱歉,系统中没有该影片的相关纪录!" response.end rs.close end if Set Recordset1 = Server.CreateObject("ADODB.Recordset") Recordset1.ActiveConnection = MM_ys_STRING Recordset1.Source = "SELECT * FROM 影片库 WHERE ID = " + Replace(Recordset1__MMColParam, "'", "''") + "" Recordset1.CursorType = 0 Recordset1.CursorLocation = 2 Recordset1.LockType = 1 'response.write Recordset1.Source 'response.end Recordset1.Open() If (Request.QueryString("ID") <> "") Then Recordset1__MMColParam = Request.QueryString("ID") sql="update 影片库 set 点播次数=点播次数+1 where ID=" & Recordset1__MMColParam MM_ys_STRING.execute(sql) 'server.execute "" End If Recordset1_numRows = 0 %> <% Dim Recordset2__MMColParam Recordset2__MMColParam = Recordset1.Fields.Item("ID").Value %> <% Dim Recordset2 Dim Recordset2_numRows Set Recordset2 = Server.CreateObject("ADODB.Recordset") Recordset2.ActiveConnection = MM_ys_STRING Recordset2.Source = "SELECT ID, 说明,服务器编号 FROM 影片地址库 WHERE 影片ID = " + Recordset1__MMColParam + " ORDER BY ID ASC" 'response.write Recordset2.Source Recordset2.CursorType = 0 Recordset2.CursorLocation = 2 Recordset2.LockType = 1 Recordset2.Open() Recordset2_numRows = 0 %>
|
|||||||||||||||||||||||||||||||||||