<cfdiv id="contactWin" tagName="contactWin">
<cfquery name="getProspectContacts" datasource="#application.dsn#">
    SELECT PC.*
    FROM Prospects P INNER JOIN Prospect_Contacts PC ON P.Prospect_ID = PC.Prospect_ID
    WHERE P.Prospect_ID = <cfqueryparam value="#attributes.Prospect_id#" cfsqltype="CF_SQL_INTEGER">
</cfquery>
<cfscript>
    getProspectContactTypes = app.options("Prospect_Contact_Types");
</cfscript>
<table width="100%" border="0" cellspacing="0" cellpadding="4">
    <tr>
        <td class="result_item" valign="top" width="17%">Last Name</td>
        <td class="result_item" valign="top" width="17%">First Name</td>
        <td class="result_item" valign="top" width="17%">Title</td>
        <td class="result_item" valign="top" width="17%">Phone</td>
        <td class="result_item" valign="top" width="17%">Email</td>
        <td class="result_item" valign="top" width="17%">Contact Type</td>
        <td class="result_item">&nbsp;</td>
    </tr>
    <cfloop query="getProspectContacts">
        <tr class="<cfif currentrow MOD 2 EQ 0>grid_row<cfelse>grid_row_alt</cfif>">
            <td valign="top" width="17%">#getProspectContacts.First_Name#</td>
            <td class="<cfif currentrow MOD 2 EQ 0>grid_row<cfelse>grid_row_alt</cfif>" valign="top" width="17%">#getProspectContacts.Last_Name#</td>
            <td valign="top" width="17%">#getProspectContacts.Title#</td>
            <td valign="top" width="17%">#getProspectContacts.Phone#</td>
            <td valign="top" width="17%">#getProspectContacts.Email#</td>
            <td valign="top" width="17%">#getProspectContacts.Contact_Type#</td>
        </tr>
    </cfloop>
    <form method="post" target="contactWin">
    <tr>
        <td class="grid_row"><input type="text" name="first_name_edit" value="" size="20" maxlength="100" class="small"></td>
        <td class="grid_row"><input type="text" name="last_name_edit" value="" size="20" maxlength="100" class="small"></td>
        <td class="grid_row"><input type="text" name="title_edit" value="" size="20" maxlength="100" class="small"></td>
        <td class="grid_row"><input type="text" name="phone_edit" value="" size="20" maxlength="100" class="small"></td>
        <td class="grid_row"><input type="text" name="email_edit" value="" size="20" maxlength="100" class="small"></td>
        <td class="grid_row" colspan="3" valign="top" style="padding-top: 5px;">
            <cfif getProspectContactTypes.recordcount GT 1>
                <select name="prospect_contact_type_edit" class="required" class="small" style="margin-top: -10px;">
                    <option value="" Selected>Select...</option>
                    <cfloop query="getProspectContactTypes">
                        <option value="#getProspectContactTypes.option_value#">#getProspectContactTypes.option_text#</option>
                    </cfloop>
                </select>
            <cfelse>
                <input type="hidden" name="prospect_contact_type_edit" value="#getProspectContactTypes.Option_value#">
            </cfif>
            <input type="submit" name="contactAdd" value="Add" style="height: 22px; vertical-align: bottom; padding: 0px;">
        </td>
    </tr>
    </form>
</table>
<cfdump var="#form#">

                        </cfdiv>