> If QofQ follows the same rules as SQL Server, you cannot reference an > alias in the order by clause. Try changing the last line to:
Really? That kinda conflicts with the docs: SQL Server 2000: http://msdn.microsoft.com/en-us/library/aa259187%28v=sql.80%29.aspx#_order_by_clause 2008: http://msdn.microsoft.com/en-us/library/ms188385.aspx Unfortunately I don't have a working SQL Server instance to verify this, but I'm definitely used aliases in ORDER BY statements in the past. -- Adam -- Open BlueDragon Public Mailing List http://www.openbluedragon.org/ http://twitter.com/OpenBlueDragon official manual: http://www.openbluedragon.org/manual/ Ready2Run CFML http://www.openbluedragon.org/openbdjam/ mailing list - http://groups.google.com/group/openbd?hl=en
