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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
