3 Replies Latest reply on Mar 4, 2008 9:44 AM by (Cheryl_James)

    Create Dynamic Form Wizard

    Level 1
      I used this last week on several pages without any problems. Today, I created a new page and used this wizard and now I'm getting major errors.

      Here is what it's telling me. Looks like a Developer Toolbox breakdown?

      Error:
      Internal error.
      Developer Details:
      tNG_multiple.getFakeRecordset
      SQL error: Error creating temporary table:
      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 'show TEXT, location TEXT, calendarID TEXT, kt_pk_calendar TEXT)' at line 1
      SQL:
      CREATE TEMPORARY TABLE KT_fakeRS_20080303 (month TEXT, date TEXT, year TEXT, show TEXT, location TEXT, calendarID TEXT, kt_pk_calendar TEXT). (MULTIPLE_FAKE_RS_ERROR)
      tNG Execution Trace - VIEW