tracker issue : CF-4118874

select a category, or use search below
(searches all categories and all time range)
Title:

cfquery crashes when there are tsql comments

| View in Tracker

Status/Resolution/Reason: Closed/Withdrawn/Duplicate

Reporter/Name(from Bugbase): James Mohler / James Mohler (James Mohler)

Created: 02/17/2016

Components: Database

Versions: 2016

Failure Type: Crash

Found In Build/Fixed In Build: CF2016_Final /

Priority/Frequency: Critical / All users will encounter

Locale/System: English / Windows 7 SP1 64-bit

Vote Count: 4

Duplicate ID:	CF-4126398

Problem Description: When there are tsql comments in the middle of query, the query will crash

Steps to Reproduce: 

<cfquery name="result">
SELECT * -- This is a comment
FROM myTable
</cfquery>


Actual Result:

ErrorCode: 102

Expected Result:

Some rows of data


Any Workarounds:

Remove SQL Comments

----------------------------- Additional Watson Details -----------------------------

Watson Bug ID:	4118874

External Customer Info:
External Company:  
External Customer Name: James Mohler
External Customer Email:  
External Test Config: My Hardware and Environment details:



Developer version of ColdFusion 2016

Attachments:

  1. February 18, 2016 00:00:00: 1_ZTU9c.png

Comments:

See: http://stackoverflow.com/questions/35446160/cfquery-crashes-when-there-are-tsql-comments for more details
Comment by External U.
4727 | February 17, 2016 05:00:45 PM GMT
We have numerous cfqueries with sql comments
Vote by External U.
4728 | March 01, 2016 03:10:34 PM GMT
We're experiencing the same issue and will require substantial code updates to remove our SQL comments. Please fix.
Vote by External U.
4729 | March 01, 2016 03:46:48 PM GMT
Yep, I'm having the same problem.
Vote by External U.
4730 | April 05, 2016 03:29:05 PM GMT
I have the same problem too. I am running Microsoft SQL Server 2012 - 11.0.5343.0 (X64) (Build 7601: Service Pack 1) on Windows 7 SP1 64-bit.
Vote by External U.
4731 | May 05, 2016 01:40:16 AM GMT