You are not selecting County_Code in the getcodes query. You should use County.ID as your checkbox value. -David On Mon, 27 Mar 2000 16:15:32 -0700 Chris Geanious <[EMAIL PROTECTED]> writes: > 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. ________________________________________________________________ YOU'RE PAYING TOO MUCH FOR THE INTERNET! Juno now offers FREE Internet Access! Try it today - there's no risk! For your FREE software, visit: http://dl.www.juno.com/get/tagj. ------------------------------------------------------------------------------ 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.
