^ pop-out codeShare ^
  1. <cfcomponent output="false">
  2.     
  3. <cffunction name="checkName" access="remote">
  4.     <cfargument name="firstname" required="true">
  5.     <cfargument name="lastname" required="true">
  6.     <cfset var qryCheck = "">
  7.     <cfquery name="qryCheck" datasource="cfcodeexplorer">
  8.     SELECT artistID
  9.     FROM artists
  10.     WHERE lastname = <cfqueryparam value="#arguments.lastname#">
  11.         AND firstname = <cfqueryparam value="#arguments.firstname#">
  12.     </cfquery>
  13.     <cfreturn qryCheck.recordCount>
  14. </cffunction>
  15. <cffunction name="getCount" access="remote">
  16.     <cfset var qryCount = "">
  17.     <cfquery name="qryCount" datasource="cfcodeexplorer">
  18.     SELECT count(artistID) as total
  19.     FROM artists
  20.     </cfquery>
  21.     <cfreturn qryCount.total>
  22. </cffunction>
  23. </cfcomponent>