"Nested" queries clobber datasource in query they are called from!

[Aaron_Silverman]

Much to my dismay, I discovered that "nested" queries clobber the datasource in the query they are called from.  You can get a nested query if inside <cfquery> tags you call a function (through # signs) that runs its own query.  If that query is to a different datasource, then the original query will actually be run against the nested query's datasource.

I thought I'd let you all know to see your thoughts, and ask if there is a better way to report this "Bug" (if we all agree its a bug) to Adobe.

[Adam Cameron.]

This came up a couple of weeks ago, and has been raised as a bug: http://cfbugs.adobe.com/cfbugreport/flexbugui/cfbugtracker/main.html#bugId=79382

It might help for you to vote for it.

--

Adam