Re: LIMIT and placeholders

2003-10-30 Thread Fagyal, Csongor
You have to use bind_param() to identify the parameter as an integer. Rudy Lippan, the author of DBD::mysql, had a message about it on the dbi-users list: Thanks Keith, that explains it... I do not like this new behaviour of DBD, though. I think it should be the other way around: let those w

Re: LIMIT and placeholders

2003-10-29 Thread Keith C. Ivey
On 29 Oct 2003 at 18:00, Fagyal, Csongor wrote: > Any ideas what causes this behaviour? Maybe I have not upgraded my DBI > & DBD packages properly? Or are LIMIT placeholders no longer supported > in DBI with MySQL 4? I don't think the MySQL version is relevant. The change is in DBD::mysql 2.900

LIMIT and placeholders

2003-10-29 Thread Fagyal, Csongor
Hi, This is rather a Perl DBI question than a MySQL one. I have recently upgraded a MySQL 3.23 server to 4.0. It resulted in some of my queries (issued using Perl DBI) starting to fail. It turned out to be that queries like $sth = $dbh->prepare("SELECT whatever FROM something WHERE anything L