$table->find('username = :name AND password = :pass',
array(':name'=>$name, ':pass'=>$pass));
$table->find('username = ? AND password = ?', array($name, $pass));
$table->find('username = ? AND password = ?', $name, $pass);
$criteria is of TSqlCriteria
$table->find($criteria); //the 2nd parameter for find() is ignored.
public function find($criteria, $parameters = array())
{
$args = func_num_args() > 1 ? array_slice(func_get_args(), 1) : null;
$criteria = $this->getCriteria($criteria, $parameters, $args);
return $this->getCommand()->find($criteria);
}