not necessarily... CF knows what the primary key of the table is and looks for it in the grid you pass. Just make sure that when you declare your grid you are declaring a grid column with the name of the primary key and display set to "no".
+-----------------------------------------------+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecomunication Systems [EMAIL PROTECTED] +-----------------------------------------------+ "...'If there must be trouble, let it be in my day, that my child may have peace'..." - Thomas Paine, The American Crisis -----Original Message----- From: Angel Stewart [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 13, 2001 2:38 PM To: CF-Talk Subject: RE: CFGRID Not updating No..that's not it. I made that change and It still does not update the database. Does this need to go hand in hand with the AppendKey in the CFGRID definition? Can I only change one field? For example on the Hlidays table there are two fields. Holiday Date and holiday description. If I change Holiday Date AND Holiday Description, it is changing the Date but not the Description. It's just...real weirdness going on! :( -Gel -----Original Message----- From: Bryan Love [mailto:[EMAIL PROTECTED]] I'll venture a gues... put this in your GRIDUPDATE tag: KEYONLY="Yes" +-----------------------------------------------+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecomunication Systems [EMAIL PROTECTED] +-----------------------------------------------+ "...'If there must be trouble, let it be in my day, that my child may have peace'..." - Thomas Paine, The American Crisis -----Original Message----- From: Angel Stewart [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 13, 2001 1:30 PM To: CF-Talk Subject: CFGRID Not updating And on with my CFGRID Saga. *sigh* Now I have the grids displaying, I have them formatted and lloking all pretty.. But now they are not updating any tables. Would you believe this utter rubbish!!?? I can't update or insert data into several tables. When I go to the action page, the values I enter into the CFGRID are not being displayed in the DEBUG form field section. It is most frustrating! Does anyone have any ideas? --------------------------------------- -Gel ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists