Webmaster Forum / Flash / Flash Remoting / December 2004

I've been working on building an advanced search for a database, but I can't
get it past 2 variables(and arguments).  I can't do it as simply as just
searching all fields, I have 8 separate arguments I would like to be able to
use in the search. My current code is as follows:

<cfcomponent displayName="findFlavor">
    <cffunction name="FlavorNameSort"
               access="remote"
                returnType="query"
                output="false"
                >
                <cfargument name="flavorName" type="string" required="false"/>
                <cfargument name="wynnStarrNumber" type="string" required="false"/>
                <cfargument name="natArt" type="string" required="false"/>
                <cfargument name="kosher" type="string" required="false"/>
                <cfargument name="gmoFree" type="string" required="false"/>
                <cfargument name="phase" type="string" required="false"/>
                <cfargument name="application" type="string" required="false"/>
        <cfquery name="flavorNameQuery" datasource="frank">
        SELECT *
        FROM wynn
        WHERE flavorName like '%#arguments.flavorName#%'
        AND wynnStarrNumber like '%#arguments.wynnStarrNumber#%'
        AND natArt like '%#arguments.natArt#%'
        AND kosher like '%#arguments.kosher#%'
        AND gmoFree like '%#arguments.gmoFree#%'
        AND phase like '%#arguments.phase#%'
        AND application like '%#arguments.application#%'
        ORDER BY flavorName asc
        </cfquery>
        <cfreturn flavorNameQuery />
    </cffunction>
</cfcomponent>   

What it's returning now when I debug in flash(I checked, and it IS sending all
the variables correctly), is that it tells me that the function FlavorNameSort
doesn't exist with those arguments. Also I checked out the server, and it's
updating fine, because when I switched it to have only 2 arguments, it works
fine.

HELP HELP HELP Please!!

-Tom