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
