Organizational Research By

Surprising Reserch Topic

Experts Most Trusted Topic


pdoparam for type decimal


pdoparam for type decimal  using -'php,mysql,database,pdo'

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?
    

asked Sep 14, 2015 by VidaRendall
0 votes
6 views



Related Hot Questions



Walkin Jobs Opening



Government Jobs Opening


...