Title:
Bug 75399:(Watson Migration Closure)The newly introduced query() function doesn't allow us building Query of queries
| View in TrackerStatus/Resolution/Reason: Closed/Won't Fix/
Reporter/Name(from Bugbase): David R / David Dharmaraj R (Daverms)
Created: 02/10/2009
Versions: 9.0
Failure Type: Unspecified
Found In Build/Fixed In Build: 0000 /
Priority/Frequency: Normal / Unknown
Locale/System: English / Platforms All
Vote Count: 0
Problem:
The newly introduced query() function doesn't allow us building Query of queries.
Please add this feature..
Thanks,
David R
Method:
<cfscript>
qry=new query();
qry.setName("master");
qry.setSQL("select * from employee");
qry.execute();
qry1=new query();
qry1.setName("detail");
qry1.setdbtype("query");
qry1.setDataSource("master");
qry1.setSQL("select * from master where lastname like ’F%’");
qry1.execute();
dump(var=qry1);
</cfscript>
Result:
Query of Queries runtime error.
"Table named master was not found in memory. The name is misspelled or the table is not defined".
The error occured in C:\ColdFusionCentaur\wwwroot\com\adobe\coldfusion\query.cfc (line 499)
----------------------------- Additional Watson Details -----------------------------
Watson Bug ID: 3037496
External Customer Info:
External Company:
External Customer Name: David Dharmaraj R
External Customer Email: 443F56B144BB54C5992016B7
External Test Config: 02/10/2009Attachments:
Comments: