CFGurus: A CFQuery and database question

Fri, 29 Dec 2000 17:06:55 -0800 

<html><DIV>
<P><BR>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).&nbsp; I am trying to build a page with a pull down select menu of different 
towns in the state of connecticut.&nbsp; When the user selects a town (i.e. 
Plainfield, Smallville...ect.), I&nbsp;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.......).&nbsp;The million dollar question is: how do i set up my pull down 
"town" variables in my code so that&nbsp;when a specific town is selected, i 
get&nbsp;that specific town's information from my database.&nbsp; 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.</P>
<P>Below is what i have for my CFQUERY coding ,&nbsp; my CFOUTPUT coding, as well as 
coding for my pull down menu.&nbsp; &nbsp;</P>
<P>Please ANY help,especially with the coding, would be greatly appreciated. Have a 
safe holiday everyone.</P>
<P>&nbsp;</P>
<P>thanks, colin</P>
<P>Here is&nbsp;my&nbsp;coding:&nbsp;&nbsp;</P></DIV>
<DIV></DIV>
<DIV>&lt;CFQUERY NAME="GetResults" DATASOURCE="Reminder"&gt;<BR>&nbsp;SELECT town, 
organization, headline, body, event_date<BR>&nbsp;FROM 
GetResults<BR>&nbsp;WHERE&nbsp;?????????</DIV>
<DIV>&nbsp;</DIV>
<DIV>&nbsp;<BR>&lt;/CFQUERY&gt;</DIV>
<DIV>&nbsp;</DIV>
<DIV>&nbsp;</DIV>
<DIV>&lt;CFOUTPUT QUERY = 
"GetResults"&gt;<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;P&gt;Town:
 #town# 
&lt;/P&gt;<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;P&gt;Organization:
 #organization# 
&lt;/P&gt;<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;P&gt;Headline:
 #headline# 
&lt;/P&gt;<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;P&gt;Body:
 #body# 
&lt;/P&gt;<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;P&gt;Event
 Date: #event_date# 
&lt;/P&gt;<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<BR>&nbsp;&lt;/CFOUTPUT&gt;</DIV>
<DIV>&nbsp;</DIV>
<DIV>&nbsp;</DIV>
<DIV>&nbsp;</DIV>
<DIV>&nbsp;</DIV>
<DIV>******TOWN PULLDOWN********</DIV>
<DIV>&nbsp;</DIV>
<DIV>&lt;table border="0" cellpadding="0" cellspacing="0" 
width="611"&gt;<BR>&nbsp;&nbsp;&nbsp;&nbsp;&lt;tr&gt;<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;td
 width="99"&gt;&lt;img height="40" width="99" 
src="images/navhead.gif"&gt;&lt;/td&gt;<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;td 
valign="middle"&gt;&lt;font 
size="2"&gt;<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;form name="FormName" 
action="(Empty Reference!)" 
method="get"&gt;<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Search:&lt;/font&gt;&lt;font 
face="Verdana" size="2"&gt; &lt;select name="selectName" size="1" 
tabindex="1"&gt;<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;option 
value="Manchester" 
selected&gt;Manchester<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;option 
value="Ashford" 
selected&gt;Ashford<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;option 
value="East Hartford" selected&gt;East 
Hartford<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;option value="East Windsor" 
selected&gt;East Windsor<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;option 
value="Ellington" 
selected&gt;Ellington<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;option 
value="Enfield" 
selected&gt;Enfield<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;option 
value="Pomfret" 
selected&gt;Pomfret<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;option 
value="Somers" 
selected&gt;Somers<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;option 
value="South Windsor" selected&gt;South 
Windsor<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;option value="Stafford" 
selected&gt;Stafford<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;option 
value="Stafforville" 
selected&gt;Stafforville<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;option 
value="Suffield" 
selected&gt;Suffield<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;option 
value="Tolland" 
selected&gt;Tolland<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;option 
value="Vernon" 
selected&gt;Vernon<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;option 
value="Warehouse Point" selected&gt;Warehouse 
Point<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;option value="West Suffield" 
selected&gt;West Suffield<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;option 
value="Willington" 
selected&gt;Willington<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;option 
value="Windsor" 
selected&gt;Windsor<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;option 
value="Windsor Locks" selected&gt;Windsor 
Locks<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;option value="Brooklyn" 
selected&gt;Brooklyn<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;option 
value="Chaplin" 
selected&gt;Chaplin<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;option 
value="Colchester" 
selected&gt;Colchester<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;option 
value="Coventry" 
selected&gt;Coventry<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;option 
value="Danielson" 
selected&gt;Danielson<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;option 
value="Dayville" 
selected&gt;Dayville<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;option 
value="East Haddam" selected&gt;East 
Haddam<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;option value="E. Woodstock" 
selected&gt;E. Woodstock<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;option 
value="Killingly" 
selected&gt;Killingly<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;option 
value="Lebanon" 
selected&gt;Lebanon<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;option 
value="Mansfield" selected&gt;Mansfield 
Mansfield<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;option value="Moodus" 
selected&gt;Moodus<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;option value="No. 
Grosvenordale" selected&gt;No. 
Grosvenordale<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;option 
value="Plainfield" 
selected&gt;Plainfield<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;option 
value="Pomfret" 
selected&gt;Pomfret<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;option 
value="Putnam" 
selected&gt;Putnam<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;option 
value="Sterling" 
selected&gt;Sterling<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;option 
value="Storrs" 
selected&gt;Storrs<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;option 
value="Thompson" 
selected&gt;Thompson<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;option 
value="Willimantic" 
selected&gt;Willimantic<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;option 
value="Windham" 
selected&gt;Windham<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;option 
value="Woodstock" 
selected&gt;Woodstock<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;option 
value="all" selected&gt;Town 
News<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;/select&gt;&nbsp;</DIV>
<DIV>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;/form&gt;<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;/font&gt;&lt;/td&gt;<BR>&nbsp;&nbsp;&nbsp;&nbsp;&lt;/tr&gt;<BR>&nbsp;&nbsp;&nbsp;&lt;/table&gt;</DIV><br
 clear=all><hr>Get your FREE download of MSN Explorer at <a 
href="http://explorer.msn.com">http://explorer.msn.com</a><br></p></html>

~~~~~~~~~~~~~ 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

Reply via email to