On Tue, 21 Jun 2005, Keith Jackson wrote:
> Is there a way to assign the data type by column, then doing the execute
> with the value?
Yup, you can use the standard bind_param and the use execute() in your loop
like this:
$sth->bind_param(1, undef, SQL_INEGER);
>
> foreach (@( $myArrayHash) ){
# the $sth->bind_param(1, undef, SQL_INTEGER) is sticky so this execute
# remembers and $myArrayHash{'min'} is bound as an integer.
> $sth->execute($myArrayHash{'min'},$myArrayHash{'code'});
> ....
> }
>
HTH,
-r