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

cfscript new Query with two adjacent single quotes, after parsing, will result in whitespace between them.

    Details

    • Steps to Reproduce:
      Hide

      var a =new Query("select name from users where last_name = 'o''brian'");
      a.execute();

      Show
      var a =new Query("select name from users where last_name = 'o''brian'"); a.execute();
    • Workaround Description:
      Hide

      use parameters.

      Show
      use parameters.

      Description

      If you have a string literal with an escaped doubled-single quote in you sql when using the new Query() syntax, it will parse to a query that has whitespace between the escaped single quote, rendering it NOT an escaped single quote.

      It is really minor, since the obvious workaround (using parameters) fixes it very nicely. I though it would be good to fix it since it is in there.

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                igal-getrailo.org Igal .
                Reporter:
                clitnak Colby Litnak
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: