Can I ask why you'd set returnType to JSON and then go to the trouble of building a string instead of letting the CFC do the work and actually return the JSON from your data?
mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ On 20 February 2010 05:26, Chad McCue <[email protected]> wrote: > > http://www.datatables.net/ > > I am currently using the above URL that will handle my data results set. > Works fine in Firefox but will return no data in IE. Here is my > implementation. > > Calling page > > $(document).ready(function() { > resultTable = $('##example').dataTable ( { > "sPaginationType": "full_numbers", > "bProcessing": true, > "sAjaxSource": > '/cfcomponents/practice/user/user.cfc?method=GetUsersByType&practiceID=213' > } ); > > } ); > > Cfc > > <cffunction name="GetUsersByType" access="remote" output="true" > returnFormat="JSON"> > <cfargument name="practiceID" default="0" /> > > <cfquery name=users> > //query to get the users. > </cfquery> > > <cfsetting showdebugoutput="false" > > <cfcontent reset="yes" > > <cfoutput> > { "aaData": [<cfloop query="users"><cfif Type > is"Patient"><cfset RoleID = 1 /><cfelseif Type IS "Staff"><cfset RoleID = > 2/><cfelseif Type IS "Physician"><cfset RoleID = 3 /><cfelseif Type IS > "Referring Physician"><cfset RoleID = 4 /></cfif> > ["#trim(name)#","#trim(type)#","<cfif #locked# EQ 1>L<cfelseif #frozen# EQ > 1>F<cfelse>O</cfif>","<a > href='userDetails.cfm?id=#id#&RoleID=#RoleID#'>View</a>"]<cfif > #users..currentRow# NEQ #users.Recordcount#>,</cfif></cfloop>] } > </cfoutput> > > </cffunction> > > > Again returns the exact result set in firefox but nothing in IE 8 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:330975 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
