Return two queries with <cfreturn>

Forum|Forum|17 years ago
June 3, 2008
3 replies
380 views

Hello All,

I know I've seen it done somewhere, but I can't seem to find the example. I need to return two queries like:

<cfreturn getCurrentProjects and getProjectRequestByStatus/>

Something like that... not getting the right syntax or something. Any clues?

Thanks!

This topic has been closed for replies.

D

Dan_Bracuk

Inspiring

That changes everything. Ian's answer won't solve your problem either. You are going to have to figure out how to put everything into one query. Looking at the query names in your OP, it seems that it should be quite simple, but they could be misleading.

D

Dan_Bracuk

Inspiring

While Ian's answer is correct, my approach would be to run two functions and return one query per. It would be simpler to develop and maintain.

K

kdennis4Author

Participating Frequently

Thanks Dan.... I would do that, but I've got a Flex Datagrid that needs information from both queries... I'm not sure if I can have two dataProviders for a Grid... I should check that out! Thanks again!

N

Newsgroup_User

Inspiring

You can't!!!! You can only return one value with <cfreturn...>

.
..
...

But of course there is nothing preventing that one value to be a
structure or array contain two query record sets.

I.E.

<cfset var myReturn = strunctNew()>
...
<cfset myReturn.getCurrentProjects = getCurrentProjects>

<cfset myReturn.getProjectRequestByStatus = getProjectRequestByStatus>


<cfreturn myReturn>

K

kdennis4Author

Participating Frequently

Thank you for your quick response! Just need to figure out how to display it out in my Flex App now.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded