% Dim sPath, sScriptDir, sDSN Const adOpenKeyset = 1 Const adLockPessimistic = 2 sScriptDir = Request.ServerVariables("SCRIPT_NAME") sScriptDir = StrReverse(sScriptDir) sScriptDir = Mid(sScriptDir, InStr(1, sScriptDir, "/")) sScriptDir = StrReverse(sScriptDir) sPath = Server.MapPath(sScriptDir) & "\" sDSN="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/dados/mcruz3z.mdb") sSQLCat = "SELECT * FROM antes ORDER BY texto1" set RsCat=Server.CreateObject("ADODB.Recordset") RsCat.Open sSQLCat, sDSN, adOpenKeySet, adLockPessimistic sSQLRot = "SELECT * FROM antes2 ORDER BY numero" set Rr=Server.CreateObject("ADODB.Recordset") Rr.Open sSQLRot, sDSN, adOpenKeySet, adLockPessimistic sSQLCatx = "SELECT * FROM home ORDER BY ordem" set RsCatx=Server.CreateObject("ADODB.Recordset") RsCatx.Open sSQLCatx, sDSN, adOpenKeySet, adLockPessimistic If Not RsCatx.Bof then RsCatx.Movefirst End if %>
<%
Do until Rr.Eof
%>
" rel="lightbox[roadtrip]">
|
<%= RsCat("texto1") %> |
|
<% if RsCatx("imagem1")<>"" then %> " target="blank"> |