Well Judy it is just saying that it cannot find the form field. This means that when you hit update, it is not passing the title variable to the next page. You may have to put the title in a hidden field.
"Success is a journey, not a destination!!" Doug Brown ----- Original Message ----- From: "Judy" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, April 18, 2002 9:23 AM Subject: update error > When I edit data in a form and click update, I get an error and cannot see why I'm getting it. The field name is spelled correctly as it is in the database. > > Error Diagnostic Information > > An error occurred while evaluating the expression: > > > #form.title# > > > > Error near line 7, column 19. > ------------------------------------------------------------------------------ -- > > Error resolving parameter FORM.TITLE > > > The specified form field cannot be found. This problem is very likely due to the fact that you have misspelled the form field name. > > > > The error occurred while processing an element with a general identifier of (#form.title#), occupying document position (7:18) to (7:29). > > > > Here's my code for that form field in my action file: > > <cfquery name="UpdateEvent" datasource="Events"> > UPDATE Events, Dates, times, Internet, Intranet, PPrint > SET > Events.Title = '#form.title#', > Events.InterDesc = '#form.InterDesc# > > Here's the corresponding code in my update file. > > <cfquery name="GetEventtoUpdate" datasource="Events"> > SELECT > Events.Title, > Events.InterDesc > > > > Please help. > > > ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
