Max number of decimal places in cfprocparam?

[dsmith]

It appears that the maximum number of decimal places that cfprocparam will
return is 12, using this syntax:

<cfprocparam type="Out" cfsqltype="CF_SQL_FLOAT" variable="token_id"
null="No">

The 12th decimal place appears to be rounded, so for example, even though the
stored proc should be returning a value of:

0.72341148990357396

it is actually returning

0.723411489904

Is this the case? Is there anyway around it? the "scale" attribute seems to
make no difference. Thanks!

[dsmith]

Problem solved...

Even though cfoutput and cfdump both reported the same thing (that is, a
variable of 12 decimal places), if I used the following instead:

<cfqueryparam value="#token_id#" cfsqltype="CF_SQL_FLOAT">

the appropriate number of decimal places appeared. Very bizarre, but glad to
have it fixed.