Unfortunately "to", "from" and "date" are reserved words - they hadn't thought of QoQ when they designed CFPOP of course.
http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/using_36.htm Nick ----- Original Message ----- From: "Jolly Green Giant" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, September 23, 2004 6:08 PM 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]
