tracker issue : CF-3039096

Problem:

<cfset me = demo() />

<cffunction name="demo">
    <cfquery name="local.test" datasource="research">
        select * from rsUser
        order by userName
    </cfquery>

    <cfquery name="local.qoq" dbtype="query">
        select * from local.test
        where userName > ’n’
    </cfquery>    

</cffunction>

This code doesn’t work, never has, not even in CF8, the reason is the local.test in the second select

Now, in CF8, you could get around this by doing

select * from [local].test

which is kinda ugly

In CF9, you can also now just do

select * from test

since the default scope is local it just works, but this is unclear where this is coming from, if you didn’t know any beter reading this code you would think that test was test in the variables scope

So I think it should be fixed to work as

select * from local.test

Method:


Result:

----------------------------- Additional Watson Details -----------------------------

Watson Bug ID:	3039096

External Customer Info:
External Company:  
External Customer Name: Dale Fraser
External Customer Email: 66D97270447003E29920157F
External Test Config: 06/30/2009

Attachments:

Comments: