Hello Everyone,
I wanted to give a little more information with regards to my first message
about CF_TwoSelectsRelated not working on one table. I have three instances
of the same code inside a CFFORM. Each is enclosed within an CFIF statement.
Here is the basic form
<cfform action="index.cfm?fuseaction=addservarea" method="POST"
onSubmit="return require_county" name="responsearea">
<cfif>
<cfquery>StateZip
<CF_TwoSelectsRelated>ZipCode</cfif>
<cfif>
<cfquery>StateCity
<CF_TwoSelectsRelated>City</cfif>
<cfif>
<cfquery>StateCounty
<CF_TwoSelectsRelated>County</cfif>
</cfform>
The tag looks like this:
<cfquery>StateCounty</cfquery>
<tr>
<td><CF_TwoSelectsRelated
QUERY="StateCounty"
NAME1="State"
NAME2="County"
DISPLAY1="State"
DISPLAY2="County"
VALUE1="State"
VALUE2="County"
FORCEWIDTH1="10"
FORCEWIDTH2="70"
SIZE1="1"
SIZE2="1"
HTMLBETWEEN="<BR>"
AUTOSELECTFIRST="Yes"
EMPTYTEXT1="(choose a State)"
EMPTYTEXT2="(now choose a County)"
ONCHANGE="Submit!"
FORMNAME="responsearea"></td>
</tr>
With NAME2, DISPLAY2 and VALUE2 being "County", "City" or "Zipcode"
respectively.
Zipcode is the largest table followed by City, then County. City is the
only one where the second value field is not generated by a selection in the
first value field. All that is visible is the EMPTYTEXT2 message. Even if I
remove the other two tag instances, the City tag still fails to populate the
second selection field when executed.
Thats about it. What can be the problem?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
