Here's the form code in my updateform.cfm file. > ><cfquery name="GetEventtoUpdate" datasource="Events"> >SELECT > Events.Title, > Events.InterDesc
Here's the actual input code in my form for the title: <tr> <td width="100">Event Title:</td> <td><input type="text" name="Title" value="#GetEventtoUpdate.Title#" size="67" maxlength="255"> </td> </tr> Here's code in my updateaction.cfm file: > ><cfquery name="UpdateEvent" datasource="Events"> >UPDATE Events, Dates, times, Internet, Intranet, PPrint >SET > Events.Title = '#form.title#', > Events.InterDesc = '#form.InterDesc# > > ----- 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. > > > > > > > ______________________________________________________________________ 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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
