%@language=vbscript%> <% option explicit %> <% dim strSql, DBConn, RSconn, today, findImg today = date() Set DBConn=Server.CreateObject("ADODB.Connection") DBConn.Open "DRIVER={Microsoft Access Driver (*.mdb)};DBQ="&server.MapPath("/mdb-database/melzoscuole.mdb") 'DBConn.Open "DBMelzoScuole" set RSconn = Server.CreateObject("ADODB.Recordset") RSconn.ActiveConnection = DBConn strSql = "SELECT * FROM Images" RSconn.Open strSql %>
CIRCOLO DIDATTICOVia Bologna 14 - tel. 0295737310 - e-mail miee130006@istruzione.it; miee130006@pec.istruzione.it
L'artista del giorno
|
<%
response.write " |
|
<%
response.write RsConn("Description")&" "&RsConn("Author") %> |
|
<%
if ((application("LastGoodImage") = "") or (Application("LastGoodDescription")="") or (Application("LastGoodAuthor")="")) then
RsConn.movefirst
application("LastGoodImage") = RsConn("image")
application("LastGoodDescription") = RsConn("description")
application("LastGoodAuthor") = RsConn("Author")
end if
response.write " |
|
<%
response.write Application("LastGoodDescription")&" "&Application("LastGoodAuthor") %> |