<cfquery   name="getUser" datasource="#Application.DataSrc#">
   SELECT  * FROM 
   FROM #Request.prefix_db_lookup#.pEmployee
   WHERE  Loc_ID = "103"
   AND Emp_ID > 107
</cfquery>

<cfloop query="getUser">
      <cfif getUser.Password NEQ ''>
         <cfset encryptedpassword = #encrypt(getUser.Password, "WTq8zYcZfaWVvMncigHqwQ==", "AES", "Base64")# />
         <cfquery   name="updateencryptedpassword" datasource="#Application.DataSrc#">
            UPDATE #Request.prefix_db_lookup#.pEmployee 
               SET  Password = <cfqueryparam cfsqltype="cf_sql_varchar" value="#encryptedpassword#">
            WHERE Emp_ID = <cfqueryparam cfsqltype="cf_sql_integer" value="#getUser.Emp_ID#">
         </cfquery>
      </cfif>
</cfloop>


