 							<cfset local.sql.order = "RAND()">
 						</cfif>
 					<cfelse>
-						<cfset local.sql.pagination.qualified_order = "">
-						<cfset local.sql.pagination.simple_order = "">
 						<cfloop list="#arguments.order#" index="local.i">
 							<cfset local.i = trim(local.i)>
 							<cfif local.i Does Not Contain " ASC" AND local.i Does Not Contain " DESC">
 								<cfset local.i = local.i & " ASC">
 							</cfif>
-							<cfset local.sql.pagination.simple_order = listAppend(local.sql.pagination.simple_order, listLast(local.i, "."))>
+							<cfset local.sql.pagination.simple_order = listAppend(local.sql.pagination.simple_order, listLast(local.i, "."), chr(7))>
 							<cfif (local.i Contains "." AND listFirst(local.i, ".") IS variables.class.table_name OR local.i Does Not Contain ".") AND listFindNoCase(variables.class.field_list, listLast(spanExcluding(local.i, " "), ".")) IS NOT 0>
 								<cfset local.i = variables.class.table_name & "." & listLast(local.i, ".")>
 							<cfelseif (local.i Contains "." AND listFirst(local.i, ".") IS variables.class.table_name OR local.i Does Not Contain ".") AND listFindNoCase(variables.class.virtual_field_list, listLast(spanExcluding(local.i, " "), ".")) IS NOT 0>


<cffunction name="FL_executeQuery" returntype="any" access="private" output="false">
	<cfset var locals = structNew()>

	<cfif application.settings.environment IS NOT "production">
		<cfset locals.query_start_time = getTickCount()>


				<!--- add order clause --->
				<cfset local.sql.order = "">
				<cfset local.sql.pagination.qualified_select = "">
				<cfset local.sql.pagination.simple_select = "">
				<cfset local.sql.pagination.qualified_order = "">
				<cfset local.sql.pagination.simple_order = "">
				<cfset local.sql.pagination.qualified_order_reversed = "">
				<cfset local.sql.pagination.simple_order_reversed = "">
				<cfif len(arguments.order) IS NOT 0>
					<cfif arguments.order IS "random">
						<cfif application.wheels.database.type IS "sqlserver">
