Ali - Are there primary keys defined in your database table and are they columns in the grid? I was having the same problem and it was because the data was not structured correctly and there was no primary key defined. I added my own primary key and the grid update worked.
Melissa Ali Daniali wrote: > Folks I've just had my first need to use the CFGRID/CFGRIDUPDATE duo but > keep hitting a road block.... > > <!-- updateQVF.cfm - builds the grid -- no problems here --> > > <cfquery name="Recordset1" datasource="dbTL_MSSQL2k_colo"> > SELECT tblQVF_FieldName, tblQVF_Value, tblQVF_Description FROM > dbo.tblQVF WHERE > tblQVF_CustomerID = 'alidaniali' > </cfquery> > > <html> > <head> > <title>Untitled Document</title> > <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> > </head> > > <body> > <cfform action="CFGRID_Action.cfm" > method="post" > name="GridForm"> > > <H3>QVF Data</H3> > > <CFGRID name="grid" query="Recordset1" selectmode="EDIT" width="700" > height="1600"> > > <cfgridcolumn name="tblQVF_FieldName"> > <cfgridcolumn name="tblQVF_Value"> > <cfgridcolumn name="tblQVF_Description"> > > </CFGRID> > > <p><input type="submit" value="save"></p> > > </cfform> > </body> > </html> > > <!-- CFGRID_Action.cfm - updates the DB -- problems here --> > > <cfgridupdate datasource="dbTL_MSSQL2k_colo" > tablename="dbo.tblQVF" > grid = "grid"> > Updated! > > <!-- Error Message --> > > Error Variable Value > Browser Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0) > Date/Time 12/05/02;02:04:14 P > Diagnostics cfgridupdate could not find the grid named grid. > The error occurred on line 3. > > I've done some research on this issue (Macromedia ColdFusion Forums, > CF-Talk, Expert Exchange, Google) but have had zero luck in getting it > resolved. Other folks have identified this error before but NO one has a > work around. > > <!-- System Stats --> > Win2k Server > MSSQL2k > CFMX w/o updater > > Any help would be appreciated. Thank you. > -Ali Daniali > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
