No, they're not case sensitive, but make sure that your form is set to "post," as otherwise, you'll be passing variables in the url scope, instead of the desired form scope.
Look at your debug output and see if your form variables appear there. If you have your form set incorrectly, you should see your variables in the cgi.query_string instead. Jamie On Thu, 18 Apr 2002 13:03:24 -0400, in cf-talk you wrote: >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. >> > >> > >> > >> > ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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
