 deal with UWBM mammal data from vertnet
 maybe make this something else if if works
 
-
-
-
-reset button:
-
-
-
-update temp_uwbm_allagent2 set
-	rawagnt1=null,
-	rawagnt2=null,
-	rawagnt3=null,
-	rawagnt4=null,
-	rawagnt5=null,
-	agent1=null,
-	agent2=null,
-	agent3=null,
-	agent4=null,
-	agent5=null,
-	number1=null,
-	number2=null,
-	number3=null,
-	number4=null,
-	number5=null
- ;
 ---->
 <cfinclude template="/includes/_header.cfm">
 <cfset title='vertnet hates me'>



	<cfquery name="d" datasource="prod">
		select * from temp_uwbm_allagent2 where rawagnt1 is null
	</cfquery>
	<cfoutput>
		<cfloop query="d">
			<cfset i=1>
			<br>#correctedagent#
				<cfloop list="#correctedagent#" index="a" delimiters=",;">
					<cfquery name="u" datasource="prod">
						update temp_uwbm_allagent2 set rawagnt#i#='#a#' where correctedagent='#d.correctedagent#'
					</cfquery>

					<br>-----#a#
					<cfset i=i+1>

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

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

		</cfloop>
