tracker issue : CF-4198278

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

queryExecute bug when using params immediately followed by a semicolon in sql text

| View in Tracker

Status/Resolution/Reason: Closed/Fixed/Fixed

Reporter/Name(from Bugbase): Thomas Harding / Thomas Harding ()

Created: 01/20/2017

Components: Database

Versions: 2016,11.0

Failure Type: Incorrectly functioning

Found In Build/Fixed In Build: 2016,0,03,300466 / 307345

Priority/Frequency: Normal / All users will encounter

Locale/System: UK English / Windows 10 64 bit

Vote Count: 1

Problem Description:
queryExecute throws when adding a semicolon directly after defining a query param. eg:
WHERE id = :id;

Produces the same error on CF2016u3 and CF11u10. Running against SQL Server 2008r2.

Steps to Reproduce:
Write a query with a query param defined in the sql argument text that is immediately followed by a semicolon

Actual Result:
Error Executing Database Query.
[Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ':'.

Expected Result:
query should run successfully

Any Workarounds:
Moving the semicolon to the next line solves the issue.


  1. January 20, 2017 00:00:00: bug_queryexecute.cfm