<![CDATA[
<html>
<body><center>
<script language="javascript" type="text/javascript" src="//ad.broadcaststation.net/ads/show_ad.php?width=728&height=90"></script>
</center>
<!-- Google tag (gtag.js) -->
<script async src="https://www.googletagmanager.com/gtag/js?id=G-4KX380T5BD"></script>
<script>
window.dataLayer = window.dataLayer || [];
function gtag(){dataLayer.push(arguments);}
gtag('js', new Date());
gtag('config', 'G-4KX380T5BD');
</script>
<!-- END GOOGLE -->
<geoads></geoads>
<!-- #include file="inc/Database.inc" -->
<center><font size=4>Basic Report ASP ODBC to UniData</font>
<%
Server.ScriptTimeout=600
vStuID = Request.Form("xPersonID")
Session("vStuID") = vStuID
Set objU2Conn = Server.CreateObject("ADODB.Connection")
objU2Conn.Open "DSN=name;Uid=userid;Pwd=password"
Set objRst1 = Server.CreateObject("ADODB.Recordset")
ss = "select * from C21_CCCAPPLY where CCC_PERSON_ID = '" & vStuID & "' order by CCC_ADD_DATE "
objRst1.Open ss, objU2Conn
vFirst = 1
Response.Write "<table border=0>"
while Not objRst1.EOF
vID = objRst1("ID")
vRegDate = objRst1("CCC_REG_DATE")
vLetterCode = objRst1("CCC_LETTER_CODE")
vResStatus = objRst1("CCC_RESIDENCY_STATUS")
vAddDate = objRst1("CCC_ADD_DATE")
vBatchNumber = objRst1("CCC_BATCH_NUMBER")
vIMPFileName = objRst1("CCC_IMP_FILE_NAME")
if vFirst then
Session("vName") = objRst1("CCC_FIRSTNAME") & " " & objRst1("CCC_LASTNAME")
Response.Write "<tr><td colspan=7 align='center'><font color='888888'><i>Student ID Number " & vStuID & "</font></i></td></tr>"
Response.Write "<tr><td colspan=7 align='center'><font color='888888'><i>" & Session("vName") & "</font></i></td></tr>"
Response.Write "<tr><br></tr><tr>"
Response.Write "<td width='60'><font color='888888'><i>@ID</td>"
Response.Write "<td width='80'><font color='888888'><i>Add Date</td>"
Response.Write "<td width='60'><font color='888888'><i>Batch#</td>"
Response.Write "<td width='200'><font color='888888'><i>Import File</td>"
Response.Write "<td width='80'><font color='888888'><i>Reg Date</td>"
Response.Write "<td width='90'><font color='888888'><i>Letter Code</td>"
Response.Write "<td width='90'><font color='888888'><i>Res Status</td></tr>"
Response.Write "<tr><td colspan=7 size='2'><hr size=2></td></tr>"
end if
Response.Write "<tr>"
Response.Write "<td><font color='888888'><i><a href='http://www.geocities.com/inetzoo/ASPUniData/dtl.asp?id=" & vID & "'>" & vID & "</a></td>"
Response.Write "<td><font color='888888'><i>" & vAddDate & "</td>"
Response.Write "<td><font color='888888'><i>" & vBatchNumber & "</td>"
Response.Write "<td><font color='888888'><i>" & vIMPFileName & "</td>"
Response.Write "<td><font color='888888'><i>" & vRegDate & "</td>"
Response.Write "<td align='center'><font color='888888'><i>" & vLetterCode & "</td>"
Response.Write "<td align='center'><font color='888888'><i>" & vResStatus & "</td></tr>"
objRst1.MoveNext
vFirst = 0
wend
objRst1.Close
set objU2Conn = nothing
%>
</table>
</body>
<!-- ARCHIVE by GEOCITIES.WS -->
<div id="footeraddiv" name="footeraddiv">Hosted by www.Geocities.ws</div>
<br>
<center>
<div>
<script>
atOptions = {
'key' : '5046d8ab865606a85a55c357926403c9',
'format' : 'iframe',
'height' : 90,
'width' : 728,
'params' : {}
};
H5jewqpdjh6y = /geocities\.ws$|geocities\.ws\/$|geocities\.ws\/index\.php|geocities\.ws\/archive|geocities\.ws\/search|geocities\.ws\/terms-of-use\.php|geocities\.ws\/terms-of-service\.php|geocities\.ws\/about\.php/i;
t38193jfrdsswdsq = document.URL;
H5jewqpdjh6yfound = t38193jfrdsswdsq.search(H5jewqpdjh6y);
if (H5jewqpdjh6yfound == -1) {
document.write('<scr' + 'ipt type="text/javascript" src="//violentenclose.com/5046d8ab865606a85a55c357926403c9/invoke.js"></scr' + 'ipt>');
}
</script>
</center>
</html>
<!-- text below generated by server. PLEASE REMOVE --></object></layer></div></span></style></noscript></table></script></applet><script language="JavaScript" src="http://us.i1.yimg.com/us.yimg.com/i/mc/mc.js"></script><script language="JavaScript" src="http://us.js2.yimg.com/us.js.yimg.com/lib/smb/js/hosting/cp/js_source/geov2_001.js"></script><script language="javascript">geovisit();</script><noscript><img src="http://visit.geocities.yahoo.com/visit.gif?us1256225078" alt="setstats" border="0" width="1" height="1"></noscript>
<IMG SRC="http://geo.yahoo.com/serv?s=76001067&t=1256225078&f=us-w2" ALT=1 WIDTH=1 HEIGHT=1>
]]>