|
you could try putting "to" in square brackets [to]
and alias it so you can use it:
[to] as toField
or something!
----- Original Message -----
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]
|
