I notice the power operator doesn't seem to work inside query-of-queries. For example:
WHERE (#params.x# - x)^2 + (#params.y# - y)^2 < #params.range^2# The third one actually does work as CF evaluates it before processing the query code. The first and second don't work as they are part of the SQL. I can of course just use a multiplication operator. But I was wondering if there's any info about on what operators are supported in QoQ (this is CF7). ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:214125 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
