3 Replies Latest reply: Sep 19, 2006 8:32 AM by Newsgroup_User

Q of Q in a cfc

Dan Bracuk Sep 19, 2006 7:16 AM

I have coded a workaround to solve my specific problem, but I was wondering if I could do this without the workaround.

My cfc has this in it:
<cfproperty name="PrimarySurgeons" type="query">

Eventually I populate this query and want to use it in a q of q.

This crashes;
select Property.PrimarySurgeons.fieldname, etc

This also crashes
select Property.PrimarySurgeons["fieldname"], etc

This was my workaround
var tempquery = Property.PrimarySurgeons;

Is there a syntax that would have worked?

1. Re: Q of Q in a cfc

hatethisnamegame Sep 19, 2006 7:33 AM (in response to Dan Bracuk)

You could create the query using QueryNew().
<cfset PrimarySurgeons = QueryNew()>
after populating it you can q of q with
SELECT PrimarySurgeons.fieldname, etc.
Like Show 0 Likes (0)

Actions
2. Re: Q of Q in a cfc

Newsgroup_User Sep 19, 2006 7:34 AM (in response to Dan Bracuk)

Your work around is as good as it gets in QoQ, as far as I know.

You cannot use more than one dot in a reference to anything in the QoQ SQL
(or something silly like that).

--
Adam
Like Show 0 Likes (0)

Actions
3. Re: Q of Q in a cfc

Newsgroup_User Sep 19, 2006 8:32 AM (in response to Dan Bracuk)

> This crashes;
> select Property.PrimarySurgeons.fieldname, etc

PS: when saying things like this, it's always best to post the error. Or
explain how it crashes.

--
Adam
Like Show 0 Likes (0)

Actions

Go to original post