I actually tried that and it times out. I've got some other goofy stuff going on now, though. The same cfm files that were working fine yesterday aren't working today. Even the same files that were working fine before I undertook this project are no longer working properly, either. I guess my ColdFusion sever is tired and needs a reboot...
-----Original Message----- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 13, 2007 11:54 AM To: CF-Talk Subject: RE: Having trouble getting variables from different tables to out put > > 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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 and Flex 2 Build sales & marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272592 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
