Title:
Bug 84119:(Watson Migration Closure)When executing an ORMExecuteQuery() on a mapped cfc (using the datasource attribute to specify a foreign DSN), you shouldn't need to re-specify the datasource (in the HQL query options)
| View in TrackerStatus/Resolution/Reason: To Fix//
Reporter/Name(from Bugbase): w boom / w boom (blarg_it)
Created: 09/10/2010
Components: ORM Support
Versions: 9.0.1
Failure Type: Unspecified
Found In Build/Fixed In Build: 0000 /
Priority/Frequency: Normal / Some users will encounter
Locale/System: English / Win All
Vote Count: 1
Problem:
When executing an ORMExecuteQuery() on a mapped cfc (using the datasource attribute to specify a foreign DSN), you shouldn't need to re-specify the datasource (in the HQL query options).Without specifying the HQL datasource, you will receive a "table is not mapped" error.
Method:
This errors:~~~
local.arrMembers = ORMExecuteQuery("select new map(MemID as mID, Firstname as fName, Surname as sName) from tblMem where MemID in (#local.notPlayedList#)",{},false);
~~~This works:~~~local.arrMembers = ORMExecuteQuery("select new map(MemID as mID, Firstname as fName, Surname as sName) from tblMem where MemID in (#local.notPlayedList#)",{},false,{datasource=variables.dgDSN});~~~The difference is the datasource HQL query option.
Result:
tblMem is not mapped [select new map(MemID as mID, Firstname as fName, Surname as sName) from tblMem where MemID in (0,6301190)]
----------------------------- Additional Watson Details -----------------------------
Watson Bug ID: 3042142
External Customer Info:
External Company:
External Customer Name: w boom
External Customer Email: 686F35DF4540EBCF992016B7
External Test Config: 09/10/2010Attachments:
Comments: