<cfset dsn = "#session.dsn#">

<!--- 
<cfquery name="cattura" datasource="#session.dsn#">
 select d.IDDominio, z.ID_Dominio, z.cod_forn, z.data from ZZ_Domini z INNER JOIN domini d 
 ON d.dominio = z.dominio
 where d.cod_forn is null
 </cfquery>

<cfloop query="cattura">
	<cfset data_ = dateformat(data, "dd/mm/yyyy")>
	<cfquery datasource="#session.dsn#">
	 update domini set cod_forn = '#cod_forn#',
	 data_elitel = #createODBCdate(dateformat(data_, "dd/mm/yyyy"))#
	 where IDDominio = #IDDominio#
	 </cfquery>
	<cfquery datasource="#session.dsn#">
	 update ZZ_Domini set importato = true where ID_Dominio = #ID_Dominio#
	 </cfquery>
</cfloop>
 --->
 <cfquery name="cattura" datasource="#session.dsn#">
 select z.ID_Dominio, z.dominio, z.cod_forn, z.data from ZZ_storno z 
 where z.cod_forn is not null
 </cfquery>

<cfloop query="cattura">
	<cfset dominio_ = trim(lcase(replacenocase(dominio, "Reg dominio", "")))>
	<cfset data_ = dateformat(data, "dd/mm/yyyy")>
	<cfquery datasource="#session.dsn#">
	 update domini set cod_forn = '#cod_forn#',
	 data_elitel = #createODBCdate(dateformat(data_, "dd/mm/yyyy"))#
	 where Dominio = '#Dominio_#'
	 and cod_forn is null
	 </cfquery>
	<cfquery datasource="#session.dsn#">
	 update ZZ_storno set importato = true where ID_Dominio = #ID_Dominio#
	 </cfquery>
</cfloop>
