<cfquery name="rsDetail" datasource="mysqlcf_aldershot">
SELECT * FROM orders, orderitems
WHERE orders.OrderNum = orderitems.ItemOrder AND orders.OrderNum = <cfqueryparam cfsqltype="cf_sql_integer" value="#URL.ID#"> AND orders.OrderSite = #SESSION.theSite#
AND orderitems.ItemSite = #SESSION.theSite#
ORDER BY orders.OrderDate DESC
</cfquery>

<cfif rsDetail.RecordCount EQ 0>
<cflocation url="index.cfm" addtoken="no">
</cfif>