queryExecute bug when using params immediately followed by a semicolon in sql text| View in Tracker
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.
- January 20, 2017 00:00:00: bug_queryexecute.cfm