TO might be reserved, alias it and see if that helps. Ade
-----Original Message----- From: Jolly Green Giant [mailto:[EMAIL PROTECTED] Sent: 23 September 2004 18:09 To: [EMAIL PROTECTED] Subject: [ cf-dev ] MX, CFPop, and QofQ I'm on MX and have run a CFPop command and am successfully checking the mailbox because I can dump the query var and see the message stuff. But then I want to do a query on that cfpop query object to sort the results. This query worked fine in CF 5... <cfquery dbtype="query" name="sortedheaders"> SELECT to, subject, messagenumber, from, uid, date, body FROM getmessages ORDER BY to, subject, messagenumber </cfquery> But now it crashes in MX with the following error... Query Of Queries syntax error. Encountered "to" at line 0, column 0. Incorrect Select List, Incorrect select column Any ideas? . -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
