Haven't tested it, but does the Sqr function work in this case? http://livedocs.macromedia.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/js/html/wwhelp.htm?href=00000870.htm
Erik Yowell Short Fuse Media, Inc. Matthew Walker wrote: >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:214184 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
