On 10/9/06, Varun Dixit <[EMAIL PROTECTED]> wrote: > I have been trying to figure out how does oracles translates those 20 odd > data types supported in CFQUERYPARAM tag. But I have not had much luck > finding anything, any help or pointers in this regard would be appreciated. > > My main concern is which one is less forgiving and how does oracle translates > these data types. >
There used to be a page up to outline this, but it looks like it has been taken down. Anyway, cf_sql_integer will translate to a NUMBER datatype with no precision (so no decimals). The cf_sql_numeric datatype will actually be a one-digit decimal on Oracle's side (i.e., NUMBER(3,1)). You use the "scale" attribute of the cfqueryparam tag to change the number of decimals to use. So" <cfqueryparam value="#myDollarValue#" cfsqltype="cf_sql_numeric" scale="2" null="false" /> Will insert a two-digit decimal value. Regards, Dave. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:256007 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
