Untitled

jasch

Oct 12th, 2011

197

Never

Add comment

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

ColdFusion 1.82 KB | None | 0 0

raw download clone embed print report

CFM PAGE ///////////////
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
<link rel="stylesheet" type="text/css" href="../Scripts/jquery/jquery-ui-custom2012/css/custom-theme/jquery-ui-1.8.16.custom.css" />
<script src="http://ajax.googleapis.com/ajax/libs/jquery/1/jquery.min.js"></script>
<script src="http://ajax.googleapis.com/ajax/libs/jqueryui/1/jquery-ui.min.js"></script>
<script type="text/javascript">
$(function() {
$("#category").autocomplete({
source: "service2.cfc?method=searchcategories&returnformat=json",
select:function(event,ui) {
$("#catid").val(ui.item.id)
}
});
});
</script>
</head>
<body>
<form action="Test-AutoSuggest.cfm" method="post">
category: <input name="category" id="category" />
<input name="catid" id="catid" type="hidden">
<input type="submit" value="Submit">
</form>
<cfif not structIsEmpty(form)>
<cfdump var="#form#" label="Form">
</cfif>
</body>
</html>
CFC ///////////////////
<cfcomponent>
<cffunction name="searchCategories" access="remote">
<cfargument name="term" type="string">
<cfset var q = "">
<cfset var result = []>
<cfquery name="q" datasource="#application.datasource#">
select ContactID as id,
CONCAT(LastName, ', ', FirstName) as value
from contacts
where LastName 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