Have you tried it without the CAST() calls? The QoQ implementations behind the scenes is different in all the CFML engines. The Cast may not be needed. On Feb 28, 2011 4:04 PM, "ben.8" <[email protected]> wrote: > Hello, > > I've been digging for documentation on OpenBD's query-of-query > syntax. I'm attempting to port an app from CFMX7 to OpenBD 7, and > receiving an error message on a query-of-query that uses several cast > calls (e.g., CAST(data_intStatus AS CHAR)). CFMX7 supports this > syntax, but OpenBD does not appear to: > > The following error was produced: Encountered "cast" at line 12, > column 9. Was expecting one of: "*" ... "[" ... <IDENTIFIER> ... > <INTEGER_LITERAL> ... <FLOATING_POINT_LITERAL> ... "count" ... > "avg" ... "sum" ... "min" ... "max" ... "(" ... "+" ... "-" ... > "?" ... <STRING_LITERAL> ... "upper" ... "lower" ... > > Neither the wiki nor the OpenBD docs seem to contain any references to > STRING_LITERAL. Is there somewhere else I should be looking to see > usage and syntax of the expected arguments, or is there a way to get > CAST to work in QoQs, or a relatively straightforward syntax change > (one can hope!)? > > cheers, > -ben > > -- > tag/function ref: http://www.openbluedragon.org/manual/ > mailing list - http://groups.google.com/group/openbd?hl=en
-- tag/function ref: http://www.openbluedragon.org/manual/ mailing list - http://groups.google.com/group/openbd?hl=en
