%@ Language=VBScript %> <% set cn = Server.CreateObject("ADODB.Connection") cn.ConnectionTimeout = 6000000 cn.CommandTimeout = 6000000 cn.Open "DSN=Kidsnet_Parent;uid=sa;PWD=sgmkj;APP=ASP Script;DATABASE=Kidsnet" Set rs = Server.CreateObject("ADODB.Recordset") sql = "SELECT Parent.ParentID AS ParentID, serialz.prefix AS PreFix, prefix.ResID AS ResID, reseller.Name AS Name, reseller.CSCont AS CSCont, reseller.CSEmail AS CSEmail, reseller.url AS URL FROM Parent INNER JOIN serialz ON Parent.ParentID = serialz.ParentID INNER JOIN prefix ON serialz.prefix = prefix.Prefix INNER JOIN reseller ON prefix.ResID = reseller.ResID where parent.ParentID like '" & Session("id") & "'" rs.Open sql,cn %>
<%if request("t") = "e" then %>