cfselect bind value for query field

i have 2 cfselect drop downs. first populated query in cfc. return list of field names. user able select first cfselect <field name> , populate second cfselect values query used field name selected first cfselect choice.

is possible , how accomplish this? keep getting error: "...values returned getvalues function not of type query..."

thanks help.

here code:

<cffunction name="getfields" access="remote" returntype="string">
<cfargument name="search5" type="any" required="false" default="">

<!--- define variables --->
<cfset var result="">

<!--- search --->
<cfquery name="fieldnameqry" datasource="livermore_sql">
select *
lu_assessor
order fieldnamelu
</cfquery>

<!--- , return --->
<cfreturn valuelist(fieldnameqry.fieldnamelu)>
</cffunction>

<cffunction name="getvalues" access="remote" returntype="string">
<cfargument name="search6" type="any" required="false" default="">

<!--- define variables --->
<cfset var result="">

<!--- search --->
<cfquery name="valuesqry" datasource="livermore_sql" maxrows="20">
select #arguments.search6#
city
</cfquery>

<!--- , return --->
<cfreturn valuelist(search6)>
</cffunction>

<tr>
<td>
<cfselect name="fieldname" style="font-size: 10px;"
query="fieldnameqry"
value="fieldnamelu" display="fieldnamelu">
<option selected>select field...</option>
</cfselect>
</td>
<td>
<cfselect name="valuelu" style="font-size: 10px;"
bind="cfc:srchvalues.getvalues({fieldname})" bindonload="false">
<option selected>values...</option>
</cfselect>
</td>
</tr>

look @ returntype attribute of cffunction tag.

More discussions in Advanced Techniques

adobe