context = getPageContext(); context.setFlushOutput(false); response = context.getResponse().getResponse(); response.setIntHeader( "expires", 0 ); response.setHeader( "pragma", "cache" ); response.setHeader( "cache-control", "maxage=3600" ); out = response.getOutputStream(); response.setContentLength(arrayLen(_fileContent)); out.write(_fileContent); out.close(); select distinct 'MFR' + cast( bpl.mfrId as varchar ) as mainFolder from tbl_BRO_Principals bpl with (nolock) inner join tbl_BRO_principalTerritories pt with (nolock) on pt.principalId = bpl.principalId and pt.ownerId = bpl.ownerId and coalesce( pt.hireStatus, 'I' ) != 'I' where bpl.ownerId = and bpl.ownerType = context = getPageContext(); context.setFlushOutput(false); response = context.getResponse().getResponse(); response.setIntHeader( "expires", 0 ); response.setHeader( "pragma", "cache" ); response.setHeader( "cache-control", "maxage=3600" ); out = response.getOutputStream(); response.setContentLength(arrayLen(_fileContent)); out.write(_fileContent); out.close();