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]
