I've got a form with 4 drop downs. 1. Type:user selects car or motorcycle 2. Make: bound to type. Works good. 3. Model. I'm trying to use this: bind="cfc:model.getdata09.getmodels(which={wh...@none},make={m...@click})"
However, I get an error that motorcycle is undefined in my function. Can't see what's wrong... Here's my function: <cffunction name="getmodels" access="remote" returnType="query"> <cfargument name="make" type="string" required="true"> <cfargument name="which" type="string" required="true"> <cfset var data=""> <cfset which ="#arguments.which#"> <cfif which is "car"> <cfset THIS.table="cardata"> </cfif> <cfif which is motorcycle> <cfset THIS.table="motorcycledata"> </cfif> <!--- Get data ---> <cfquery name="data" datasource="#THIS.dsn#" > SELECT distinct model FROM #THIS.table# WHERE make = <cfqueryPARAM value = "#ARGUMENTS.make#" CFSQLType = "CF_SQL_VARCHAR"> ORDER BY model </cfquery> <!--- And return it ---> <cfreturn data> </cffunction> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321810 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4