[fw-general] Hiya - new - sql IN statements

[Mark Steudel]

Hi there,

 

New to the list and to Zend. I've primarily been using PEAR packages in the
past, but am switching to Zend. I love the fact that it's a glue stack
versus full stack and I can just implement classes as needed before jumping
all in.

 

Anyway my first question is:

 

What is the best way to run this sql statement

 

$sql = "SELECT id FROM table WHERE id IN ( ? )"';

 

I tried doing:

 

$ids = '1,2';

 

$res = $db->quoteInto( $sql, $ids );

 

or

 

$res = $db->fetchAll( $sql, $ids );

 

But instead I get my sql statement returned to me.

 

Thanks, Mark