Next

Accessing Data

Table of Contents

Limiting table columns to retrieve 
Limiting table columns to retrieve 
doSelectRS 
doSelectRS 
SUM() with Propel? 
SUM() with Propel? 
SUM() with Propel? 
SUM() with Propel? 

Limiting table columns to retrieve 

http://www.symfony-project.org/forum/index.php?t=msg&th=5337&

Listing 8-13 at http://www.symfony-project.org/book/trunk/08-Inside-the-Model-Layer#Retrieving%20Records%20with%20Criteria shows how to retrieve records by criteria with conditions.

However, I am not able to find the way how to limit the fields it returns. Is there any way to limit the fields of the doSelect returns?

Limiting table columns to retrieve 

You can do it with the Criteria object using clearSelectColumns() and adding the required columns back in. As Sephi77 said it won't return enough information to create a valid object so you can use MyPeer::doSelectRS() to return a result set. More info in the propel docs:

http://propel.phpdb.org/docs/api/current/runtime/propel.util/Criteria.html

documented on: 04 March 2007, mikenolan


SourceForge.net LogoXpt.SourceForge.netCreative Commons Attribution-ShareAlike License Del.icio.us digg FURL blinklist reddit Feed Me Links Technorati Stumble Upon Google Bookmarks Yahoo My Web Newsvine Socializer Ma.gnolia RawSugar Squidoo Spurl BlinkBits Netvouz Rojo Blogmarks Shadows Simpy Co.mments Scuttle Bloglines Tailrank Wists FARK smarking Segnalo
Single file version available here.
Last updated on 2008-05-28.
To discuss, comment here.
   Next