<% displayHeader() %> <% if request("addendum_id") <> "" then sqlString = "select contact_to_addendum.addendum_id, contact_to_addendum.contact_id, contact_to_addendum.download_date, job_addendums.job_id, job_addendums.description, job.job from contact_to_addendum, job_addendums, job where addendum_id = " & request("addendum_id") & " AND contact_to_addendum.addendum_id = job_addendums.id AND job.id = job_addendums.job_id" else sqlString = "select * from contact_to_addendum order by addendum_id, download_date" end if set objRS = objConn.Execute(sqlString) %> <% do while not objRS.EOF if objRS("contact_id") = 0 then local_name = "User Not Logged In" local_company = "" else contactString = "select name, company_id from contacts where id = " & objRS("contact_id") set contactRS = objConn.Execute(contactString) if not contactRS.EOF then local_name = contactRS("name") companyString = "select name from company where id = " & contactRS("company_id") set companyRS = objConn.Execute(companyString) if not companyRS.EOF then local_company = companyRS("name") else local_company = "" end if else local_name = "User no longer in Database" local_company = "" end if end if %> <% objRS.MoveNext loop %>

Download Report for:   <%=objRS("description")%> Job:   <%=objRS("job")%>
Company:	Contact:	Download Date:
<%=local_company%>	<%=local_name%>	<%=objRS("download_date")%>