update tbl_EML_CampaignRecipients set beaconCount = coalesce( beaconCount, 0 ) + 1, beaconLastHit = , beaconFirstHit = case when beaconFirstHit is null then else beaconFirstHit end where recipientId = and token = templatePath = GetCurrentTemplatePath(); directory = GetDirectoryFromPath( templatePath ); fileName = directory & "clearpixel.gif"; context = getPageContext(); context.setFlushOutput(false); response = context.getResponse().getResponse(); response.setStatus( 200 ); response.setContentLength( arrayLen(fileContent) ); response.setHeader( "Content-Type", "image/gif" ); response.setHeader( "Last-Modified", "Sun, 01 Jun 2008 18:26:10 GMT" ); out = response.getOutputStream(); out.write( fileContent ); out.flush(); update tbl_WRK_Emails set beaconCount = coalesce( beaconCount, 0 ) + 1, beaconLastHit = , beaconFirstHit = case when beaconFirstHit is null then else beaconFirstHit end where emailId = and emailToken = templatePath = GetCurrentTemplatePath(); directory = GetDirectoryFromPath( templatePath ); fileName = directory & "clearpixel.gif"; context = getPageContext(); context.setFlushOutput(false); response = context.getResponse().getResponse(); response.setStatus( 200 ); response.setContentLength( arrayLen(fileContent) ); response.setHeader( "Content-Type", "image/gif" ); response.setHeader( "Last-Modified", "Sun, 01 Jun 2008 18:26:10 GMT" ); out = response.getOutputStream(); out.write( fileContent ); out.flush(); Sorry, the requested page could not be found!