bind_param question

[Keith Jackson]

The following code works just fine:

$sth = $dbh->prepare(qq(select count(*) from discounts where min_value
< ?));
$sth->bind_param( 1, 5, SQL_INTEGER);
$sth->execute();

The actual query my application uses is much longer and the rest of the
values in the where clause are varchar's.

Is there a way to assign the data type by column, then doing the execute
with the value?

Something like this:

$sth = $dbh->prepare(qq(select count(*) from discounts where min_value
< ?));
$sth->bind_param(1, SQL_INTEGER);
$sth->execute(5);

This would help too if the execute is in a loop.

like this...

$sth = $dbh->prepare(qq(select count(*) from discounts where min_value
< ? and code=?));
$sth->bind_param(1, SQL_INTEGER);

foreach (@( $myArrayHash) ){
    $sth->execute($myArrayHash{'min'},$myArrayHash{'code'});
    ....
}


Any thoughts?