Do a cfdump your FORM and check your field list; see if it matches.
> -----Original Message----- > From: Steve LaBadie [mailto:[EMAIL PROTECTED] > Sent: Wednesday, April 18, 2007 4:43 PM > To: CF-Talk > Subject: RE: Not Sure What is Wrong > > Changed Date to Event_Date and now I get "Element EVENT_DATE is undefined > in FORM" > > INSERT INTO Events (Events, Event_Date) > VALUES ( > <cfif IsDefined("FORM.Events") AND #FORM.Event_Date# NEQ ""> > '#FORM.Events#', "#FORM.Event_Date#" > <cfelse> > > ________________________________ > > From: Wesley Middendorff [mailto:[EMAIL PROTECTED] > Sent: Wed 4/18/2007 7:37 PM > To: CF-Talk > Subject: Re: Not Sure What is Wrong > > > > Keyword date, didnt even dawn on me, but that is the more likely answer. > > On 4/18/07, Charlie Griefer <[EMAIL PROTECTED]> wrote: > > > > 1) Date is a reserved word. If you can't change it, enclose it in > > square brackets. > > 2) you have 2 columns specified (Events, Date) but in your <cfelse> > > condition you're only inserting a single value. You should have NULL, > > NULL. > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create Web Applications With ColdFusion MX7 & Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275799 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4