query of queries inside cffunction

[JENS LYNET]

Hi im trying to use the benifits of query of queries, but cannot get it to
work...Im calling a cffunction inside a cfc (mx) from flash.mx here is my code:
Thanx in advance

<cffunction name="getmodel" access="remote" returnType="query">
<cfargument name="maerke" type="string">
<CFQUERY NAME="q_model" Datasource="2004printmore">
SELECT id, model FROM model
WHERE kategori = #maerke#
</CFQUERY>
<cfreturn q_model>
</cffunction>

<cffunction name="querymodel" access="remote" returnType="query">
<cfargument name="id" type="string">
<CFQUERY NAME="model_qq" dbtype="query">
SELECT id, model FROM q_model
WHERE model.id = #id#
</CFQUERY>
<cfreturn model_qq>
</cffunction>

[PaulH]

well both WHERE clauses are missing quotes:

WHERE kategori = '#maerke#'
WHERE model.id = '#id#'

and your second function's not getting a query passed into it. though i guess
because you're not scoping your queries these are in the cfc's variables scope.

[JENS LYNET]

Hi Paul I dont need the quotes, i tested that. But what do u mean 'second
function's not getting a query passed into it'? As i read the doc u just need
to use the name of the query that you want to query....

[Adam Cameron]

> <cffunction name="getmodel" access="remote" returnType="query">

> <cfargument name="maerke" type="string">
> <CFQUERY NAME="q_model" Datasource="2004printmore">

Well you're creating this query in this function...

> <cffunction name="querymodel" access="remote" returnType="query">
> <cfargument name="id" type="string">
> <CFQUERY NAME="model_qq" dbtype="query">
> SELECT id, model FROM q_model

.... But you're referring to it in this function.

How does querymodel() know about what goes on in getmodel()?

--

Adam

[PaulH]

your function arguments define those as "string".

good practice says that your functions should be 100% isolated from each other
& the application calling them. your second function isn't being passed a query
for it to work on. something like this maybe:

<!--- t.cfc --->
<cfcomponent>
<cffunction name="getData" output="No" returntype="query">
<cfset var q="">
<cfquery name="q" datasource="lab">
SELECT uniText, uniLanguage
FROM unicodeTest
ORDER BY uniLanguage
</cfquery>
<cfreturn q>
</cffunction>

<cffunction name="getSomeData" output="No" returntype="query">
<cfargument name="language" required="Yes" type="string">
<cfargument name="q" required="Yes" type="query">
<cfset var reQ="">
<cfquery name="reQ" dbtype="query">
SELECT uniText
FROM arguments.q
WHERE uniLanguage='#arguments.language#'
</cfquery>
<cfreturn reQ>
</cffunction>
</cfcomponent>

<!--- t.cfm --->
<cfscript>
q=createObject("component","t");
aQuery=q.getData();
b=q.getSomeData("Arabic",aQuery);
</cfscript>

<cfdump var="#b#">