 |
<%
dim str_filename, ref_page
str_filename = Request.QueryString("shot")
ref_page = Request.ServerVariables("HTTP_REFERER")
set tigCON = Server.CreateObject("ADODB.Connection")
tigCON.Open(DSN)
' set up the query to list the news by date Desc
query = "SELECT beta_mappers.name AS a_name, " & _
"beta_mappers.email AS a_email, " & _
"beta_levels.title AS title " & _
"FROM beta_levels INNER JOIN " & _
"beta_mappers ON " & _
"beta_levels.author = beta_mappers.id " & _
"WHERE beta_levels.id = " & str_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")%>
"> " border="0" />
"><< back
<%
end if
tigRS.close
tigCON.close
%>
|