on the order detail page, create an orderdetails rs.
where detailorderid = colname
I've got colname set to $_GET['OrderID']
then as ray suggests, pull your data onto the page (tables are best here) and then run a repeat region behaviour for all records in the rs.
Did you set the variable for colname before or after the query?
I'm not sure if colname here is a variable or how you actually set it...
But, since this is a detail page, there is only one record going to show, the exact record for the order id and I don't need repeating regions on this page...