Same error.. WTH?
foodate is today.. 11/11/2011
Error Executing Database Query. Syntax error in INSERT INTO statement. The
error occurred in
*C:\JRun4\servers\cfusion\cfusion-ear\cfusion-war\Production\TWST\time_off_save.cfm:
line 53*
51 :
'#session.user.employee_id#',
52 : #createodbcdate(now())#,
*53 : #year(foodate)#*
54 : )
55 : </cfquery>
------------------------------
SQL INSERT INTO time_taken ( time_off_id, employee_id, date_taken,
notes, actionuser, actiondate, year ) VALUES ( 'VV', 'e0012345', {d
'2011-11-11'}, '', 'e0012345', {d '2011-11-11'}, 2011 ) DATASOURCE
blurrrrrred_text
On Fri, Nov 11, 2011 at 12:13 PM, Greg Morphis <gmorp...@gmail.com> wrote:
> No, date_taken is 11/11/2011
>
> I'll try the createodbcdateformat()..
> I've never had to use that with Oracle so it's something else to try
>
>
> On Fri, Nov 11, 2011 at 12:11 PM, Dave Watts <dwa...@figleaf.com> wrote:
>
>>
>> > INSERT INTO time_taken ( time_off_id, employee_id, date_taken, notes,
>> > actionuser, actiondate, year ) VALUES ( 'VV', 'e0012345', 11/11/2011,
>> '',
>> > 'e0012345', now(), 2011 )
>>
>> The field date_taken is a Date/Time field, right? You're inserting an
>> empty string, not a Date/Time value.
>>
>> Dave Watts, CTO, Fig Leaf Software
>> http://www.figleaf.com/
>> http://training.figleaf.com/
>>
>> Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on
>> GSA Schedule, and provides the highest caliber vendor-authorized
>> instruction at our training centers, online, or onsite.
>>
>>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348660
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
