I'm good.. I just need help understanding how to do dates in MSAccess...
<!--- <cfquery datasource="#Request.AppGlobal.ds#"> --->
<cfoutput>
INSERT INTO time_taken
(
time_off_id,
employee_id,
date_taken,
notes,
<cfif form.auto_approve>
approvedon,
approvedby,
</cfif>
actionuser,
actiondate,
year
)
VALUES
(
'#form.time_off_id#',
'#form.employee_id#',
#dateformat(foodate,'mm/dd/yyyy')#,
'#form.notes#',
<cfif form.auto_approve>
now(),
'#session.user.employee_id#',
</cfif>
'#session.user.employee_id#',
now(),
#year(foodate)#
)
<br /></cfoutput>
<!--- </cfquery> --->
INSERT INTO time_taken ( time_off_id, employee_id, date_taken, notes,
actionuser, actiondate, year ) VALUES ( 'VV', 'e0012345', 11/11/2011, '',
'e0012345', now(), 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 : 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',
11/11/2011, '', 'e0018207', now(), 2011 ) DATASOURCE blurrrrrred_text
VENDORERRORCODE 3092 SQLSTATE Resources:
- Check the ColdFusion docume<http://www.macromedia.com/go/proddoc_getdoc>
For the love of whatever is up there.. please help if you can.. I tried
removing every <cfqueryparam and STILL a freaking error.. but I can
manually add the date with the query that is generated.
On Fri, Nov 11, 2011 at 11:21 AM, Russ Michaels <[email protected]> wrote:
>
> got a url so we can take a look ?
>
>
> On Fri, Nov 11, 2011 at 5:10 PM, Rick Faircloth
> <[email protected]> wrote:
> >
> > What about setting up some alerts with your AJAX variables
> > or using console.log in firebug for the variables to make sure they are
> > all what your are expecting?
> >
> > I find I have to use multiple techniques to debug apps before
> > tracking down a problem.
> >
> > hth,
> >
> > Rick
> >
> > -----Original Message-----
> > From: Greg Morphis [mailto:[email protected]]
> > Sent: Friday, November 11, 2011 11:01 AM
> > To: cf-talk
> > Subject: Re: cfajax error
> >
> >
> > Hmm the only error Firebug shows is the same oForm.auto_approve is
> > indefined..
> > it shows a POST to the ajaxfunctions.cfc and it's OK
> > I looked at the response and I see what looks like what you'd see with CF
> > debugging turned on, I see the query buried in the response and that
> looks
> > okay.. Maybe I'm doing something wrong in Firebug though, I haven't used
> it
> > much.
> >
> > On Fri, Nov 11, 2011 at 9:01 AM, Dave Watts <[email protected]> wrote:
> >
> >>
> >> > I was tasked in moving an old app on a CF8 server to a CF7 server. The
> >> app
> >> > has some cfajax code that I'm not familiar with. I'm hoping someone
> here
> >> > has seen the error..
> >>
> >> If it's actually making an AJAX call, use something like Firebug to
> >> view the returned value, and you might see your error immediately. My
> >> guess is that the function is returning invalid data of some sort,
> >> which is why it's running successfully but the code that calls the
> >> function is failing.
> >>
> >> 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:348654
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
