Dave- I do need to post to a different page, so does that mean I can't use the
code you've shared? Is there any way to send the value of a hard-coded
cfselect option to another page? I have another cfform on the same page that
uses a dynamically generated drop-down list; this one allows me to pass a value
to the second page and correctly outputs the related data. I suppose if need
be I could create a mini table to house these options, but that's probably not
the best solution from the database standpoint... Thoughts?
Thanks for all the help!
Christina
>Christina,
>
>You are comparing a "string" value to 0 and that will always return false.
>For example, you have "RegionalSearch" IS 0. "RegionalSearch" is equal to
>RegionalSearch (not the variable, but the actual string). That, of course,
>will never equal 0. Also, it looks like you are trying to reference a
>variable that does not exist in your form (forecast_bycommunity_form).
>Also, you have a hidden form field, "reporttype" that will ALWAYS be 2, so
>even if your conditional statement (the cfif/elseif) would have the
>variables properly specified, you would never get to Total Forecasted School
>Age Population (5-17) by School District, because reporttype will always
>equal 2. So even if someone selected that item from your drop down, your
>page would still display the Total Forecasted Employment by Community.
>Lastly, if you are posting to the same page, then you don't need to specify
>the action in <cfform> You can, of course, but if you are really posting to
>a different page, then your display code on this page would never be reached
>anyway. I'm guessing, but I think this is what you are looking for:
>
><cfform name="forecast_bycommunity_form" method="post" preservedata="yes">
>
> <div id="search" style="border:1px solid black; padding:10px;
>width:230px;">
> Regional Search<br /><br />
> <cfselect name="RegionalSearch" size="4" style="width:230px">
> <option value="0">Total population by Community</option>
> <option value="1">Total households by Community</option>
> <option value="2">Total employment by Community</option>
> <option value="3">School age pop. (5-17) by School
>District</option>
> </cfselect><br /><br />
> <input type="submit" value="Search Data" id="fbc_submit" />
> </div>
>
></cfform>
>
><cfif isDefined("form.RegionalSearch")>
><div class="title" style="width:890px; text-align:center">
> <cfif form.RegionalSearch EQ 0>
> Total Forecasted Population by Community
> <cfelseif form.RegionalSearch EQ 1>
> Total Forecasted Households by Community
> <cfelseif form.RegionalSearch EQ 2>
> Total Forecasted Employment by Community
> <cfelse>
> Total Forecasted School Age Population (5-17) by School District
> </cfif>
></div>
></cfif>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:4213
Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
