> > SELECT LI.OrderNum, LI.Status, LI.MainLine, LI.acct_id, > > LI.date, LI.po_num, H.reorder_num, H.control_num FROM > > QOrdLineItems LI INNER JOIN QHistRO H ON LI.OrderNum = > > H.reorder_num OR LI.OrderNum = H.control_num WHERE acct_id = > > <cfqueryparam cfsqltype="cf_sql_varchar" value="#COOKIE.id#"> > > ORDER BY date DESC > > I tried your new query and got "Error Executing Database Query. > [Macromedia][SequeLink JDBC Driver][ODBC > Socket][Pervasive][ODBC Client > Interface][LNA][Pervasive][ODBC Engine Interface]Non unique column > reference: date."
Sorry, try "ORDER BY LI.date DESC" instead. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! This email has been processed by SmoothZap - www.smoothwall.net ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade & see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272564 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
