[symfony-users] IF() in Propel query

2010-07-18 Thread HAUSa
Hi all, Is it possible to use IF() in a Propel query? I want a query like this: SELECT product.*, IF(MAX(bids.bid) product.price, MAX(bids.bid), product.price) as current_price FROM product LEFT JOIN bids ON (product.id = bids.product_id) Thank, hope that someone can help me. Looked

Re: [symfony-users] IF() in Propel query

2010-07-18 Thread Richard Zulu
Hi, I installed symfony 1.4.6. However, whenever i run the propel:build-sql command it doesn't generate my schema.sql file in the data directory. Am using Ubuntu and have phing active too. It gives me this output: php symfony propel:build-sql schemaconverting