Uploaded image for project: 'Railo'
  1. Railo
  2. RAILO-484

Wrong debugging output for CFQUERYs with misleading CFQUERYPARAM values

    Details

    • Type: Bug
    • Status: Resolved (View Workflow)
    • Priority: Minor
    • Resolution: Cannot Reproduce
    • Affects Version/s: 3.1
    • Fix Version/s: None
    • Environment:

      mac os x 10.5

    • Affects:
      Compatibility/Configuration

      Description

      Sometimes I can see that the debugging output for CFQUERYs is incorrect.

      An example (arguments.securitycontext.userid = 8):

      AND /* the value is #arguments.securitycontext.userid# */ rating.userid = <cfqueryparam cfsqltype="cf_sql_integer" value="#arguments.securitycontext.userid#">

      becomes

      AND /* the value is 8 */ rating.userid = 166)

      166 = value of the next CFQUERYPARAM

      By turing on the mysql log I can see that the right value (8) is submitted to the mysql server, however

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                micstriit Michael Offner
                Reporter:
                funkymusic Hansjoerg Posch
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: