Greetings,
Am dynamically creating and checking a set of check boxes with the code below:
<!---Following code retrieves values tobe selected in checkboxes from data
in Cities_Served and County tables--->
<CFQUERY NAME="getcodes" DATASOURCE="pbs">
SELECT County.ID, County.County, 1 as FLG
FROM Cities_Served,County
WHERE Provider_ID = #ID#
AND Cities_Served.County_Code = County.ID
UNION
<!---Following code populates checkboxes --->
SELECT County.ID, County.County, 0 as FLG
FROM County
WHERE County.ID NOT IN (SELECT Cities_Served.County_Code
FROM Cities_Served WHERE Provider_ID = #ID# )
</CFQUERY>
<!--- Make check boxes --->
<CFOUTPUT QUERY="getcodes">
<input TYPE="checkbox" NAME="County_Code" value="#County_Code#"
<CFIF> #FLG#>checked</CFIF>>
#County#
<br>
</CFOUTPUT>
<!--END SNIPPET--->
I am getting: "Error resolving parameter County_Code , error occurred
while evaluating the expression #County_Code#"
Have gotten this to work elsewhere, but can't see my error here. Anybody
see the mistake in the code or know a better way to do this?
Many thanx in advance,
Chris
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.