Charles Proxy and ColdFusion 9

Just wondering if anyone has had any luck with getting the SQLQuery information in response header with Charles Proxy after upgrading to ColdFusion 9.  It works correctly on ColdFusion 8, with the exact same debugging settings, but although the header comes shows up, it does not have any of the child objects in it.  I had thought that the JSON Serialization issue, that was fixed in ColdFusion 9.0.1 Hot Fix 2, would fix it...but alas, it did not. TIA Bill

Anyone even use Charles Proxy?

Firebug does most of it so no not anymore. > > Anyone even use Charles Proxy?

Are you able to see the SQL Query calls in firebug w/ CF9 as the back-end? Freundliche Grüße / Best regards, Bill Franklin Computer Integrated Mfg. Bayer CropScience LP 8400 Hawthorne Road, Room 2447 Kansas City, MO 64120 Tel: +1 816 242 2148 Fax: +1 816 242 2047 E-mail: bill.franklin@bayer.com Web: http://www.bayercropscience.com Vorstand: Sandra E. Peterson, Vorsitzende   |  Lykele van der Broek, Achim Noack, Rüdiger Scheitza, Michael A. Schulz Vorsitzender des Aufsichtsrats: Werner Baumann Sitz der Gesellschaft: Monheim am Rhein   |   Eintragung: Amtsgericht Düsseldorf, HRB 46985 Firebug does most of it so no not anymore. > > Anyone even use Charles Proxy? > >

No you wou;dn't be able to see that unless it was local dev and had firebug detector installed. ----- Excess quoted text cut - see Original Post for more -----

Hence the use of Charles Proxy, which, up until ColdFusion 9, allowed us to see the SQL Queries that were run inside the CFC calls... Freundliche Grüße / Best regards, Bill Franklin Computer Integrated Mfg. Bayer CropScience LP 8400 Hawthorne Road, Room 2447 Kansas City, MO 64120 Tel: +1 816 242 2148 Fax: +1 816 242 2047 E-mail: bill.franklin@bayer.com Web: http://www.bayercropscience.com Vorstand: Sandra E. Peterson, Vorsitzende   |  Lykele van der Broek, Achim Noack, Rüdiger Scheitza, Michael A. Schulz Vorsitzender des Aufsichtsrats: Werner Baumann Sitz der Gesellschaft: Monheim am Rhein   |   Eintragung: Amtsgericht Düsseldorf, HRB 46985 No you wou;dn't be able to see that unless it was local dev and had firebug detector installed. ----- Excess quoted text cut - see Original Post for more -----

> Hence the use of Charles Proxy, which, up until ColdFusion 9, allowed us to see the SQL Queries that were run inside the CFC calls... I've used Charles before, but since it's an HTTP proxy, I don't see how it would let you see the actual SQL queries being run unless the CFC were outputting that information in some way. If that's what you need, you can use CF's own logging facility and not use any proxy at all. If you're testing AJAX functionality, you can use CF's JavaScript API to output items to the AJAX debug output window directly. You can also output items to the regular JavaScript console, which will show up in Firebug. 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.

Actually, we don't output anything...ColdFusion handles it automatically for you. All we do is enable debugging output in CF Administrator Freundliche Grüße / Best regards, Bill Franklin Computer Integrated Mfg. Bayer CropScience LP 8400 Hawthorne Road, Room 2447 Kansas City, MO 64120 Tel: +1 816 242 2148 Fax: +1 816 242 2047 E-mail: bill.franklin@bayer.com Web: http://www.bayercropscience.com Vorstand: Sandra E. Peterson, Vorsitzende   |  Lykele van der Broek, Achim Noack, Rüdiger Scheitza, Michael A. Schulz Vorsitzender des Aufsichtsrats: Werner Baumann Sitz der Gesellschaft: Monheim am Rhein   |   Eintragung: Amtsgericht Düsseldorf, HRB 46985 > Hence the use of Charles Proxy, which, up until ColdFusion 9, allowed us to see the SQL Queries that were run inside the CFC calls... I've used Charles before, but since it's an HTTP proxy, I don't see how it would let you see the actual SQL queries being run unless the CFC were outputting that information in some way. If that's what you need, you can use CF's own logging facility and not use any proxy at all. If you're testing AJAX functionality, you can use CF's JavaScript API to output items to the AJAX debug output window directly. You can also output items to the regular JavaScript console, which will show up in Firebug. 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.

> Actually, we don't output anything...ColdFusion handles it automatically for you.  All we do is enable debugging output in CF Administrator Do you have the option to output query information checked as well? 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

> > Actually, we don't output anything...ColdFusion handles it automatically for you.  All we do is enable debugging output in CF Administrator > > Do you have the option to output query information checked as well? Also, I suspect that this might not work in CF 9 because having CFCs return something other than the specific output format of the CFC method result (JSON, XML, etc) could easily break the client. 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

I think the key problem here, is that ColdFusion 9 is returning the CFMLDebugger class, instead of the AMFDebugger class...perhaps a channel configuration issue??? Freundliche Grüße / Best regards, Bill Franklin Computer Integrated Mfg. Bayer CropScience LP 8400 Hawthorne Road, Room 2447 Kansas City, MO 64120 Tel: +1 816 242 2148 Fax: +1 816 242 2047 E-mail: bill.franklin@bayer.com Web: http://www.bayercropscience.com Vorstand: Sandra E. Peterson, Vorsitzende   |  Lykele van der Broek, Achim Noack, Rüdiger Scheitza, Michael A. Schulz Vorsitzender des Aufsichtsrats: Werner Baumann Sitz der Gesellschaft: Monheim am Rhein   |   Eintragung: Amtsgericht Düsseldorf, HRB 46985 ----- Excess quoted text cut - see Original Post for more ----- Also, I suspect that this might not work in CF 9 because having CFCs return something other than the specific output format of the CFC method result (JSON, XML, etc) could easily break the client. 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

Yes Freundliche Grüße / Best regards, Bill Franklin Computer Integrated Mfg. Bayer CropScience LP 8400 Hawthorne Road, Room 2447 Kansas City, MO 64120 Tel: +1 816 242 2148 Fax: +1 816 242 2047 E-mail: bill.franklin@bayer.com Web: http://www.bayercropscience.com Vorstand: Sandra E. Peterson, Vorsitzende   |  Lykele van der Broek, Achim Noack, Rüdiger Scheitza, Michael A. Schulz Vorsitzender des Aufsichtsrats: Werner Baumann Sitz der Gesellschaft: Monheim am Rhein   |   Eintragung: Amtsgericht Düsseldorf, HRB 46985 > Actually, we don't output anything...ColdFusion handles it > automatically for you.  All we do is enable debugging output in CF > Administrator Do you have the option to output query information checked as well? 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