I Want To Use A Sql Function Or Perform Calculations In A Statement I

1.	I Want To Use A Sql Function Or Perform Calculations In A Statement I'm Generating With Zend_db_select. How Can I Do This?
Answer» Actually, by DEFAULT, If your expression Includes parentheses, Zend Db Select will cast the statement APPROPRIATELY. However, If It does not, oryou are having problems, you can use Zend_Db_Exprto explicitly create the expression: /‘ Build the SQL: * SELECT p.”product_jd”, p.cost * 1.08 AS cost_plus_tax * FROM “PRODUCTS “ AS p $select = $db-->select() ->from(array(’p’ =>’products’), array( product_id’, ‘cost_plus_tax’ => NEW Zend_Db_Expr(‘p.cost * l.08’), )); Actually, by default, If your expression Includes parentheses, Zend Db Select will cast the statement appropriately. However, If It does not, oryou are having problems, you can use Zend_Db_Exprto explicitly create the expression:

I Want To Use A Sql Function Or Perform Calculations In A Statement I'm Generating With Zend_db_select. How Can I Do This?

Answer»

Actually, by DEFAULT, If your expression Includes parentheses, Zend Db Select will cast the statement APPROPRIATELY. However, If It does not, oryou are having problems, you can use Zend_Db_Exprto explicitly create the expression:

/‘ Build the SQL: * SELECT p.”product_jd”, p.cost * 1.08 AS cost_plus_tax * FROM “PRODUCTS “ AS p $select = $db-->select() ->from(array(’p’ =>’products’), array( product_id’, ‘cost_plus_tax’ => NEW Zend_Db_Expr(‘p.cost * l.08’), ));

Actually, by default, If your expression Includes parentheses, Zend Db Select will cast the statement appropriately. However, If It does not, oryou are having problems, you can use Zend_Db_Exprto explicitly create the expression:

Discussion

No Comment Found

Related InterviewSolutions

What Kind Of Contribution Requires That I Submit A Cla? And What Kind Of Contribution Can I Make Without Submitting A Cla?
I've Submitted The Cla Now How Can I Get Started Contributing To Zend Framework?
I Want To Use A Sql Function Or Perform Calculations In A Statement I'm Generating With Zend_db_select. How Can I Do This?
How Can I Add Extra Html (such As A Link) To My Form Element?
How Can I Detect If An Optional File Has Been Uploaded?
How Can I Make All I'll 8n-aware Components Aware Of My Zend_translate Object?
How Can I Use The Same Locale Everywhere?
Why Are My Dates Formatted Wrong? Why Do I Get The False Year Value?
How Can I Debug Zend_date In A Simple Way?
How Can I Retrieve The View Object Within A Plugin Or Arbitrary Code?