Status/Resolution/Reason: Closed/Withdrawn/NotABug
Reporter/Name(from Bugbase): Frédéric Peters / Frédéric Peters (External User)
Created: 03/09/2016
Components: Language
Versions: 2016
Failure Type: Unspecified
Found In Build/Fixed In Build: Beta2_v12 /
Priority/Frequency: Trivial / Unknown
Locale/System: English / Win All
Vote Count: 0
Problem Description:
<cfquery datasource="#application.datasource#" name="query1" cachedwithin="#CreateTimeSpan(0, 0, 0, 0)#">
SELECT * , Products.titre,Products.CategoryID, Products.cptxt
FROM NewPhotos
INNER JOIN Products on Products.ItemID = NewPhotos.ItemID
where NewPhotos.ItemID = 224888
</cfquery>
==> #query1.recordcount# = 0
<cfquery datasource="#application.datasource#" name="query1" cachedwithin="#CreateTimeSpan(0, 0, 0, 0)#">
SELECT * , Products.titre,Products.CategoryID, Products.cptxt
FROM NewPhotos
INNER JOIN Products on Products.ItemID = NewPhotos.ItemID
where NewPhotos.ItemID = <cfqueryPARAM value = "224888" CFSQLType = "CF_SQL_INTEGER">
</cfquery>
==> #query1.recordcount# = 5
Steps to Reproduce:
very strange I copy paste the code in Navicat and get records.
When the code is in the <cfquery> tags without cfqueryparam it returns 0 rows.
But I have other records where everything works well...
Actual Result:
Expected Result:
Any Workarounds:
----------------------------- Additional Watson Details -----------------------------
Watson Bug ID: 4126422
External Customer Info:
External Company:
External Customer Name: Frédéric Peters
External Customer Email: frederic.peters@outlook.com
External Test Config: Friendly Name: Win2008R2 Apache 2.2.21
Device Type: Server
Manufacturer/Brand: Supermicro
Model: unknown
Memory (ROM): 4
Operating System (if known): Windows 2008 R2 64 bits
Bug File Paths:
\\sjshare.corp.adobe.com\Prereleasebugfiles\ColdFusion\12.0\Beta2_v12\4112097\test-bug-image.cfm
\\sjshare.corp.adobe.com\Prereleasebugfiles\ColdFusion\12.0\Beta2_v12\4112097\test-bug-image_1.cfmAttachments:
Comments: