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

1.	I Want To Use A Sql Function Or Perform Calculations In A Statement Fm 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, or you are having PROBLEMS, you can use Zend_Db_Expr to explicitly create the expression: * BUILD the SQL: SELECT p.product_Jd p.cost 1.08A5 costp/us_tax * FROM “products”AS p $se/ect $db->se/ect() ->from(array(‘p’=>‘products’), array( ‘product_id’, ‘cost_p/us_ TAX’>NEW Zendj2b_Expr(’p.cost*1.08), )); Actually, by default. if your expression includes parentheses, Zend_Db_Select will cast the statement appropriately. However, if it does not, or you are having problems, you can use Zend_Db_Expr to explicitly create the expression:

I Want To Use A Sql Function Or Perform Calculations In A Statement Fm 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, or you are having PROBLEMS, you can use Zend_Db_Expr to explicitly create the expression:

* BUILD the SQL: SELECT p.product_Jd p.cost 1.08A5 costp/us_tax * FROM “products”AS p $se/ect $db->se/ect() ->from(array(‘p’=>‘products’), array( ‘product_id’, ‘cost_p/us_ TAX’>NEW Zendj2b_Expr(’p.cost*1.08), ));

Actually, by default. if your expression includes parentheses, Zend_Db_Select will cast the statement appropriately. However, if it does not, or you are having problems, you can use Zend_Db_Expr to 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?