<% lvl=validate(0) requestid=request("requestid") if requestid="" or not(isnumeric(requestid)) then response.redirect "logout.asp" set conn=server.createobject("ADODB.Connection") conn.open connection '/// retrieve Request Information psql="SELECT *,xlaALSRequests.customerid as customerid FROM xlaALSCustomers INNER JOIN xlaALSRequests ON xlaALSCustomers.customerid = xlaALSRequests.customerid where requestid="&requestid set rs=conn.execute(psql) name=rs("name") email=rs("email") website=rs("website") customerid=rs("customerid") transcript=rs("transcript") rating=rs("rating") dateregistered=rs("dateregistered")&"" lastrequestdate=rs("lastrequestdate") requestdate=rs("requestdate") deptid=rs("deptid") userid=rs("userid") topic=rs("topic") if topic="" then topic="Undefined" totalrequests=rs("totalrequests") ref=rs("ref") rs.close set rs=nothing '/// Get representative name psql="select name,usr from xlaALSUsers where userid="&userid set rs=conn.execute(psql) repname=" - Not Found -" if not(rs.eof) then repname=""&rs("name")&" ("&rs("usr")&")" rs.close set rs=nothing '/// Get Department name deptname="None (Proactive Chat)" if deptid>0 then psql="select deptname from xlaALSDepts where deptid="&deptid set rs=conn.execute(psql) if not(rs.eof) then deptname=rs("deptname") rs.close set rs=nothing end if conn.close set conn=nothing if rating>0 then for x=1 to rating stars=stars & "" next rating=stars & " : "&rating else rating=" - Not Rated - " end if if transcript="" then transcript=" - No Transcript Available -" %> <%=title%>
Customer Information
Customer ID # <%=customerid%>
Name :
<%=name%>
E-Mail :
<%=email%>
Web Site :
<%=website%>
Date registered :
<%=dateregistered%>
Last request :
<%=lastrequestdate%>
Total Requests :
<%=totalrequests%>
Request Information
Topic : <%=topic%>
Request ID # <%=requestid%>
Request Date : <%=requestdate%>
Department : <%=deptname%>
Representative : <%=repname%>
Rating : <%=rating%>

Session Transcript
<%=transcript%>