>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
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:
>
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
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
4 matches
Mail list logo