Skip to main content
R
rpschwar27
Known Participant
May 19, 2016
Question

Coldfusion v2016 using SQL server query using order by right causes error.

  • May 19, 2016
  • 1 reply
  • 705 views

Have query that worked until v2016.  Using order by right(LogNumber,3) DESC get error:

Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'right'

query:

  SELECT LogNumber

  FROM tblMain

  WHERE (Program = 'Apple')

  ORDER BY right(LogNumber,3) DESC

    This topic has been closed for replies.

    1 reply

    Carl Von Stetten
    Carl Von Stetten
    Legend
    May 19, 2016

    Have you applied Update 1 yet?  If so, was this working before the update?

    I wonder if it is somehow related to this similar CF11 Update 8 bug: Bug#4153580 - Coldfusion 11 update 8 breaks left and right sql sever functions

    R
    rpschwar27Author
    Known Participant
    May 19, 2016

    I had already installed the Update1 so I uninstalled it and it still does not work.  I looked at the bug#4153580 and that appears to me my problem.  I have determined that if you have a right in the query it works, it's only if you have it in the order by that it doesn't work.

      WolfShade
      WolfShade
      Legend
      May 19, 2016

      Can you add another column to your select and order by on that?

        SELECT LogNumber, right(LogNumber,3) as rlog
        FROM tblMain
        WHERE (Program = 'Apple')
        ORDER BY rlog DESC

      HTH,

      ^_^

      Terms & ConditionsAccessibility statement
      Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices