PDO::PARAM for type decimal?
Posted
by dmontain
on Stack Overflow
See other posts from Stack Overflow
or by dmontain
Published on 2010-04-27T03:58:46Z
Indexed on
2010/04/27
4:03 UTC
Read the original article
Hit count: 519
I have 2 database fields
`decval` decimal(5,2)
`intval` int(3)
I have 2 pdo queries that update them. The one that updates the int works ok
$update_intval->bindParam(':intval', $intval, PDO::PARAM_INT);
but I can't update the decimal field. I've tried the 3 ways below, but nothing works
$update_decval->bindParam(':decval', $decval, PDO::PARAM_STR);
$update_decval->bindParam(':decval', $decval, PDO::PARAM_INT);
$update_decval->bindParam(':decval', $decval);
It seems the problem is with the database type decimal
? Is there a PDO::PARAM
for a field of type decimal
? If not, what do I use as a workaround?
© Stack Overflow or respective owner