Zikula Community

• bronto
  
  

  • Rank: Helper
  • Registered: Dec 31, 1969
  • Last visit: May 07, 2010
  • Posts: 507

  Posted: Sep 14, 2009 - 11:32 AM

  I need to do some grouping, it doesn't look like selectExpandedObjectArray supports this? Any recommendations?

  • 
  •  
• rgasch
  
  

  • Rank: Team Member
  • Registered: Jan 05, 2003
  • Last visit: May 28, 2010
  • Posts: 776

  Posted: Sep 14, 2009 - 08:46 PM

  Yes, you can trick DBUtil into doing this by passing your GROUP BY statement as part of the $where or $sort parameter. It's a bit hacky but it works ...
  
  The following applies to both $where and $sort: if what you pass in to these parameters does not start with "WHERE" or "ORDER BY" DBUtil will prepend these strings. As such, you can't pass in your GROUP BY statement into an otherwise empty $where/$sort.
  
  Greetings
  R

  • 
  •  
• bronto
  
  

  • Rank: Helper
  • Registered: Dec 31, 1969
  • Last visit: May 07, 2010
  • Posts: 507

  Posted: Sep 15, 2009 - 04:18 AM

  rgasch

  As such, you can't pass in your GROUP BY statement into an otherwise empty $where/$sort.
  

  
  
  In which case, you could apply further trickeration and pass WHERE 1 = 1.

  • 
  •  
• rgasch
  
  

  • Rank: Team Member
  • Registered: Jan 05, 2003
  • Last visit: May 28, 2010
  • Posts: 776

  Posted: Sep 15, 2009 - 09:23 AM

  Yes, that would do

  • 
  •  
•  
•  

Users on-line

• eledril

This list is based on users active over the last 60 minutes.