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.
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Upgrade to Adobe ColdFusion MX7
The most significant release in over 10 years. Upgrade & see new features.
http://www.adobe.com/products/coldfusion?sdid=RVJR
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275796
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
