Re: escaping values (DBD::mysql)

2005-08-01 Thread Jeff 'japhy' Pinyan
On Jul 31, Octavian Rasnita said: select ... limit 0,30; but I cannot use: $sth = $dbh-prepare(select ... limit ?,?); $sth-execute(0, 30); ... because DBI replaces the values entered with '0' and '30' and the query won't be valid. No, you probably can't do that because your SQL engine

escaping values (DBD::mysql)

2005-07-31 Thread Octavian Rasnita
Hi, I want to use a query like: select ... limit 0,30; but I cannot use: $sth = $dbh-prepare(select ... limit ?,?); $sth-execute(0, 30); ... because DBI replaces the values entered with '0' and '30' and the query won't be valid. Is there a method to escape the values entered directly, and