 			<cfquery name="p" datasource="prod" >
 				update address set S$COORDINATES='#coords#', S$LASTDATE=sysdate where address_id=#address_id#
 			</cfquery>
+			---->
 
 		</cfloop>
 								<!--- call remote so no transaction datasource conflicts---->

	where
		s$lastdate is null and
		address_Type in ('shipping', 'correspondence') and
		rownum<100
		</cfquery>
		<cfloop query="d">
			<cfset coords=''>
			<br>#address#
			<cfset rmturl=replace(Application.serverRootUrl,"https","http")>
			<cfhttp method="get" url="#rmturl#/component/utilities.cfc?method=georeferenceAddress&returnformat=plain&address=#URLEncodedFormat(address)#" >
			<cfset coords=cfhttp.fileContent>


		--->


select
	address_Type,
	count(*)
from
	address,
	shipment
where
	shipment.SHIPPED_TO_ADDR_ID=address.address_id
group by address_type;


select
	address_Type,
	count(*)
from
	address,
	shipment
where
	shipment.SHIPPED_FROM_ADDR_ID=address.address_id
group by address_type;



<cfoutput>

	select count(*) from address where address_Type in ('shipping', 'correspondence') ;
	select count(*) from address where address_Type in ('shipping', 'correspondence') and s$lastdate is not null ;

	<cfquery name="d" datasource="prod" >
			 select
