Untitled

a guest

Oct 11th, 2011

197

0

Never

Add comment

Not a member of Pastebin yet? Sign Up, it unlocks many cool features!

ColdFusion 0.61 KB | None | 0 0

raw download clone embed print report

<cfcomponent>
<cffunction name="searchCategories" access="remote">
<cfargument name="term" type="string">
<cfset var q = "">
<cfset var result = []>
<cfquery name="q" datasource="cfartgallery">
select mediaid as id, mediatype as value
from media where
where mediatype like <cfqueryparam cfsqltype="cf_sql_varchar" value="#arguments.term#">
</cfquery>
<cfloop query="q">
<cfset result[arrayLen(result)+1] = {}>
<cfset result[arrayLen(result)]["id"] = query.id[i]>
<cfset result[arrayLen(result)]["value"] = query.value[i]>
</cfloop>
<cfreturn result>
</cffunction>
</cfcomponent>

Add Comment

Please, Sign In to add comment

Public Pastes