document.write('
Data hosted with ♥ by Pastebin.com - Download Raw - See Original
  1. <cfcomponent>
  2.     <cffunction name="queryNames" access="remote">
  3.         <cfargument name="searchPhrase" />
  4.  
  5.         <cfquery name="query_names" maxrows="10" dbtype="query">
  6.             SELECT    Name
  7.             FROM      names_table
  8.             WHERE     LOWER(Name) LIKE <cfqueryparam cfsqltype=\'cf_sql_varchar\' value="%#LCASE(arguments.searchPhrase)#%" />
  9.             ORDER BY  Name
  10.         </cfquery>
  11.  
  12.         <cfset result = arrayNew(1) />
  13.  
  14.         <cfloop query="query_names">
  15.             <cfset ArrayAppend(result, query_names.Name) />
  16.         </cfloop>
  17.    
  18.         <cfreturn result />
  19.     </cffunction>
  20. </cfcomponent>
');