Working on a 'second generation' application and keep getting an error as follows:

Element MAXID is undefined in GETORDERID.

The error occurred in {Path of File}: line 286

284 : SELECT *
285 : FROM products INNER JOIN (product_types INNER JOIN (orders INNER JOIN orders_products ON orders.order_ID = orders_products.order_prod_order_ID) ON product_types.pt_ID = orders.order_pt_ID) ON (product_types.pt_ID = products.prod_pt_ID) AND (products.prod_ID = orders_products.order_prod_prod_ID)
286 : WHERE order_ID = #getOrderID.maxID#
287 : ORDER BY prod_format, prod_code, prod_desc;
288 : </cfquery>

MaxID is queried as follows:

<CFQUERY NAME="getOrderID" DATASOURCE="#Session.datasource#" blockfactor="100" dbtype="ODBC">
SELECT Max(order_ID) AS maxID
FROM Orders;
</CFQUERY>

Suggestions on how to get rid of this as it occurs EVERY time?

__________________

---