note
Xaositect
<p>Well, the variable being bound incorrectly is the second ($start_item) not the first ($self->param('catalog_id')). However, the ideas hold true. I did try:</p>
<code>
$sth -> execute(
$self -> param('catalog_id'),
0 + $start_item,
20
);
</code>
<p>without success. Also <code>$start_item + 0</code> and <code>int($start_item)</code>. I just tried the specific type binding you recommended, and that did work:</p>
<code>
$sth->bind_param(1, $self->param('catalog_id'), SQL_INTEGER);
$sth->bind_param(2, $start_item, SQL_INTEGER);
$sth->bind_param(3, 20, SQL_INTEGER);
$sth->execute();
</code>
<p>This leads me to believe I am experiencing a bug in DBI. (My database is MySQL.) However, this still begs the question, how is DBI evaluating the result of <code>int($start_item)</code> differently than the <code>$this_stupid_counter</code> above? </p>
231691
231703