% dim Conn1, rs1 , rs2 Set Conn1 = Server.CreateObject("ADODB.Connection") Set rs1 = server.CreateObject("ADODB.Recordset") Conn1.open "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=C:\Inetpub\siteeafs\faleconosco.mdb" 'dim var_nome_maquina, var_ip_maquina , var_data_acesso ' OK var_nome_maquina = request.servervariables("GATEWAY_INTERFACE") ' VAZIO var_nome_maquina = request.servervariables("LAST_MODIFIED") ' VAZIO var_nome_maquina = request.servervariables("DOCUMENT") ' OK var_nome_maquina = request.servervariables("HTTP_USER_AGENT") ' OK var_nome_maquina = request.servervariables("SERVER_PORT") 'var_nome_maquina = request.servervariables("REMOTE_ADDR") 'var_ip_maquina = request.servervariables("REMOTE_ADDR") 'var_data_acesso = now() '>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> dim string_consulta string_consulta = "select * from t_exaluno where mo = '1' order by momento desc" rs1.open string_consulta , Conn1, 3,3 %>
|
<% if rs1.eof = false then rs1.movefirst else response.redirect("tabela vazia") end if while rs1.eof = false %> Em <%=rs1("momento") %> <% if rs1.eof = false then rs1.movenext end if %> <% wend %>
|