Hi I want to use the prepare statement with a placeholder in the LIMIT clause like this
$sth = $dbh->prepare("select col1,col2 from tablename limit ?");
$sth->param_bind(1,$i,{TYPE => 'SQL_NUMERIC' });
$sth->execute();
I get an error message saying that "you have an error at limit '0' ...."
The value I'am passing to the place holder is binded as character embedded in
single quotes.
how can I make the value passed to the place holder remain as numeric,without
any quotes.
thanx
phani
