And time_taken looks like this time_off_id Text employee_id Text date_taken Date/Time notes Text approvedon Date/Time approvedby Text actionuser Text actiondate Date/Time year Number
On Fri, Nov 11, 2011 at 11:52 AM, Greg Morphis <gmorp...@gmail.com> wrote: > 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 <r...@michaels.me.uk>wrote: > >> >> got a url so we can take a look ? >> >> >> On Fri, Nov 11, 2011 at 5:10 PM, Rick Faircloth >> <r...@whitestonemedia.com> 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:gmorp...@gmail.com] >> > 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 <dwa...@figleaf.com> 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:348655 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
