rendered paste body<cfcomponent output="false">
<cffunction name="getOverrides" returnType="query" output="no" access="remote">
<cfargument name="Lab" type="string">
<!--- Get All Overrides for specified Lab --->
<cfquery name="getOverrides" datasource="#Lab#">
SELECT AppCustDefaults.ID as DefaultID, *
FROM AppCustOverrides INNER JOIN AppCustDefaults ON AppCustOverrides.AppCust = AppCustDefaults.AppCust
WHERE AppCustOverrides.labid = <cfqueryparam value="#Lab#" cfsqltype="CF_SQL_VARCHAR">
ORDER BY AppCustDefaults.ID
</cfquery>
<cfreturn getOverrides>
</cffunction>
<cffunction name="updateOverrides" returnType="string" output="no" access="remote">
<cfargument name="Lab" type="string">
<cfargument name="overridesForm" type="struct">
<!--- Update Overrides for specified Lab --->
<cfquery name="updateOverrides" datasource="#Lab#">
UPDATE AppCustOverrides
SET OverrideValue = <cfqueryparam value="overridevalue_1" cfsqltype="CF_SQL_VARCHAR">
WHERE AppCust = <cfqueryparam value="#appCust#" cfsqltype="CF_SQL_VARCHAR">
AND LabID = <cfqueryparam value="#Lab#" cfsqltype="CF_SQL_VARCHAR">
</cfquery>
<cfreturn getOverrides>
</cffunction>
</cfcomponent>