datatables action page

pagename_action.cfm

<!--- sets filename as session variable --->
<cfset filename = evaluate("replace(GetFileFromPath(GetCurrentTemplatePath()),'_action.cfm','')") />

<cfset columnOrder = "name,title,phone,description">
<cfset columnCount = "c.name" />

<cfoutput>
  <cfsavecontent variable="mycolumnstruct.phone">
	ISNULL(RTRIM(N.first),'')+' '+CASE WHEN N.MIDDLE IS NOT NULL THEN ISNULL(RTRIM(N.middle),'')+' ' ELSE ''END +ISNULL(RTRIM(N.last),'')
	</cfsavecontent>
	<cfsavecontent variable="mycolumnstruct.title">
	isnull(n.title,'') 
	</cfsavecontent>
	<cfsavecontent variable="mycolumnstruct.name">			
	C.Name
	</cfsavecontent>
	<cfsavecontent variable="mycolumnstruct.description">
	Z2.Description
	</cfsavecontent>
	<cfsavecontent variable="mycolumnstruct.icons">		
	'<a class="editlink" href="BoardDetailUpdate.cfm?im_id='+convert(varchar(50),I.im_id)+'&proc=add&levels=#levels#&bm_id=#bm_id#&bh_id=#bh_id#"><i class="icon-pencil"></i> '+'Add '+'</a>'
	</cfsavecontent>
</cfoutput>

<!--- generic processing (no need to touch)--->
<cfinclude template="datatables_processing.cfm" />