"Nested" queries clobber datasource in query they are called from!
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.
