Uploaded image for project: 'Forms'
  1. Forms
  2. FORMS-316

Wrong generated SQL query

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Unresolved
    • Icon: Major Major
    • 2.20.0
    • 2.0.0, 2.1.0
    • None
    • None
    • 4.1RC1

      With demo data, when I open the FormsTool, click on "Formulaire de contact" and then "See SQL query", the generated query is :

      SELECT id as Id, creationDate as 'null', Ametys_Gen_1 as 'Saisissez votre nom', Ametys_Gen_2 as 'Adresse e-mail', Ametys_Gen_3 as 'Objet du message', Ametys_Gen_4 as 'Saisissez votre message'
      FROM Forms_form_05203847671908659;
      

      It does not work. It should be " instead of '
      It should be in the helper for datasources (to be centralized)

      What's more, creationDate as 'null' is invalid

            Unassigned Unassigned
            sprieul Simon Prieul (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated: