EasyCFM.COM ColdFusion Forums / MySQL Related Issues / Decimals and MySQL 5

   Reply to Discussion | New Discussion << previous || next >> 
Posted By Discussion Topic: Decimals and MySQL 5

book mark this topic Printer-friendly Version  send this discussion to a friend  new posts last

jansolo
11-27-2008 @ 5:36 AM
Reply
Edit
Profile
Send P.M.
My Gravatar!
Powered by Gravatar
Senior Member
Posts: 218
Joined: Mar 2003

I think MySQL 5 throws up so many problems, but any way...

I have a column for the price of something, and it is decimal (5,2).

When I upload from a form, the value 5.84 is rounded to 6. If I enter it
direct into the DB it keeps it as 5.84.

I have tried numberformat, changing the column to VarChar, Double
and Int, but none of this works.

Any solutions - I need 'em soon Smile

Cheers in advance.

cfSearchin
11-27-2008 @ 11:30 AM
Reply
Edit
Profile
Send P.M.
My Gravatar!
Powered by Gravatar
Senior Member
Posts: 608
Joined: Feb 2008

Are you using cfqueryparam? Can you post your code?


Website Designed and Developed by Pablo Varando.