10 Replies Latest reply on Apr 28, 2008 3:33 PM by (Paul_B._Kelley)

    Contacts Management Tutorial -- MySQL error on last step!

    Level 1
      I just completed the contacts management tutorial and in the final exercise using the QuB I get the following error:

      "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY name_con' at line 1"

      This is interesting because you are instructed to remove the "ORDER BY name_con" from the SQL query (pg. 62) because, according to the author, "This step makes the query easier to view when you open MX Query Builder." Leaving the "ORDER BY name_con" produces the same result. Any ideas on why the error is generated? I was nearly done with my first ADDT tutorial and all had gone well up to this point!!!