Skip to main content
Participant
February 19, 2009
Question

Select one record attempt

  • February 19, 2009
  • 1 reply
  • 254 views
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.
    This topic has been closed for replies.

    1 reply

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