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();
?>
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