Status/Resolution/Reason: Closed/Fixed/
Reporter/Name(from Bugbase): Jojo Serquina / Jojo Serquina (Jojo Serquina)
Created: 06/20/2014
Components: Database
Versions: 11.0
Failure Type: Non Functioning
Found In Build/Fixed In Build: CF11_Final /
Priority/Frequency: Critical / All users will encounter
Locale/System: English / Windows 8.1/64bit
Vote Count: 1
Problem Description:
Steps to Reproduce:
<cfset myQuery = QueryNew('ID,Name,Address','Integer,VarChar,Varchar') />
<cfset QueryAddRow(myQuery,1) />
<cfset QuerySetCell(myQuery,'ID',1,1) />
<cfset QuerySetCell(myQuery,'Name','John Doe',1) />
<cfset QuerySetCell(myQuery,'Address','Street Named Doe',1) />
<cfquery name="qNew" dbtype="query">
SELECT * FROM myQuery WHERE ID = 1;
</cfquery>
<cfdump var="#qNew#">
Actual Result:
ID 818
type Database
message Error Executing Database Query.
detail <br><b>Query Of Queries runtime error.</b><br> The select column reference [1;] is not a column in any of the tables of the FROM table list.
Expected Result:
The query is executed and records are returned
Any Workarounds:
Unknown (remove the semicolon)?
----------------------------- Additional Watson Details -----------------------------
Watson Bug ID: 3779331
External Customer Info:
External Company:
External Customer Name: jojoserquina
External Customer Email:
External Test Config: My Hardware and Environment details:
Local
Windows 8.1
Attachments:
Comments: