 
 <cffunction name="$getType" returntype="string" access="public" output="false">
 	<cfargument name="type" type="string" required="true">
+	<cfargument name="scale" type="string" required="true">
 	<cfscript>
 		var loc = {};
 		switch(arguments.type)

			<cfreturn loc.returnValue>
		</cfif>
	</cfif>
</cffunction>
			case "clob": case "nclob": {loc.returnValue = "cf_sql_clob"; break;}
			case "date": case "timestamp": {loc.returnValue = "cf_sql_timestamp"; break;}
			case "binary_double": {loc.returnValue = "cf_sql_double"; break;}
			case "number": case "float": case "binary_float":
			{
				// integer datatypes are represented by number(38,0)
				if (val(arguments.scale) == 0)
				{
					loc.returnValue = "cf_sql_integer";
				}
				else
				{
					loc.returnValue = "cf_sql_float";
				}
				break;
			}
			case "long": {loc.returnValue = "cf_sql_longvarchar"; break;}
			case "raw": {loc.returnValue = "cf_sql_varbinary"; break;}
			case "varchar2": case "nvarchar2": {loc.returnValue = "cf_sql_varchar"; break;}
