How to get serialized JSON results from a CFC, AJAX and a SQL Stored Procedure

Using a CFC in AJAX is easy. Just make sure to pass your arguments in and use  the arguments scope within the cfc and then use them in a cfproc param within your code. This way you can pass multiple parameters into your sql stored procedure. The benefit of this I found is that I have greater security on the sql query and can validate the parameters being sent to SQL. I can created indexes and update the stats on […]