Ryan a couple of things, are you locking the cfpop code where you are reading Session vars or move them to the request scope if you do not want to lock them and secondly what do you get if you cfdump the query recordset prior to the Query of a Query?
Kind Regards - Mike Brunt, CTO Webapper Blog http://www.webapper.net Web site http://www.webapper.com Downey CA Office 562.243.6255 AIM - webappermb Web Application Specialists -----Original Message----- From: Ryan Mitchell [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 11:44 AM To: CF-Talk Subject: Help please! I have the following query <cfpop action="getall" name="GetMessages" server=#server_ip# username=#Session.MM_User# password=#Session.MM_Pwd#> And im doing a query of a query in order to order it by latest first <cfquery name="OutputMessages" dbtype="query"> SELECT * FROM GetMessages ORDER BY UID DESC </cfquery> And this worked fine till 10 mins ago, but now I get this error Query Manipulation Error Code = 0 Invalid SQL Both when there are messages and when there arent! Can anyone shed any light on this? Ryan ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
