<cfquery name="defaultorgqry" datasource="mydbdatasource" 
    cachedafter="#cachedate#" 
    result="defaultorgresult"
    select BillingCategory from mydatabase.dbo.EM 
    where employee = <cfqueryparam value="#employeeid#" cfsqltype="cf_sql_integer" />
</cfquery>

// DEFAULT LABOR CATEGORY PER EMPLOYEE *********************
TS_LABORCATEGORY_REGION = 'ts_entry_laborcategory';

// IF url param 'tscachebust=true' clear all cache results for TS_LABORCATEGORY_REGION
if( structKeyExists(url,'tscachebust') and url.tscachebust == 'true'){
    // IF region exists then remove it and all its cached results
    if( cacheRegionExists( TS_LABORCATEGORY_REGION ) ){
        cacheRegionRemove( TS_LABORCATEGORY_REGION );
    }
}

// create region, does not throw error is it already exists
cacheRegionNew(region= TS_LABORCATEGORY_REGION ,throwOnError=false);

// Get user's default labor category
// query for each employee will cache for 1 day
defaultorgqry = queryExecute(
    'select BillingCategory from mydatabase.dbo.EM where employee = :employeeid',
    {employeeid: theEmpN},
    {
        datasource='mydbdatasource',
        cachedwithin = createTimespan(1,0,0,0),
        cacheRegion = TS_LABORCATEGORY_REGION,
        cacheid = 'id_'&theEmpN,
        result='tslcresult'
    }
);