Well, you can't have ALL towns selected.
You need a </select> at the end.
And try:
<CFQUERY NAME="GetResults" DATASOURCE="Reminder">
SELECT town, organization, headline, body, event_date
FROM GetResults
WHERE town = '#Form.SelectName#'
</CFQUERY>
best, paul
At 08:17 PM 12/29/00 -0500, you wrote:
>ok all you CFMasters.....I think i have a relatively simple CF question
>concerning databases and CFQuery. But for the life of me am stumped (4
>hours to put it exactly). I am trying to build a page with a pull down
>select menu of different towns in the state of connecticut. When the user
>selects a town (i.e. Plainfield, Smallville...ect.), I would like my user
>to be sent to a cfm "town" page with the corresponding town data (ie.
>town, organization, population size, event date, ect.......). The million
>dollar question is: how do i set up my pull down "town" variables in my
>code so that when a specific town is selected, i get that specific town's
>information from my database. I know conceptually what is going on here
>but am having trouble with the correct CF coding here. I think it has
>something to do with setting my town variable up correctly in my inital
>CFQUERY and in my pull down menu. But cannot pinpoint it.
>
>Below is what i have for my CFQUERY coding , my CFOUTPUT coding, as well
>as coding for my pull down menu.
>
>Please ANY help,especially with the coding, would be greatly appreciated.
>Have a safe holiday everyone.
>
>
>
>thanks, colin
>
>Here is my coding:
><CFQUERY NAME="GetResults" DATASOURCE="Reminder">
> SELECT town, organization, headline, body, event_date
> FROM GetResults
> WHERE ?????????
>
>
></CFQUERY>
>
>
><CFOUTPUT QUERY = "GetResults">
>
> <P>Town: #town# </P>
> <P>Organization: #organization# </P>
> <P>Headline: #headline# </P>
> <P>Body: #body# </P>
> <P>Event Date: #event_date# </P>
>
> </CFOUTPUT>
>
>
>
>
>******TOWN PULLDOWN********
>
><table border="0" cellpadding="0" cellspacing="0" width="611">
> <tr>
> <td width="99"><img height="40" width="99"
> src="images/navhead.gif"></td>
> <td valign="middle"><font size="2">
> <form name="FormName" action="(Empty Reference!)" method="get">
> Search:</font><font face="Verdana" size="2"> <select
> name="selectName" size="1" tabindex="1">
> <option value="Manchester" selected>Manchester
> <option value="Ashford" selected>Ashford
> <option value="East Hartford" selected>East Hartford
> <option value="East Windsor" selected>East Windsor
> <option value="Ellington" selected>Ellington
> <option value="Enfield" selected>Enfield
> <option value="Pomfret" selected>Pomfret
> <option value="Somers" selected>Somers
> <option value="South Windsor" selected>South Windsor
> <option value="Stafford" selected>Stafford
> <option value="Stafforville" selected>Stafforville
> <option value="Suffield" selected>Suffield
> <option value="Tolland" selected>Tolland
> <option value="Vernon" selected>Vernon
> <option value="Warehouse Point" selected>Warehouse Point
> <option value="West Suffield" selected>West Suffield
> <option value="Willington" selected>Willington
> <option value="Windsor" selected>Windsor
> <option value="Windsor Locks" selected>Windsor Locks
> <option value="Brooklyn" selected>Brooklyn
> <option value="Chaplin" selected>Chaplin
> <option value="Colchester" selected>Colchester
> <option value="Coventry" selected>Coventry
> <option value="Danielson" selected>Danielson
> <option value="Dayville" selected>Dayville
> <option value="East Haddam" s
> </form>
> </font></td>
> </tr>
> </table>
>
>
>----------
>Get your FREE download of MSN Explorer at
><http://explorer.msn.com>http://explorer.msn.com
>
>
~~~~~~~~~~~~~ Paid Sponsorship ~~~~~~~~~~~~~
Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free
Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support
Visit SoloServer, https://secure.irides.com/clientsetup.cfm.
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
