I'm trying to do queries that match results on a lists of values. Ideally I would like to do something like this:
$id = array( 1, 2, 3, 6, 10 ); $sql = "select name from resource where id in ( ? )"; $rows = $db->fetchAll( $sql, $id ); and have that return the names of the rows who's ids are 1, 2, 3, 6, 10. When I try anything like this using Zend DB I get a "Invalid parameter number: number of bound variables does not match number of tokens" error. Is there a way to do this built into the db stuff or will I have to expand these arrays every time I want to use them in a statement like this? Thanks -- View this message in context: http://www.nabble.com/Passing-array-of-values-to-db-statement-tp15813319s16154p15813319.html Sent from the Zend Framework mailing list archive at Nabble.com.
