QoQ Problem with Railo 4.2

error.txt

Railo 4.2.1.000 Error (database)
Message	Encountered "INTEGER" at line 2, column 25.
Was expecting one of:
"," ...
")" ...
"." ...
"+" ...
"-" ...
"*" ...
"||" ...
"/" ...
"**" ...
"(" ...
SQL	
SELECT
CAST(resourceid as INTEGER) as resourceid
,CAST(rank as INTEGER) as rank
,CAST(s as VARCHAR) as s
,CAST(resourcetitle as VARCHAR) as resourcetitle
,CAST(publishdate as VARCHAR) as publishdate
,CAST(resourcedetailspath as VARCHAR) as resourcedetailspath
FROM
qry
WHERE 
resourceid IS NOT NULL
GROUP BY
CAST(resourceid as INTEGER)
ORDER BY
rank asc
Stacktrace	The Error Occurred in
/test/test.cfm: line 19 
17: ORDER BY
18: rank asc
19: </cfquery>

Java Stacktrace	Encountered "INTEGER" at line 2, column 25.
 Was expecting one of:
  "," ...
  ")" ...
  "." ...
  "+" ...
  "-" ...
  "*" ...
  "||" ...
  "/" ...
  "**" ...
  "(" ...
  
 	at railo.runtime.db.HSQLDBHandler.execute(HSQLDBHandler.java:306):306
 	at railo.runtime.tag.Query.executeQoQ(Query.java:678):678
 	at railo.runtime.tag.Query.doEndTag(Query.java:502):502
 	at test.test_cfm$cf.call(/test/test.cfm:19):19
 	at railo.runtime.PageContextImpl.doInclude(PageContextImpl.java:913):913
 	at railo.runtime.PageContextImpl.doInclude(PageContextImpl.java:865):865
 	at railo.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:206):206
 	at railo.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:18):18
 	at railo.runtime.PageContextImpl.execute(PageContextImpl.java:2218):2218
 	at railo.runtime.PageContextImpl.execute(PageContextImpl.java:2185):2185
 	at railo.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:332):332
 	at railo.loader.servlet.CFMLServlet.service(CFMLServlet.java:29):29
 	at javax.servlet.http.HttpServlet.service(HttpServlet.java:727):727
 	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303):303
 	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208):208
 	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52):52
 	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241):241
 	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208):208
 	at org.apache.catalina.filters.RemoteIpFilter.doFilter(RemoteIpFilter.java:834):834
 	at org.apache.catalina.filters.RemoteIpFilter.doFilter(RemoteIpFilter.java:870):870
 	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241):241
 	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208):208
 	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220):220
 	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122):122
 	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501):501
 	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171):171
 	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102):102
 	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116):116
 	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408):408
 	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1040):1040
 	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607):607
 	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:314):314
 	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145):1145
 	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615):615
 	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61):61
 	at java.lang.Thread.run(Thread.java:745):745
 
Timestamp	9/23/14 4:56:54 PM UTC

test.cfm

<cffile action="read" variable="wddx" file="wddx" />
<cfwddx action="wddx2cfml" input="#wddx#" output="qry" />
<cfquery name="local.qryResultsMetaObject" dbtype="query">
SELECT
	CAST(resourceid as INTEGER) as resourceid
   ,CAST(rank as INTEGER) as rank
   ,CAST(s as VARCHAR) as s
   ,CAST(resourcetitle as VARCHAR) as resourcetitle
   ,CAST(publishdate as VARCHAR) as publishdate
   ,CAST(resourcedetailspath as VARCHAR) as resourcedetailspath
FROM
	qry
WHERE 
	resourceid IS NOT NULL
GROUP BY
	CAST(resourceid as INTEGER)
ORDER BY
	rank asc
</cfquery>

wddx

<wddxPacket version='1.0'><header/><data><recordset rowCount='1' fieldNames='resourceId,resourcetitle,publishdate,S,RANK,resourcedetailspath' type='coldfusion.sql.QueryTable'><field name='resourceId'><string>1942</string></field><field name='resourcetitle'><string>HUD's Implementation Plan for the National HIV/AIDS Strategy</string></field><field name='publishdate'><string>2011-02-01</string></field><field name='S'><string>&lt;b&gt;...&lt;/b&gt; Journal of Epidemiology and Community Health, 55(7):515-‐&lt;br&gt; 520. 4 Steffen, BL, &lt;b&gt;Fudge&lt;/b&gt;, K., Martin, M., Souza, MT,&lt;br&gt; Vandenbroucke, DA, and Yao, YGD (2011). &lt;b&gt;...&lt;/b&gt;  </string></field><field name='RANK'><string>1</string></field><field name='resourcedetailspath'><string>https://www.hudexchange.info/resource/1942/huds-implementation-plan-for-the-national-hiv-aids-strategy</string></field></recordset></data></wddxPacket>