Title:
Bug 79761:Using DirectoryList with a return of query script based query does not reconize the the query returned from DirectoryList as a query
| View in TrackerStatus/Resolution/Reason: Closed/Withdrawn/
Reporter/Name(from Bugbase): Dave Ferguson / Dave Ferguson (dave_jf)
Created: 09/04/2009
Components: Database, Query-of-Query(IMQ)
Versions: 9.0
Failure Type: Unspecified
Found In Build/Fixed In Build: 247238 /
Priority/Frequency: Normal / Unknown
Locale/System: English / Win All
Vote Count: 0
Problem:
Using DirectoryList with a return of query script based query does not reconize the the query returned from DirectoryList as a query.
Method:
<cfscript>myDir = DirectoryList('ram://', false, 'query');myQry = new Query(dbtype="QUERY", sql="select * from myDir").execute();writedump(myQry);</cfscript>
Result:
Error Executing Database Query.Query Of Queries runtime error.Table named myDir was not found in memory. The name is misspelled or the table is not defined. The error occurred in D:\ColdFusion9\CustomTags\com\adobe\coldfusion\base.cfc: line 364Called from D:\ColdFusion9\CustomTags\com\adobe\coldfusion\query.cfc: line 613Called from D:\ColdFusion9\wwwroot\RamManager\temp\test.cfm: line 7Called from D:\ColdFusion9\CustomTags\com\adobe\coldfusion\base.cfc: line 364Called from D:\ColdFusion9\CustomTags\com\adobe\coldfusion\query.cfc: line 613Called from D:\ColdFusion9\wwwroot\RamManager\temp\test.cfm: line 7362 : #getPreserveSingleQuotes(sqlArray[1])#363 : <cfif sqlType neq "" and arraylen(sqlParams) gt 0>364 : <cfloop index="i" from="2" to="#ArrayLen(sqlArray)#">365 : <cfif (i-1) lte arraylen(sqlParams)>366 : <cfqueryparam attributeCollection="#sqlParams[i-1]#"/>
----------------------------- Additional Watson Details -----------------------------
Watson Bug ID: 3039910
External Customer Info:
External Company:
External Customer Name: Dave Ferguson
External Customer Email: 333762A94460DE1A992015D5
External Test Config: 09/04/2009Attachments:
Comments: