Skip to content

Instantly share code, notes, and snippets.

@wellercs

wellercs/cf_QueryOfQueriesDivideByZeroNotThrowingError

Created July 27, 2012 22:56
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save wellercs/3190916 to your computer and use it in GitHub Desktop.
Save wellercs/3190916 to your computer and use it in GitHub Desktop.
Download ZIP
CF query of queries divide by zero not throwing error
Raw
cf_QueryOfQueriesDivideByZeroNotThrowingError
<cfquery name="qryTest" datasource="dsnCommon">
SELECT 0 AS col1, 0 AS col2
</cfquery>
<cfquery name="qqTest" dbtype="query">
SELECT (col1 / col2) AS col3
FROM qryTest
</cfquery>
<cfdump var="#qqTest#">
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment