 
 
 
-	<cfquery name="d" datasource="uam_god">
+	<cfquery name="d" datasource="prod">
 		select * from temp_uwbm_allagent2 where rawagnt1 is null
 	</cfquery>
 	<cfoutput>

		<cfset nn="number#num#">


		<cfquery name="d" datasource="uam_god">
			select distinct #f# rawstring from temp_uwbm_allagent2 where #f# is not null and
			#an# is null
		</cfquery>

			<br>x.n=#x.n#
			<br>x.a=#x.a#

			<cfquery name="u" datasource="prod">
				update temp_uwbm_allagent2 set #an#='#x.a#',#nn#='#x.n#' where #f#='#rawstring#'
			</cfquery>

