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

    Clueless NEWBIE DEVELOPER, NEEDS ASSIST with Insert Record Server Behavior

    MongoSlade
      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.


      Resources:
      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 127.0.0.1
      Referrer http://localhost:8500/moosek/TMPu724j3nl2j.cfm
      Date/Time 07-Aug-06 07:23 PM


      Text Text