This is the file of test.cfm
<cfinvoke component="test2"
method="getFeatures"
returnvariable="Features">
<form>
<cfoutput query="Features">
<input type="checkbox"
name="Feature_ID"
value="#Feature_ID#"
check="false">#Feature# <br />
</cfoutput>
<cfdiv bind="url:test2a.cfm?checkboxvalue={Feature_ID@click}">
</form>
----------------------------------------------------------------------------------------------------------------------
this is the file of test2a.cfm
<cfparam name="url.checkboxvalue" default="">
<cfset args = structnew()>
<cfset args.Feature_ID = url.checkboxvalue>
<cfinvoke component="test2"
method="sendFeatures" search="#args#" returnvariable="results">
<cfoutput query="results">
<tr>
<td>#Restaurant_ID#</td>
<td>#Name#</td>
</tr>
</cfoutput>
----------------------------------------------------------------------------------------------------------------------
this is the cfc file
<cfcomponent>
<cfset ds = "Reservation">
<cffunction name="getFeatures"
access="public"
returntype="Query">
<cfset var Features="">
<cfquery name="Features" datasource="#ds#">
SELECT Feature_ID, Feature
FROM Features
</cfquery>
<cfreturn Features>
</cffunction>
<cffunction name="sendFeatures"
returntype="Query"
access="public">
<cfargument name="Feature_ID" type="any" default="">
<cfset var CheckBox ="">
<cfquery name="CheckBox" datasource="#ds#">
SELECT r.Name , r.Restaurant_ID, f.feature
FROM Restaurants r, Bridge1_Restaurant_Features b, Features f
where b.Feature_ID = f.Feature_ID AND b.Restaurant_ID = r.Restaurant_ID
<cfif #ARGUMENTS.Feature_ID# IS NOT "">
AND f.Feature_ID IN (#ARGUMENTS.Search.Feature_ID#)
</cfif>
GROUP BY r.Name
</cfquery>
<cfdump var="#arguments#">
<cfreturn CheckBox>
</cffunction>
</cfcomponent>
Its exacly what I thought it will be :
Notice this :
<cfinvoke component="test2"
method="sendFeatures" argumentCollection="#args#" returnvariable="results">
Compare to yours :
<cfinvoke component="test2"
method="sendFeatures" search="#args#" returnvariable="results">
Do you see the diffrence ?
This is why you add a ARGUMNET.SEARCH.Feature_ID istead of ARGUMNET.Feature
So Change the INVOKE statement and it should work now
And IT will be good for you (if you want to be able to solve things like this on your own) to learn about structrues and the use of them...
AdChoices