P.S. - looking at the debug information at the bottom of the page would show you this very clearly and quickly.
-----Original Message----- From: Judy [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 12:03 PM To: CF-Talk Subject: Re: update error Jamie, I just happened to think - are all these field names case sensitive when referring to them? If so, that could be my problem Judy ----- Original Message ----- From: "Jamie Jackson" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, April 18, 2002 12:38 PM Subject: Re: update error > Please post the pertinent form html. > > Jamie > > On Thu, 18 Apr 2002 12:23:22 -0400, in cf-talk you wrote: > > >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. > > > > > > > ______________________________________________________________________ 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