ok, I just figured out that you can print out a select object and get the
query it creates.
Which makes this odd:
$select->from('lyricstest', 'id');
$select->order('id');
$select->limit(0,5);
error_log("the executed sql is " . $select);
log shows the statement it creates with _no limit_ clause :
the executed sql is SELECT
`lyricstest`.`id`
FROM `lyricstest`
ORDER BY
`id` ASC
[12-Aug-2007 04:53:30] PHP Warning: PDO::quote() expects parameter 1 to be
string,
How do I get a limit?
I need a scrolling result set.
Thanks,
Vinny
--
Ghetto Java: http://www.streetprogrammer.com
