Re: ajax cfc not working for Access DB -- odd stuff
>If the cfc is being hit, and with the right data, you can absolutely rule >out the cfajaxproxy tag. Can we clarify that the data being returned from >the method is the problem? Try posting a form directly to the cfc method, >e.g. > > > > > >From there, debugging should be more straight forward. > >Dominic Forgot, I could simply use pathtocfc.cfc?method=fubar¶m1=727¶m2='blablaText' from URL to test it and did, it only returned these structures but action outcome. But I've spent over 1.4 hours on it, there's another option, opted out... thanks though. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325575 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: ajax cfc not working for Access DB -- odd stuff
On Wed, Aug 19, 2009 at 7:13 PM, Don L wrote: > > Sorry, Dominic, I wasn't clear about the browser, the inline editing feature > is IE specific, that is, Firefox has a hell time with it, hence, it's IE > only, yes, I like Firefox's firebug and find it very helpful but not for this > case. I have firebug lite set up for the IE7, but it didn't show http call > etc. from cfajaxproxy as in FF/FB... more thoughts? thanks. use a different inline editor =) Otherwise for something a little more helpful, download and install Fiddler for Internet Explorer. http://www.fiddler2.com/fiddler2/ Enable it, then hit your application. You'll see the ajax call show up in fiddler.. you can then see the raw response from your cfc using the session inspector.. -- Rick Root New Brian Vander Ark Album, songs in the music player and cool behind the scenes video at www.myspace.com/brianvanderar ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325564 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: ajax cfc not working for Access DB -- odd stuff
If the cfc is being hit, and with the right data, you can absolutely rule out the cfajaxproxy tag. Can we clarify that the data being returned from the method is the problem? Try posting a form directly to the cfc method, e.g. >From there, debugging should be more straight forward. Dominic 2009/8/20 Don L > > >> I've moved on to an open source cfml engine > >Don't ever do that. > > > >But seriously. First step of debugging ajax: install Firebug for Firefox > if > >you haven't already. Next, enable all the firebug console options for your > >page and while viewing the console tab you should see your http post > request > >made by your proxy js object (when you fire that event). You will then be > >able to examine the the data sent to your cfc and also the response. > > > >If there is no http request sent then the problem may well be with the > >cfajaxproxy code - if a request *is* sent, then we can safely move on from > >the client side code. > > > >With any luck, examining the http response will tell you exactly what's > >going wrong and will be a cf / railo error page. > > > >HTH > > > >Dominic > > Very ODD. > > The line of in the cfc should have been > since we don't need data back from the cfc. > > and was previously . I've enabled the feature in FF. > > case A, > ajax http post succeeds, RESPONSE: the {data} instead of TRUE ? > > case B, in the cfc, > > (just for the heck of it), > ajax http post succeeds, RESPONSE: just the #mf# instead of fielda, #fa#; > fieldb, #fb#; memofield,#mf# ? > > > FYI, the computer is totally offline and wireless device driver was turned > off as well. > > > > ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325560 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: ajax cfc not working for Access DB -- odd stuff
Of course ;) 2009/8/20 Emmit Larson > 't ever do that. > Shirley, you jest? > > Kind Regards, > Emmit ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325559 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: ajax cfc not working for Access DB -- odd stuff
After looking at this code I am suddenly hungry for pound cake... dunno why??? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325558 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: ajax cfc not working for Access DB -- odd stuff
>> I've moved on to an open source cfml engine >Don't ever do that. > >But seriously. First step of debugging ajax: install Firebug for Firefox if >you haven't already. Next, enable all the firebug console options for your >page and while viewing the console tab you should see your http post request >made by your proxy js object (when you fire that event). You will then be >able to examine the the data sent to your cfc and also the response. > >If there is no http request sent then the problem may well be with the >cfajaxproxy code - if a request *is* sent, then we can safely move on from >the client side code. > >With any luck, examining the http response will tell you exactly what's >going wrong and will be a cf / railo error page. > >HTH > >Dominic Very ODD. The line of in the cfc should have been since we don't need data back from the cfc. and was previously . I've enabled the feature in FF. case A, ajax http post succeeds, RESPONSE: the {data} instead of TRUE ? case B, in the cfc, (just for the heck of it), ajax http post succeeds, RESPONSE: just the #mf# instead of fielda, #fa#; fieldb, #fb#; memofield,#mf# ? FYI, the computer is totally offline and wireless device driver was turned off as well. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325556 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: ajax cfc not working for Access DB -- odd stuff
> > I've moved on to an open source cfml engine > Don't ever do that. Shirley, you jest? Kind Regards, Emmit On Wed, Aug 19, 2009 at 6:29 PM, Dominic Watson < watson.domi...@googlemail.com> wrote: > > > I've moved on to an open source cfml engine > Don't ever do that. > > But seriously. First step of debugging ajax: install Firebug for Firefox if > you haven't already. Next, enable all the firebug console options for your > page and while viewing the console tab you should see your http post > request > made by your proxy js object (when you fire that event). You will then be > able to examine the the data sent to your cfc and also the response. > > If there is no http request sent then the problem may well be with the > cfajaxproxy code - if a request *is* sent, then we can safely move on from > the client side code. > > With any luck, examining the http response will tell you exactly what's > going wrong and will be a cf / railo error page. > > HTH > > Dominic > > > ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:32 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: ajax cfc not working for Access DB -- odd stuff
>> I've moved on to an open source cfml engine >Don't ever do that. > >But seriously. First step of debugging ajax: install Firebug for Firefox if >you haven't already. Next, enable all the firebug console options for your >page and while viewing the console tab you should see your http post request >made by your proxy js object (when you fire that event). You will then be >able to examine the the data sent to your cfc and also the response. > >If there is no http request sent then the problem may well be with the >cfajaxproxy code - if a request *is* sent, then we can safely move on from >the client side code. > >With any luck, examining the http response will tell you exactly what's >going wrong and will be a cf / railo error page. > >HTH > >Dominic Sorry, Dominic, I wasn't clear about the browser, the inline editing feature is IE specific, that is, Firefox has a hell time with it, hence, it's IE only, yes, I like Firefox's firebug and find it very helpful but not for this case. I have firebug lite set up for the IE7, but it didn't show http call etc. from cfajaxproxy as in FF/FB... more thoughts? thanks. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325552 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: ajax cfc not working for Access DB -- odd stuff
> I've moved on to an open source cfml engine Don't ever do that. But seriously. First step of debugging ajax: install Firebug for Firefox if you haven't already. Next, enable all the firebug console options for your page and while viewing the console tab you should see your http post request made by your proxy js object (when you fire that event). You will then be able to examine the the data sent to your cfc and also the response. If there is no http request sent then the problem may well be with the cfajaxproxy code - if a request *is* sent, then we can safely move on from the client side code. With any luck, examining the http response will tell you exactly what's going wrong and will be a cf / railo error page. HTH Dominic ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325551 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: ajax cfc not working for Access DB -- odd stuff
Railo or OpenBD? Do they support cfajaxproxy yet? > -Original Message- > From: Don L [mailto:do...@yahoo.com] > Sent: 19 August 2009 22:42 > To: cf-talk > Subject: ajax cfc not working for Access DB -- odd stuff > > > I've moved on to an open source cfml engine, don't know what caused the > following odd behavior, that is, my cfajaxproxy tag no longer works for > an inline data editing function (meaning, it does not do database > update for a set of data) while the same code works for ms sql server > 2005 express (db syntax are exactly same for such a simple query) and > since I'm using "sync" mode I can't use the setCallbackHandler method > to do debugging. Thought, could use more heads here... > > caller line > > > cfc code and js code below, > > > > > > > > > > > > > > > > > > > > > > > > > > > > > update blablaTBL > set whats = '#fmwhats#' > where uaid = > cfsqltype="CF_SQL_INTEGER"> > and sid = "#Evaluate(someid)#" > > cfsqltype="CF_SQL_VARCHAR" >maxlength="128">; > > > > > > > > > > > > > // much credit goes to Sam Farmer for getting me started on this (JSON) > approach > function callUpdateJS2(frm,row) { > rowUpdate(frm,row); > } > > function handleResult(r) { >console.log(r); > } > > function rowUpdate(frm,row){ > // var d = new DraftObj(); > var d = new UpdateObj2(); > d.setSyncMode(true); > d.setForm(frm); > d.setHTTPMethod('POST'); > // d.doUpdate(); > > // expect d.doUpdate() to return "failed" or "success" string > // BUT it doesn't! > > // update {notes} field; 05/28/2008 > document.getElementById(row).innerHTML = d.doUpdate(); > } > > > Forgive me about the formatting and typo if any. > > Thanks. > > ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325550 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4