<cfquery datasource="XXXXXX" name="theOrders">
	SELECT
		*
	FROM
		Orders
	LEFT OUTER JOIN
		Loger
	ON
		Loger.UserID = Orders.CartID
</cfquery>
 
 
<CFSET tempfile = "#expandpath('allOrders')##DateFormat(Now(), 'yyyy_mm_dd')#.csv" />
 
<!---
	The "spaces" in the text below are TAB characters.
	Do not change them to spaces otherwise the Excel
	export will not work.
--->
 
<CFSET output = "">
<CFSET output = output & "WebOrderID CartID Accountnumber Shipping SubTotal Total Order-Hold" />
 
<CFFILE
	ACTION="WRITE"
	FILE="#tempfile#"
	OUTPUT="#output#"
	/>
 
<CFLOOP QUERY="theOrders">
 
	<CFSET output = "">
	<CFSET output = output & "#theOrders.WebOrderID# #theOrders.CartID# #theOrders.Accountnumber# #theOrders.Shipping1# #theOrders.Subtotal# #theOrders.Total# #theOrders.Hold#">
 
	<CFFILE
		ACTION="APPEND"
		FILE="#tempfile#"
		OUTPUT="#output#"
		/>
 
	<cfquery datasource="XXXXXX" name="theRealCart">
		SELECT DISTINCT
			(WebOrderID),
			cartID,
			Location,
			Delivery,
			Quantity,
			ItemNumber,
			Item,
			Price,
			Vendor,
			Attention,
			Price
		FROM
			realcart
		Where
			WebOrderID = '#theOrders.WebOrderID#'
	</cfquery>
 
	<cfloop query="theRealCart">
 
		<CFSET output = "">
		<CFSET output = output & "#theRealCart.cartID# #theRealCart.Vendor# #theRealCart.Delivery# #theRealCart.Item# #theRealCart.ItemNumber# #theRealCart.Quantity# #theRealCart.Price# #theRealCart.Attention#">
 
		<CFFILE
			ACTION="APPEND"
			FILE="#tempfile#"
			OUTPUT="#output#"
			/>
 
	</cfloop>
 
</CFLOOP>