Referencing a cfquery of dbtype="query" in a cffunction

you could pass the query in as an argument to your function. Just name the arguement something other than query2 to keep them all straight. You can then perform operations using the query local to the function.

Just further clarify -

You are calling a functon and passing it the value of 'query2.tn'. The scope of your query is local to the calling page, so the function doesn't know about it.

The only variable your function recognizes is the column value tn. An easy fix will be to pass both the tn and query2 in comma delims.

<cffunction name=x returntype="string">
<cfargument name="theQuery" type="query">
<cfargument name=tn type="numeric">

</cffunction>

#x(query2.tn,query2)#

From Macromedia:
"Other variable scopes

A CFC (or external function file) shares the Form, URL, Request, CGI, Cookie, Client, Session, Application, Server, and Flash scopes with the calling page. Variables in these scopes are also available to all pages that are included by a CFC. These variables do not have any behavior that is specific to CFCs."

Still have an error:

Here is my query in the main .cfm

<cfquery name="stand" dbtype="query" >
SELECT (Sum(win)*2 + Sum(tie)) / ((Sum(win)+ Sum(loss) + Sum(tie)) * 2) as wpercent,
Sum(rf)  AS srf, Sum(ra) AS sra,
Sum(points) AS spoints,  
Sum(win) AS swin, Sum(loss) AS sloss, Sum(tie) AS stie ,

division,tm,TeamNumber

FROM ustand
GROUP BY division, tm, TeamNumber
ORDER BY division, spoints desc, wpercent desc, sra
</cfquery>


Here is the call to the function:

#streak(stand.TeamNumber,stand)#

Here is the function in function.cfm

<cffunction name=streak returntype="string">
<cfargument name=tn type="numeric">
<cfargument name=theQuery type="query">


<cfquery name="stkdata"  dbtype="query">
SELECT (case when Points = 2 then 'W'
        when Points = 1 then 'T'
            when Points = 0 then 'L' end) as Results from theQuery where TeamNumber = #tn#
order by GameDate Desc
</cfquery>

<cfset cnt = 0>
<cfset wlt = "#stkdata.Results[1]#">

<cfloop query="stkdata">
<cfif wlt eq "#stkdata.Results#">
<cfset cnt = cnt + 1>
<cfset wlt =  "#stkdata.Results#">
<cfelse>
<cfreturn "#wlt# " &  "#cnt#">
<cfabort>
</cfif>
</cfloop>
<cfreturn "#wlt# " &  "#cnt#">
</cffunction>

Here is the error I get:

Error Executing Database Query.  

Query Of Queries syntax error.
Encountered "case" at line 0, column 0. Incorrect Select List,  
 
The error occurred in C:\Inetpub\wwwroot\CFIDE\functions.cfm: line 18
Called from C:\Inetpub\wwwroot\CFIDE\TMPeibfjbibz.cfm: line 109
Called from C:\Inetpub\wwwroot\CFIDE\functions.cfm: line 18
Called from C:\Inetpub\wwwroot\CFIDE\TMPeibfjbibz.cfm: line 109
 
16 : SELECT (case when Points = 2 then 'W'
17 :         when Points = 1 then 'T'
18 :             when Points = 0 then 'L' end) as Results from theQuery where TeamNumber = #tn#
19 : order by GameDate Desc
20 : </cfquery>

 

I myself am actually battling this at the moment because I realized that something isn't working correctly with my query and the function I need is outside the scope of QoQ, so it's back to the SQL server.