Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- The cfc:
- <cfcomponent>
- <cffunction name="getArt" access="remote" returntype="query">
- <cfargument name="search" type="string" required="yes">
- <!--- get search results --->
- <cfset obj = createObject('component','farcry.core.packages.types.dmHTML') />
- <cfset props.whereclause = "objectid=objectid AND title LIKE '%#arguments.search#%' OR Body LIKE '%#arguments.search#%' OR Teaser LIKE '%#arguments.search#%'">
- <cfset results = obj.getMultipleByQuery(argumentCollection=props) />
- <cfreturn results>
- </cffunction>
- </cfcomponent>
- The code:
- <script>
- $(document).ready(function() {
- $("#searchbtn").click(function(e) {
- var search = $.trim($("#search").val());
- $.post("test.cfc?method=getArt&returnFormat=json&queryFormat=column", {"search":search}, function(res,code) {
- if(res.ROWCOUNT > 0) {
- var s = "<table border='1'><tr><th>Name</th><th>Price</th><th>Description</th></tr>";
- for(var i=0; i<res.ROWCOUNT; i++) {
- s += "<tr><td>" + res.DATA.title[i] + "</td>";
- s += "</tr>";
- }
- s += "</table>";
- } else {
- var s = "Sorry, nothing matched your search.";
- }
- $("#results").html(s);
- },"json");
- e.preventDefault();
- });
- });
- </script>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement