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:330960
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
