Re: [fw-db] Need Help with Constructing an SQL Object

Try this:

$table = new MyTable();

$select = $table->select()->from($table, array('product' => '(a * b)'));

HTH

Nikolaos

On Tue, Dec 16, 2008 at 09:44, log2e <info@log2e.com> wrote:

I'm having a hard time translating this rather simple SQL statement into an
SQL object:

SELECT a*b AS product FROM table

I tried this but it doesn't work :

$table = new MyTable();
$select = $table->select()->from( $table, array('product' => 'a * b') );


Thanks for your help!



--
View this message in context: http://www.nabble.com/Need-Help-with-Constructing-an-SQL-Object-tp21033994p21033994.html
Sent from the Zend DB mailing list archive at Nabble.com.

--
The contents of this message may contain confidential or privileged information and is intended solely for the recipient(s). Use or distribution to and by any other party is not authorized. If you are not the intended recipient, copying, distribution or use of the contents of this information is prohibited.