I know for sure that LEFT, RIGHT don't work. I would suspect that most
string parsing functions will not work.
And, while I haven't tested them, when I posted about this on the
forums, I got responses that the following also do not work:
-- CASE, DECODE, joins between more than 2 tables, LEFT and RIGHT joins.
-- Count() returns Null rather than 0 when there aren't any
records returned.
Cheers,
Kris
> It would be very nice to have a complete feature list of
> SQL commands and such that works with QoQ.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
http://www.fusionauthority.com/quarterly
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:248735
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4