<tr>
<td>Select Model:</td>
<td><cfselect name="model" bindOnLoad="Yes" bind="cfc:data.getmodel({makes})"
display="model" value="model" />
</td>
</tr>
<tr>
<td>Select Engine:</td>
<td><cfselect name="engine" bindOnLoad="Yes" bind="cfc:data.getengine({model})"
display="engine" value="engine" />
</td>
</tr>
<tr>
<td>Select OE:</td>
<td><cfselect name="OE" bind="cfc:data.getOE({model}, {engine})"
display="OE" value="OE" />
</td>
</tr>
<cfcomponent output="false">
<cfset variables.dsn = "Volusion">
<cffunction name="getmakes" access="remote" returntype="query">
<cfset var getData = "">
<cfquery name="getData" datasource="#variables.dsn#">
SELECT DISTINCT make FROM ECM
ORDER BY make
</cfquery>
<cfreturn getData />
</cffunction>
<cffunction name="getmodel" access="remote" returntype="query">
<cfargument name="make" type="string" required="true">
<cfset var getData = "">
<cfquery name="getData" datasource="#variables.dsn#">
SELECT DISTINCT model FROM ECM
WHERE make = <cfqueryparam value="#arguments.make#" cfsqltype="cf_sql_varchar">
ORDER BY model
</cfquery>
<cfreturn getData />
</cffunction>
<cffunction name="getengine" access="remote" returntype="query">
<cfargument name="model" type="string" required="true">
<cfset var getData = "">
<cfquery name="getData" datasource="#variables.dsn#">
SELECT engine FROM ECM
WHERE model = <cfqueryparam value="#arguments.model#" cfsqltype="cf_sql_varchar">
ORDER BY model
</cfquery>
<cfreturn getData />
</cffunction>
<cffunction name="getOE" access="remote" returntype="query">
<cfargument name="model" type="string" required="true">
<cfargument name="engine" type="string" required="true">
<cfset var getData = "">
<cfquery name="getData" datasource="#variables.dsn#">
SELECT OE FROM ECM
WHERE model = <cfqueryparam value="#arguments.model#" cfsqltype="cf_sql_varchar">
AND engine = <cfqueryparam value="#arguments.engine#" cfsqltype="cf_sql_varchar">
ORDER BY OE
</cfquery>
<cfreturn getData />
</cffunction>
</cfcomponent>
I was following a tutorial so I don't know what that line does or why it's duplicated. Does the cfc help?