<% verify ID = fixsql(request.querystring("ID")) set objDB = OpenDatabase(true) SQL = "Select L.*, D.Company as Distributor from Leads L full outer join Distributors D on L.DistributorID = D.ID where L.ID = '" & ID & "'" set rsLead = CreateRecordset(objDB, SQL) section = "Leads" %>

:: <%=section%>

Lead Details

<% rsLead.close set rsLead = nothing objDB.close set objDB = nothing %>

Company:	">
Contact First Name:	">
Contact Last Name:	">
Title:	">
Email:	">
Address:	">
	">
City:	">
State:	">
Zip:	">
Business Phone:	">
Cell:	">
Fax:	">
Notes:	<%= rsLead("Notes") %>
Notes2:	<%= rsLead("Notes2") %>
RM Comments:	<%= rsLead("RMComments") %>
Distributor Comments:	<%= rsLead("DistributorNotes") %>
Primary Market:	">
Secondary Market:	">
Lead Source:	">
Assigned Distributor:	<%= rsLead("Distributor") %>