Re: entering a decimal number

2008-04-30 Thread daniel kessler
>You need to use the scale attribute of cfqueryparam: > >http://www.cfquickdocs.com/?getDoc=cfqueryparam That worked great. Thank you very much. daniel ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic rele

Re: entering a decimal number

2008-04-30 Thread Greg Morphis
Oracle NUMBER does allow for decmials.. For testing, try inserting a decmial value into it yoursefl insert into foo (myNumVal) values (3.14) and then select from it.. Might be in your CF code that it's taking it off. On Wed, Apr 30, 2008 at 7:59 AM, daniel kessler <[EMAIL PROTECTED]> wrote: >

Re: entering a decimal number

2008-04-30 Thread James Holmes
You need to use the scale attribute of cfqueryparam: http://www.cfquickdocs.com/?getDoc=cfqueryparam Attribute, Req/Opt, Default, Description scale, Optional, 0, Number of decimal places in parameter. Applies to CF_SQL_NUMERIC and CF_SQL_DECIMAL. On Wed, Apr 30, 2008 at 8:59 PM, daniel kessler

entering a decimal number

2008-04-30 Thread daniel kessler
I have an Oracle table where the estimate field is a Number. I would think that I could enter a decimal number into it but I enter 36.41 (it will always be a dollar-type number) and it becomes 36 in the db. Here is the part that refers to it in my SQL INSERT: So how do I set it up to accept