Ryan, glad to see you found that problem and yes to answer your question you need to lock all Writing and Reading of Application, Server and Session variables otherwise eventually you will experience problems and they will unexpected, unpredictable and very debilitating.
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 2:48 PM To: CF-Talk Subject: Re: Help please! 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.