This content has been marked as final. Show 4 replies
The source or table name in the QoQ needs to be a simple string. You're passing in a query object instead.
How can I change it to work as a qofq?
If I want to refine that query created by the cfhttp, how can I pass either
the table or source. I created a master query and want to use it as a query
to query against.
> <cfset residential = JoinedRes()>
The name of your query is "residential". Just use the name without the # signs.
You should also be using the keyword VAR on all of your local function variables. Right now all of your variables ("residential", etc). exist in the VARIABLES scope. If your component is stored in a shared scope, this can lead to unexpected results when multiple threads access the functions at the same.
Well its late here, I'm heading to sleep. Night.