%
' Connect to database
If IsObject(Session("WalkSquawk_conn")) Then
Set conn = Session("WalkSquawk_conn")
Else
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "WalkSquawkDB","",""
Set Session("WalkSquawk_conn") = conn
End If
%>
<%
If Int(Request("time")) <> "" And Int(Request("time")) >= 6 Then
timeSet = Int(Request("time"))
Else
timeSet = 10
End If
checkedVal = ""
' See what Image we're at and prepare for next image
sql = "select * from qImagesAndCat where ImageID >= " & Request("img") & " order by ImageID"
Set sth = conn.Execute(sql)
If sth.EOF Then
' problem, handle it later
ErrStr = "No image exists with that ID"
End If
curImageID = sth("ImageID")
curImageSrc = sth("ImageSrc")
sth.MoveNext
If Request("auto") <> "" And Not sth.EOF Then
url = "slideshow.asp?img=" & sth("ImageID") & "&auto=on&time=" & timeSet
checkedVal = "checked"
%>
<% End If%>
Walk & Squawk