Here is something that's puzzling me, and if I knew Javascript better I
could probably figure it out, but maybe one of you know... I have a page
where a user can select (a) What columns from the DB they want displayed,
and (b) Up to 4 sort order columns. The Sort Order selections are in a
series of 4 dropdowns, each populated from a query. The checkboxes for
Columns To Display are also obtained by looping through a query. My
question is, how can I force a checkbox to become checked based on a
selection from a dropdown box? For example, if they select MAIN ACCOUNT
from the first dropdown under Sort Order, can I make the MAIN ACCOUNT
checkbox under Columns To Display become checked? What I want to avoid is
having them select a Sort Order item when they have not selected the
corresponding Columns To Display item.
Relevant code:
<CFOUTPUT QUERY="GetCategories">
<TR>
<TD>#FIELDDESC1#</TD>
<TD>
<CFIF SELECTED IS 1>
<INPUT TYPE="checkbox" NAME="Display" VALUE="#FIELDNAME1#" CHECKED>
<CFELSE>
<INPUT TYPE="checkbox" NAME="Display" VALUE="#FIELDNAME1#">
</CFIF>
</TD>
</TR>
</CFOUTPUT>
<B>Sort by:</B><BR>
<SELECT NAME="Sort1"> (there are 4 of these, Sort1 through Sort4)
<OPTION VALUE="0" SELECTED>Select sort item
<CFOUTPUT QUERY="GetCategories">
<OPTION VALUE="#FIELDNAME1#">#FIELDDESC1#
</CFOUTPUT>
</SELECT>
Any help appreciated!
Gina Shillitani
Technical Officer
JPMorgan Chase & Co.
[EMAIL PROTECTED]
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
