Uploaded image for project: 'Qt'
  1. Qt
  2. QTBUG-45915

Single qoutes prevent bindValue from replacing placeholder mark

    XMLWordPrintable

Details

    • Bug
    • Resolution: Invalid
    • Not Evaluated
    • None
    • 5.4.1
    • SQL Support
    • None
    • archlinux 3.19.3

    Description

      When I prepare a statement with bindValue the placeholder mark is not replaced if it is surrounded with singel qoutes. This is problematic since in SQL strings are surrounded by single quotes.

      See my attachements with screenies of the content of the database once inserted with and once without single qoutes.

      Solved The docs should mention that and why there are no quotes needed. The docs must mention that quotes will lead to an error.

      Attachments

        1. FOCUS015.png
          FOCUS015.png
          33 kB
        2. FOCUS16.png
          FOCUS16.png
          38 kB
        No reviews matched the request. Check your Options in the drop-down menu of this sections header.

        Activity

          People

            mabrand Mark Brand
            manuelschneid3r Manuel Schneider
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes