推进创建查询中的多个变量

Question

According to the api (http://trac.propelorm.org/wiki/Documentation/1.6/ModelCriteria) I was searching for something like that:

$param1 = 5;
$param2 = 3;

select id, name from testtable where ((sin(?) * (cos(?));

equal to

select id, name from testtable where ((sin($param1) * (cos($param2));

How can I do this with propel? I only found a way to bind only 1 variable at once.

(I don't want to do a "AND" I just want to bind more than 1 variable)

From the docs, this is for binding one variable:

<?php
// Finding all Books where title = 'War And Peace'
$books = BookQuery::create()
  ->where('Book.Title = ?', 'War And Peace')
  ->find();
?>

Answer 1

Well I guess Propel works like Doctrine for this point, did you try :

$res = TestQuery::create()
  ->where('((sin(?) * (cos(?))', array($param1, $param2))
  ->find();

Ps: the link for documentation is so old, use the new one: http://www.propelorm.org/reference/model-criteria.html