I tried decimal(19,2) and back to smallmoney and still 36.00 gets inserted
into the database table. And changed the type in the cfc to cf_sql_decimal.
On Mon, Nov 12, 2012 at 10:56 AM, Greg Morphis wrote:
> Something is baffling me.. I'm inserting a value into the database and
> it's rounding
Aha, Google is my friend..
when using cf_sql_decimal you must specify the scale parameter..
scale="2" />
makes it all work.. now to go through and make sure everywhere else I'm
using the cf_sql_decimal I'm providing the scale parameter.
On Mon, Nov 12, 2012 at 11:28 AM, Greg Morphis wrote:
removing the cfqueryparam
,
works..
just having #arguments.payment.getamount_paid()#
causes it to work fine.. 35.52 is saved as 35.52 in the database.
Any ideas as to why this happens? I'm using CF9.0.1
On Mon, Nov 12, 2012 at 11:11 AM, Greg Morphis wrote:
> I tried decimal(19,2) and back to
Something is baffling me.. I'm inserting a value into the database and it's
rounding the number. I don't know where or why this is happening!
On the action page this is what the code looks like when inserting
INSERT INTO mytable
Why not generate a single pdf so they can print all the dockets in one go,
or generate a bunch of links to separate dockets for him to print at the
end.
Regards
Russ Michaels
On Nov 12, 2012 9:40 AM, "Anthony Doherty" wrote:
>
> I am trying to create a delivery report system for a delivery run.
I am trying to create a delivery report system for a delivery run.
The user currently has to run the report for each order number and print out
the delivery docket.
This system is fine for one or two dockets but when a particular run is
required there could be 20/30 dockets.
So i was proposin
6 matches
Mail list logo
