Change the name and remove session.
Then add a return statement
<cfquery name="qryListNames" datasource="#application.DSN#">
SELECT
blablabla
FROM
</cfquery>
<cfreturn qryListNames />
</cffunction>
If you want to set the query in the session scope you should do that after
the call to the function, i.e.
<cfset session.qryListNames = obj.getAllNames() />
Taco Fleur - Pacific Fox
an industry leader with commercial IT experience since 1994 .
http://www.pacificfox.com - Web Design and Development
We endorse PayPal, accept payments online now!
> -----Original Message-----
> From: Michel Deloux [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, 4 October 2005 7:09 AM
> To: CF-Talk
> Subject: Invoking query and fails
>
>
> Hi all
>
> we have a form with simple fields. If session.nameofquery is
> not defined I invoke a cfc to get that data. Looks like:
>
> <CFIF IsDefined('session.qryMyQuery')>
> <cfdump var="#session.qryMyQuery#">
> <cfoutput query="#session.qryMyQuery#">
> #ID_name"<br />
> </cfoutput>
>
> <CFELSE>
>
> <cfinvoke component="qryCFC" method="getAllNames">
> </cfinvoke>
> <cfdump var="#session.qryMyQuery#">
> </CFIF>
>
> This is my simple function:
>
> <cffunction name="getAllNames" output="true" access="public"
> hint="Get all names" returntype="void">
> <cfargument name="blablabla" type="numeric" required="no">
> <cfquery name="session.qryListNames" datasource="#application.DSN#">
> SELECT
> blablabla
> FROM
> blablabla
> </cffunction>
>
> OK, OK, the good CFC practices Manual don't uses session
> inside components. Right. But using application scope don't
> work... ;-(
>
> In the first call to CFC I invoke that cfc which output a
> query. But after cfoutput CF throws an error:
>
> Complex object types cannot be converted to simple values.
>
> Why? That cfc returns a query right? Or I'me wrong?
>
> Cheers
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219982
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
