All pastes #281803 Raw Edit

Something

public text v1 · immutable
#281803 ·published 2006-12-17 01:55 UTC
rendered paste body
<cfcomponent output="false">
	<cffunction name="getOverrides" returnType="query" output="no" access="remote">
		<cfargument name="Lab" type="string">
		<cfset var getOverrides = 0 />
		
		<!--- 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">
		
		<cfset var updateOverrides = 0 />

		<!--- 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 updateOverrides>
	</cffunction>
</cfcomponent>