Title:
Bug 83749:-(Watson Migration Closure)There is a problem when you do a query of query when you use a queryService query of a queryNew() query
| View in TrackerStatus/Resolution/Reason: Closed/Won't Fix/LowImpact
Reporter/Name(from Bugbase): Jorrit Janszen / Jorrit Janszen (Jorrit Janszen)
Created: 08/03/2010
Components: Database, Query-of-Query(IMQ)
Versions: 9.0.1
Failure Type: Unspecified
Found In Build/Fixed In Build: 9,0,1,274733 /
Priority/Frequency: Trivial / Unknown
Locale/System: English / Platforms All
Vote Count: 0
Problem:
There is a problem when you do a query of query when you use a queryService query of a queryNew() query.
Method:
<cfscript>//test case for query of queries usings querynew and query object://Make query object with queryNew()qUsers = queryNew("usename,userID","varChar,integer");queryAddRow(qUsers);querySetCell(qUsers,"usename","Jorrit");querySetCell(qUsers,"userID",1);querySetCell(qUsers,"usename","Ben");querySetCell(qUsers,"userID",2);querySetCell(qUsers,"usename","Tom");querySetCell(qUsers,"userID",3);writeDump(qUsers);queryService = new Query();//queryService.setName("qGetUserByID");queryService.setDBType("query");queryService.addParam(name="userID", cfsqltype="cf_sql_varchar", value="1");SaveContent variable="queryBody" {WriteOutput("SELECT userID,usename ");WriteOutput("FROM qUsers ");WriteOutput("WHERE userID = :userID ");}queryService.setSql(queryBody);try {test = queryService.execute();}writeDump(test);/*The code above will result in an errorError Executing Database Query.Query Of Queries runtime error.Table named qUsers was not found in memory. The name is misspelled or the table is not defined.*/</cfscript>
Result:
Error Executing Database Query.Query Of Queries runtime error.Table named qUsers was not found in memory. The name is misspelled or the table is not defined.
----------------------------- Additional Watson Details -----------------------------
Watson Bug ID: 3041855
External Customer Info:
External Company:
External Customer Name: Jorrit Janszen
External Customer Email: 26BE747A4456E3DB992016E5
External Test Config: 08/03/2010Attachments:
Comments: