5 Replies Latest reply on Aug 22, 2006 1:49 PM by MongoSlade

    Clueless NEWBIE DEVELOPER, NEEDS ASSIST with Insert Record Server Behavior

      Experienced DW designer learning CFMX7. I cannot seem to get beyond this error message when using the Insert Record server behavior to write data from a form into the database. Using MS Access 2002, CFMX7's internal server, DW 6.0. Please note that I am learning development for the first time and am using tutorials. I was able to connect at one point but now I cannot.
      See error message below:

      The following information is meant for the website developer for debugging purposes.

      Error Occurred While Processing Request
      Error Executing Database Query.
      Syntax error in INSERT INTO statement.

      Enable Robust Exception Information to provide greater detail about the source of errors. In the Administrator, click Debugging & Logging > Debugging Settings, and select the Robust Exception Information option.
      Check the ColdFusion documentation to verify that you are using the correct syntax.
      Search the Knowledge Base to find a solution to your problem.

      Browser Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322)
      Remote Address
      Referrer http://localhost:8500/moosek/TMPu724j3nl2j.cfm
      Date/Time 07-Aug-06 07:23 PM

      Text Text