%@ language="vbscript"%>
<%'option explicit
%>
<%
Dim rs
Dim rs1
Dim strsql
Dim strsql1
Set rs=server.CreateObject("adodb.recordset")
set rs1=server.CreateObject("adodb.recordset")
strsql="select pppname, products, markets from ppp_master where pppcode = " & Request.QueryString("pppcode") & ""
strsql1="select convert(char(10),pppdate,103) pppdate from ppp_schedule where pppcode = " & Request.QueryString("pppcode") & ""
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
%>