%@ language="vbscript"%>
<%'option explicit
%>
<%
Dim rs
Dim rs1
Dim strsql
Dim strsql1
Set rs=server.CreateObject("adodb.recordset")
strsql="select catalogueshowname, products, markets from catalogueshows_master where catalogueshowcode = " & Request.QueryString("cscode") & " "
set rs1=server.CreateObject("adodb.recordset")
strsql1="select convert(char(10),catalogueshowdate,103) catalogueshowdate from catalogueshows_schedule where catalogueshowscode = " & Request.QueryString("cscode") & " "
on error resume next
rs.Open strsql,objconn
if err.number <> 0 then
Response.Redirect "/inc/commoninc/error.asp?errorno=err.number"
Response.End
end if
on error goto 0
on error resume next
rs1.Open strsql1,objconn
if err.number <> 0 then
Response.Redirect "/inc/commoninc/error.asp?errorno=err.number"
Response.End
end if
on error goto 0
%>