<% strId = request("Id") ' Create a recordset object to store specific table information Set objRS = Server.CreateObject("ADODB.Recordset") 'Establish what records you want selected for the SQL query string SQL = "Select * From TblLogin where LoginId =" & strId 'Set the recordset object equal to the SQL query string objRS.Open SQL, objADO, 1, 3 %>

DEALER DETAIL

<% if objRS("CellPhone")<> "" then %> <% end if %> <% if objRS("FaxNumber")<> "" then %> <% end if %> <% if objRs("Website") <> "" then %> <% end if %>

<% if objRS("AgentPicture")<> "" then %> " height="150" width="150"> <% else %> <% end if %>

Phone: <%= formatphonenumber(objRS("PhoneNumber"))%>
Cell: <%= formatphonenumber(objRS("CellPhone"))%>
Fax: <%= formatphonenumber(objRS("FaxNumber"))%>
Email: "><%= objRS("EmailAddress")%>

">View My Listings

Find A Vehicle

" target=" ">View My Website

<% if objRs("AgentDescription") <> "" then %> <% end if %>

<%= Ucase(objRs("firstName"))%> <%= ucase(objRs("LastName"))%>

<%= objRS("AgencyName") %> - <%= objRS("State") %>

<%= objRs("Address") %>

<%= objRs("City") %>, <%= objrs("State") %> <%= objRs("Zip") %>

About Me:
<%= objRs("AgentDescription") %>