0 Replies Latest reply on Aug 6, 2008 1:12 PM by MiMiB


      I was using a server that had ColdFusion 5 and using cfgrid and cfgridupdate and my programs worked fine. I went to a server that has ColdFusion MX7 and I can bring up a grid with my data but when I try to update the grid via cfgridupdate I get the following error: Error Executing Database Query.
      Syntax error in UPDATE statement.

      The error occurred in C:\Inetpub\wwwroot\..\handle_grid3Range.cfm: line 9

      7 :
      8 : <body>
      9 : <cfgridupdate grid="testingweb_grid"
      10 : datasource="CARs"
      11 : tablename="testing_web">

      I'm attaching my code, hope someone can help.