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

Reply via email to