<cfquery name="getsites" datasource="#ds#">
select *
from metrosource.mediakit
where id = #url.id#</cfquery>
<font face=verdana size=-1>
<strong>This is the  status update for the following account.  Please reply to this email now.
</strong>
<p>
<cfoutput query="getsites">

Subject: #getsites.subject# <br />
Name: #getsites.name# <br />
<font face=verdana size=-1>Email: #getsites.email#<br />
<font face=verdana size=-1>Area: #getsites.area# <br />
<font face=verdana size=-1>Phone: #getsites.phonenumber# <br />
<font face=verdana size=-1>Message: #getsites.message#
<br /><br />
<font face=verdana size=-1>Submitted On: #dateformat(getsites.datetime,'m/d/yyyy')#
<br /><br />

</cfoutput>
<font face=verdana size=-1>
<p>
<Cfoutput>
<form action="https://www.cityguideny.com/newadmin/updateleadsmetro.cfm?sendme=on&id=#url.ID#" method="post">
</cfoutput>
<font face=verdana size=-1>
<input name="laststatus" type="radio" value="sold - ink on paper-YEAH!" /> sold - ink on paper-YEAH!<Br />
<input name="laststatus" type="radio" value="met and there is interest" /> met and there is interest<Br />
<input name="laststatus" type="radio" value="met and there is no interest for now" /> met and there is no interest for now<br />
<input name="laststatus" type="radio" value="have an appointment" /> have an appointment<Br />
<input name="laststatus" type="radio" value="was unable to reach, yet" /> was unable to reach, yet
<p>
Comments:
<textarea name="laststatusother" rows="5" cols="100"></textarea>



<input type="submit" Value="SEND"></font></form>

<p>