Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

Query Params are not Resolved When Comment has Apostrophe

Description

When a cfquery has a comment with a single apostrophe, the params are not resolved correctly.

<cfquery> /* this comment's will break params */ some code that uses a :param </cfquery>

Environment

None

Activity

Show:

Zac Spitzer 14 April 2023 at 12:50

Timothy Lux 16 March 2023 at 17:40

I have the same issue and filed https://luceeserver.atlassian.net/browse/LDEV-4424 for it.

Pothys - MitrahSoft 13 February 2023 at 07:50

brett deline 24 October 2022 at 14:50

I also just ran into this problem writing a commandbox custom command that does reading of ad-hoc CSV files and attempt to insert into an MSSQL database. The version of lucee is 5.3.9.160 that my version of commandbox is using. Issue came up trying to run insert statements and the column headers had '?' characters in them:

 

insert into [myTable]([Name],[NAIC],[Address1],[Address2],[Address3],[City],[State],[ZipCode],[PhoneNumber],[Active?],

Jason Troy 21 October 2022 at 21:19

This just bit us (was working on 5.3.8.206) - and whatever versions we were on in the past couple years

  • 5.3.9.166-SNAPSHOT fails.

SQL Server with comment containing the question mark breaks

/* I think this is a comment ? */
Unresolved

Details

Assignee

Reporter

Priority

Labels

Fix versions

New Issue warning screen

Before you create a new Issue, please post to the mailing list first https://dev.lucee.org

Once the issue has been verified, one of the Lucee team will ask you to file an issue

Sprint

Created 11 March 2020 at 19:24
Updated 7 June 2024 at 08:34

Flag notifications