Advertisement
Guest User

Untitled

a guest
Jun 26th, 2017
68
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.23 KB | None | 0 0
  1. The cfc:
  2.  
  3. <cfcomponent>
  4. <cffunction name="getArt" access="remote" returntype="query">
  5.  
  6. <cfargument name="search" type="string" required="yes">
  7.  
  8. <!--- get search results --->
  9. <cfset obj = createObject('component','farcry.core.packages.types.dmHTML') />
  10. <cfset props.whereclause = "objectid=objectid AND title LIKE '%#arguments.search#%' OR Body LIKE '%#arguments.search#%' OR Teaser LIKE '%#arguments.search#%'">
  11. <cfset results = obj.getMultipleByQuery(argumentCollection=props) />
  12.  
  13.  
  14. <cfreturn results>
  15. </cffunction>
  16. </cfcomponent>
  17.  
  18. The code:
  19.  
  20. <script>
  21.  
  22. $(document).ready(function() {
  23.  
  24. $("#searchbtn").click(function(e) {
  25. var search = $.trim($("#search").val());
  26.  
  27. $.post("test.cfc?method=getArt&returnFormat=json&queryFormat=column", {"search":search}, function(res,code) {
  28. if(res.ROWCOUNT > 0) {
  29. var s = "<table border='1'><tr><th>Name</th><th>Price</th><th>Description</th></tr>";
  30. for(var i=0; i<res.ROWCOUNT; i++) {
  31. s += "<tr><td>" + res.DATA.title[i] + "</td>";
  32. s += "</tr>";
  33. }
  34. s += "</table>";
  35. } else {
  36. var s = "Sorry, nothing matched your search.";
  37. }
  38. $("#results").html(s);
  39.  
  40. },"json");
  41.  
  42. e.preventDefault();
  43. });
  44. });
  45.  
  46. </script>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement