Do I need to lock them (donšt know much about this!)? I've fixed the problem, it was as easy as a space left out.. Oops I should have checked! thanks anyways.
On another note, how do you return whether the email has an attachment or not? I've tried using isDefined() and also if attachement is not '' but to no avail!! Ryan On 9/12/02 20:03, "Mike Brunt" <[EMAIL PROTECTED]> wrote: > 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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
