<cfset lista = "dal,aud,aut,sof,web">
<cfloop list="#lista#" index="logo">
    <cfquery name="elenco" DATASOURCE="intranet_#logo#">
        select m.*, f.Importo as imponibile, f.IVA from movimenti m
        inner join fatture_passivo f ON f.IDDocumento = m.IDFattura
        where f.ndc <> 'ndc'
        and m.Tipologia = 'IN_'
        order by datacont desc
    </cfquery>
    <cftransaction>
    <cfoutput query="elenco">
        #logo#|#dateformat(datacont, "dd/mm/yyyy")#|#IDmovimento#|#IDFattura#|#importo#|#imponibile#|#iva#|
		<cfif abs(Importo - imponibile - iva) lt .1>
            OK
            <cfquery DATASOURCE="intranet_#logo#">
                update movimenti set Tipologia = 'OUT' where IDmovimento = #IDmovimento#
            </cfquery>
        <cfelse>
            **********
        </cfif>
        <br />
    </cfoutput>
    </cftransaction>
</cfloop>
