TryCF Gist

trycf-gist-1644889776946-ab807567-831c-cdc5-7ce3-341784367486.cfm

<cffunction name="orders" returntype="any">
		<cfargument name="inparam" required="false" default="" type="any">
		<cfargument name="search" required="false" default="">
		<cfparam name="start" default="10" type="integer" />
		<cfparam name="length" default="10" type="integer" />

		<cfset var rsQuery = ''>
		<cfsavecontent variable="MainQuery">
			SELECT * 
			FROM
			  bills
			WHERE 
			  billtype = 'Bill'
		</cfsavecontent>	
		
		<cfquery name="rsQuery" datasource="#Application.dsn#">
			#preserveSingleQuotes(MainQuery)#
			<cfif len(trim(search))>
			AND
			    ( 
			    <cfloop list="#listColumns#" index="thisColumn">
			    <cfif thisColumn neq listFirst(listColumns)> 
			    OR 
			    </cfif>
			    	#thisColumn# LIKE <cfqueryparam cfsqltype="CF_SQL_VARCHAR" value="%#trim(search)#%" />    
			    </cfloop>
			    )
			</cfif>
			
				ORDER BY BillID desc
			
			LIMIT #start# OFFSET #length#
		</cfquery>
		<cfdump var="#rsQuery#" abort>
		
		<cfreturn rsQuery>
	</cffunction>