Select one record attempt

Report · Feb 18, 2009

I have a form in CF 8 that lists several records depending on the query results.
Each time I hit the select button it goes to the action page (second.cfm) and all the records show even though I just selected for one record.

Here is my form:

<FORM ACTION="second.cfm" METHOD="POST">

<TABLE WIDTH="600" BORDER="1" ALIGN="CENTER">

<TR>
<TH align=left>City</TH>
<TH align=left>State</TH>
<TH align=left>County</TH>
<TH align=left>SELECT ONLY ONE</TH>
</TR>

<CFOUTPUT QUERY="getMailingList">

<TR>

<TD align=left>#City#</</TD>
<TD align=left>#State#</td>
<TD align=left>#County#</TD>
<TD align=left><INPUT TYPE="Submit" value="SELECT"></TD>
</TR>
</CFOUTPUT>
<tr>
<td colspan="8">
</td>

</tr>
</TABLE>
</FORM>

My second.cfm page:

<cfoutput>
#form.City#<br>
#form.State#<br>
#form.County#
</cfoutput>

Even though I select one selection (submit) for the specific record I always get all the records.
Please advise how to make this work where I hit the select button and it should give me the one record I selected to show up in the second.cfm page.

Report · Feb 18, 2009

The form code you posted does not contain anything resembling an input or select in which you can specify what you want.