Log Search System by IZ8AZZ Carmine All rights reserved, © Mediterraneo
Dx Club <% dim fso
set fso = server.createobject("scripting.filesystemobject")
set dir = fso.getfolder(server.mappath("log"))
%>
<% if not (isempty(request.form("scelta"))) then
s=ucase(request.form("scelta"))
n=ucase(request.form("nominativo"))
sn=server.mappath("log\" & s &".MDB")
q="select * from log where nominativo like'" & n &"'"
SET CONN=SERVER.CREATEOBJECT("ADODB.CONNECTION")
SET RS=SERVER.CREATEOBJECT("ADODB.RECORDSET")
conn.open "DRIVER={Microsoft Access Driver (*.MDB)};" & _
"DBQ=" & sn
set rs=conn.execute (q) %>
<% if rs.eof then%>
| <%= "non a log / not in log "%>
|
<% else %>
Date |
Call |
Band |
Mode |
<% do until rs.eof %>
| <%= rs("DATA") %>
|
<%= rs("NOMINATIVO") %>
|
<%= rs("BANDA") %>
|
<%= rs("MODO") %>
|
<% rs.movenext
loop
end if %>
<%
set file = fso.getfile(sn)
response.write "Log aggiornato il / Log last updated" & _
"
" & file.datelastmodified
%>
<%
rs.close
conn.close
set rs= nothing
set conn= nothing
set dir = nothing
set file= nothing
set fso = nothing
else
response.write "
scegli un Log ed inserisci un Call
"
end if
%>