Re: cfajax error
> the problem only reared it'sugly head with Access with Unicode.. Oh the joys of driver differences.. not to mention that uninformative error message. (It may as well have just said "oops"). Anyway, glad to hear it is fixed. -Leig ~| 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:348754 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfajax error
Leigh, you were right! That's what it was but the problem only reared it's ugly head with Access with Unicode.. Since I can't reinstall CF on our prod box your solution saved me from having to replicate the DB in Oracle and then alter the queries to match. This app may not even be used much more so unless I absolutely had to, I didn't want to rewrite it. I appreciate it! On Sat, Nov 12, 2011 at 9:59 AM, <> wrote: > > >>line 53* > > Do not take the line number as a hint. > When there is an error in a query, the error is returned by the driver and > CF doesn't know which line caused the error. > It will indicate any line in the query. > > ~| 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:348699 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfajax error
>>line 53* Do not take the line number as a hint. When there is an error in a query, the error is returned by the driver and CF doesn't know which line caused the error. It will indicate any line in the query. ~| 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:348694 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: cfajax error
Yes... seems those reserved words were a problem to always watch out for in Access. -Original Message- From: Leigh [mailto:cfsearch...@yahoo.com] Sent: Friday, November 11, 2011 9:11 PM To: cf-talk Subject: Re: cfajax error Rick - The odbc date format should be fine. I am pretty sure the column named "Year" is the problem. It is a reserved word. -Leigh ~| 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:348690 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfajax error
Rick - The odbc date format should be fine. I am pretty sure the column named "Year" is the problem. It is a reserved word. -Leigh ~| 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:348689 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: cfajax error
Seems like, many years ago when I worked with Access, I had to use something like #dateFormat(parseDateTime(myDate), 'mmm d, ')# or maybe just #dateFormat(parseDate(myDate), 'mmm d, ')# to get Access to accept even properly formatted dates. I can't find any of the old code just now, but maybe this will help. I'll see if I have any old code in a site or perhaps some test code that I used before. I feel certain that the parsing was part of what made it work. Sorry I can't be more specific! hth, Rick -Original Message- From: Steve Milburn [mailto:scmilb...@gmail.com] Sent: Friday, November 11, 2011 1:57 PM To: cf-talk Subject: Re: cfajax error Have you tried to quote the last item in the values list (the year)? Depending on how that is defined in the database, it may require quotes. Instead of: #year(foodate)# Try: '#year(foodate)#' HTH Steve On Fri, Nov 11, 2011 at 1:22 PM, Greg Morphis wrote: > > 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_s ave.cfm: > line 53* > > 51 : > '#session.user.employee_id#', > 52 : > #createodbcdate(now())#, > *53 : #year(foodate)#* > 54 :) > 55 : > > -- > SQLINSERT 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 > blurred_text > On Fri, Nov 11, 2011 at 12:13 PM, Greg Morphis wrote: > ~| 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:348688 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfajax error
you can use the ODBC socket option instead, if you google then you should be able to find some examples. However I think the easiest and best solution would be to use the Access Upside wizard to convert to SQL Server, Microsoft also provide some free migration and upgrade tools to do the job as well. http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=26709 On Fri, Nov 11, 2011 at 6:59 PM, Greg Morphis wrote: > > So apparently the problem is within the Microsoft Access with Unicode > driver.. > However we don't have the ODBC service installed on production. > I googled manually installing it and it mentioned some SequeLink folder in > the db directory.. > There's no DB folder or a SequeLink folder.. > How can I download these files and set up this service? > > > > > On Fri, Nov 11, 2011 at 12:25 PM, Dave Watts wrote: > >> >> > No, date_taken is 11/11/2011 >> >> Sorry, I didn't even see the first item in the VALUES list. >> >> 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:348681 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfajax error
So apparently the problem is within the Microsoft Access with Unicode driver.. However we don't have the ODBC service installed on production. I googled manually installing it and it mentioned some SequeLink folder in the db directory.. There's no DB folder or a SequeLink folder.. How can I download these files and set up this service? On Fri, Nov 11, 2011 at 12:25 PM, Dave Watts wrote: > > > No, date_taken is 11/11/2011 > > Sorry, I didn't even see the first item in the VALUES list. > > 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:348668 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfajax error
Have you tried to quote the last item in the values list (the year)? Depending on how that is defined in the database, it may require quotes. Instead of: #year(foodate)# Try: '#year(foodate)#' HTH Steve On Fri, Nov 11, 2011 at 1:22 PM, Greg Morphis wrote: > > 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 : > > -- > SQLINSERT 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 > blurred_text > On Fri, Nov 11, 2011 at 12:13 PM, Greg Morphis wrote: > ~| 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:348666 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfajax error
> No, date_taken is 11/11/2011 Sorry, I didn't even see the first item in the VALUES list. 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:348661 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfajax error
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 : -- SQLINSERT 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 blurred_text On Fri, Nov 11, 2011 at 12:13 PM, Greg Morphis 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 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
Re: cfajax error
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 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:348659 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfajax error
> 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:348658 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfajax error
>>dateformat(foodate,'mm/dd/') Here is your problem: use CeateODBCDateFormat instead: #CeateODBCDateFormat(foodate)# Also #CeateODBCDateFormat(now())# Furthermore, this will work provided foodate always contains a valid date. If it is empty, it will cause an error. In this case, you have to check if foodate is a date, return CreateODBCDate if yes, and null if not. ~| 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:348657 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfajax error
And time_taken looks like this time_off_id Text employee_id Text date_takenDate/Time notes Text approvedon Date/Time approvedby Text actionuserText actiondate Date/Time year Number On Fri, Nov 11, 2011 at 11:52 AM, Greg Morphis wrote: > I'm good.. I just need help understanding how to do dates in MSAccess... > > > > > INSERT INTO time_taken > ( > time_off_id, > employee_id, > date_taken, > notes, > > approvedon, > approvedby, > > actionuser, > actiondate, > year > ) > VALUES > ( > '#form.time_off_id#', > '#form.employee_id#', > #dateformat(foodate,'mm/dd/')#, > '#form.notes#', > > now(), > '#session.user.employee_id#', > > '#session.user.employee_id#', > now(), > #year(foodate)# > ) > > > > 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 : > > -- > SQLINSERT INTO time_taken ( time_off_id, employee_id, date_taken, > notes, actionuser, actiondate, year ) VALUES ( 'VV', 'e0012345', > 11/11/2011, '', 'e0018207', now(), 2011 ) DATASOURCE blurred_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 manually add the date with the query that is generated. > > > > > On Fri, Nov 11, 2011 at 11:21 AM, Russ Michaels wrote: > >> >> got a url so we can take a look ? >> >> >> On Fri, Nov 11, 2011 at 5:10 PM, Rick Faircloth >> 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 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
Re: cfajax error
I'm good.. I just need help understanding how to do dates in MSAccess... INSERT INTO time_taken ( time_off_id, employee_id, date_taken, notes, approvedon, approvedby, actionuser, actiondate, year ) VALUES ( '#form.time_off_id#', '#form.employee_id#', #dateformat(foodate,'mm/dd/')#, '#form.notes#', now(), '#session.user.employee_id#', '#session.user.employee_id#', now(), #year(foodate)# ) 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 : -- SQLINSERT INTO time_taken ( time_off_id, employee_id, date_taken, notes, actionuser, actiondate, year ) VALUES ( 'VV', 'e0012345', 11/11/2011, '', 'e0018207', now(), 2011 ) DATASOURCE blurred_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 wrote: > > got a url so we can take a look ? > > > On Fri, Nov 11, 2011 at 5:10 PM, Rick Faircloth > 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 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
Re: cfajax error
got a url so we can take a look ? On Fri, Nov 11, 2011 at 5:10 PM, Rick Faircloth 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 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:348652 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: cfajax error
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 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:348651 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfajax error
I did that, and even have the reverse on the pages where I want to see the debugging.. but all I get is "Syntax error in INSERT INTO statement".. I hate Access! On Fri, Nov 11, 2011 at 10:41 AM, Russ Michaels wrote: > > put a cfsetting tag at the top of your ajax pages to override debug > out to NO, this will allow you to have debugging enabled on the server > without breaking your ajax calls. > -- > > Russ Michaels > > www.bluethunderinternet.com : Business hosting services & solutions > www.cfmldeveloper.com: ColdFusion developer community > www.michaels.me.uk : my blog > www.cfsearch.com : ColdFusion search engine > > sky > > ~| 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:348649 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfajax error
put a cfsetting tag at the top of your ajax pages to override debug out to NO, this will allow you to have debugging enabled on the server without breaking your ajax calls. -- Russ Michaels www.bluethunderinternet.com : Business hosting services & solutions www.cfmldeveloper.com : ColdFusion developer community www.michaels.me.uk : my blog www.cfsearch.com : ColdFusion search engine sky ~| 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:348647 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfajax error
Ahh... I thought there might be some setting in the cfadmin to change that.. Cool, now I'm getting the same error as on production.. now to start looking through logs.. thanks! On Fri, Nov 11, 2011 at 10:27 AM, Dave Watts wrote: > > > Now, is there a way to turn off debugging for ajax response but leaving > it > > on for other things? > > Sure, you can do this on a per-page basis with CFSETTING. > > 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:348646 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfajax error
>>Hmm the only error Firebug shows is the same oForm.auto_approve is indefined.. The problem with Ajax is when there is an error in the template called by the function. This causes an error in the application because it cannot find what is expected in the text returned by the template. Instead, the CF error output is returned. What you need to see is the error displayed by the CF server, not the error that this display caused. The solution is to debug the template by simulating the Ajax call and calling it directly by hand. ~| 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:348645 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfajax error
> Now, is there a way to turn off debugging for ajax response but leaving it > on for other things? Sure, you can do this on a per-page basis with CFSETTING. 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:348644 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfajax error
That would explain why it worked in Prod and gave a different error too.. holy crap, it's making sense.. Now, is there a way to turn off debugging for ajax response but leaving it on for other things? On Fri, Nov 11, 2011 at 10:12 AM, Dave Watts wrote: > > > 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. > > That's probably the problem right there. If you have CF's server-side > debugging enabled for AJAX responses, that'll cause the client-side > parser not to be able to read them properly. > > 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:348643 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfajax error
> 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. That's probably the problem right there. If you have CF's server-side debugging enabled for AJAX responses, that'll cause the client-side parser not to be able to read them properly. 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:348642 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
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 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:348641 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfajax error
> 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:348640 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm