cfc的AJAX返回变量

Question

I'm trying to perform an SQL COUNT on my database using AJAX thru a cfc file, however, I have no clue how to get the return variable. The cfc file is as follows

<cffunction name="getSpeakerCount" access="remote" returntype="query">
    <cfargument name="AID" required="true" type="string">
        <cfquery name="getSpeaker" datasource="SpeakerCard">
            SELECT COUNT(AID)
            FROM tbl_SpeakerCard_Log
            WHERE AID = '#AID#'
        </cfquery>
    <cfreturn getSpeakerCount>
</cffunction>

My ajax is along the lines of this... I'm not sure how to properly call/use it.

for (var i = 0; i < X; i++)
{
    $.ajax('actions/AgendaList.cfc?wsdl', {method : 'getSpeakerCount', AID: AgID, dataType: 
"text", type: 'get', success: function(data)
            {
                SCount[i] = data;
            }
            }});

This always returns all the elements in SCount[i] as undefined. I'm not sure how to get the count return from the cfc... Any help is appreciated!

Answer 1

Your function will fail no matter how you call it. You say you want to return a number but, as pointed out in the comment, you are returning an undefined variable. This will fix that:

• In your cffunction tag, change the return type from query to numeric.
• In the select clause of your query, use an sql alias to give yourself a column name.
• Since your query will only have one field and one row, return that value.

So this:

<cffunction name="getSpeakerCount" access="remote" returntype="query">

becomes this:

<cffunction name="getSpeakerCount" access="remote" returntype="numeric">

and this:

SELECT COUNT(AID)

becomes this:

SELECT COUNT(AID) records

and this:

<cfreturn getSpeakerCount>

becomes this:

<cfreturn getSpeaker.records>

The comment about using query paramters is also valid. Additionally, you should scope that variable.

So this:

WHERE AID = '#AID#

should be this:

WHERE AID = <cfqueryparam cfsqltype="cf_sql_varchar" value="#arguments.aid#">

Make sure you can run this using ColdFusion code before trying it with ajax.