Thanks dave. > 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:256042 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4