2009年12月18日星期五

[fw-db] Zend_Db_Select Question

begin:vcard
fn:Mark T. Dame
n:Dame;Mark
org:MFM Software, Inc.
adr;dom:;;11988 Tram Way;Cincinnati;OH;45241
email;internet:mdame@mfm.com
title:VP, Product Development
tel;work:1-513-618-5232
url:http://www.mfm.com/
version:2.1
end:vcard

I've done a bunch of searching on the Internet and in the e-mail archives and can't find the answer to this.  How do you model a query like this using Zend_Db_Select?

SELECT col_a, col_b, col_c, 'Some Value' AS col_d
  FROM table_z

or event SELECT *, 'Some Value' AS col_d ...

I've tried code like this in a Zend_Db_Table class:

  $select = $this->select();   $select->from($this->name, array('*', 'col_d' => '"Some Value"'));  
and several variations including escaping the quotes.  Is this even possible?  If not, any suggestions for a workaround?

TIA!


-m
--
MFM Software, Inc Mark T. Dame <mdame@mfm.com>
VP, Product Development
MFM Software, Inc. (http://www.mfm.com/)
"As a rule, software systems do not work well until they have been
 used, and have failed repeatedly, in real applications."
     -- Dave Parnas

没有评论: