ColdFusion Programming Help?

Question

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 :

MaxID is queried as follows:


SELECT Max(order_ID) AS maxID
FROM Orders;


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

Answer 1

My coldfusion is pretty rusty (php guy now) but the first question that comes to mind is, rather than use 2 seperate queries, why not use one?

Try SELECT * .... etc

WHERE order_ID = (SELECT MAX(order_ID) FROM Orders)
ORDER BY ... etc.

This is called a subquery or correlated subquery. Most SQL databases support the idea.

Answer 2

Did you put the first query in to the cfoutput tag.?
using the tag only we can get the values from the other query or other variables.

Please try the same code within the

i hope this will work for you

THanks,
M.RAJA