 |
<%
dim filename
filename = Request.QueryString("shot")
set tigCON = Server.CreateObject("ADODB.Connection")
tigCON.Open(DSN)
' set up the query to list the news by date Desc
query = "SELECT mods_login.name AS a_name, " & _
"mods_login.email AS a_email, " & _
"mods_list.name AS title " & _
"FROM mods_list INNER JOIN " & _
"mods_login ON " & _
"mods_login.id = mods_list.id_login " & _
"WHERE mods_list.id = " & filename
'Response.Write("Query = [" & query & "]
")
set tigRS = tigCON.Execute(query)
' make sure we have see if there is no records
if (tigRS.EOF) Then
%>
There is no screen shot for that level request, sorry
<%
else
%>
<%=tigRS("title")%> by "><%=tigRS("a_name")%>
 ">
<< back
<%
end if
tigRS.close
tigCON.close
%>
|