hi

there is a problem when i try to reset a query for in the followig code

$query = new Doctrine_Query();
$cars = $query->select('c.*, RANDOM() rand')->from('Car c')->where('c.special_offer = ?', array(true))->orderBy('rand')->limit(5)->execute();
$query->reset();
$brands = $query->select('b.*')->from('Brand b')->where('b.disabled = ? or b.disabled IS NULL', array(false))->execute();

i get the following exception: Unknown aggregate alias: rand

also the limit needs to be reseted

thanx