Propel has a setDistict() method for propel that returns objects, I have only used it a couple times and have been looking for distinctness across the board of my query. I have only gone to creole once for queries so I don't know how to turn them into array of objects. The first tutorial is what I needed to figure out what I used.
A quick tutorial http://stereointeractive.com/blog/2007/12/13/propel-set-distinct-setdistinct/ And an answer to how to specificy distinct on a specific column in the return set. http://www.symfony-project.org/forum/index.php/m/1248/ These should help. James On Sep 28, 2008, at 7:18 AM, Atif Khan wrote: > > Does propel support distinct queries or do I have to go to creole.\ > If I do have to go to creole how can perform the normal > hydration and return objects instead of looping through a result set > and returning an array? > > The example I saw did a raw query with > distinct and then looped through a result set and then hydrated using > retrievebyPk... Is there a better way to do it then this... > > Thanks > Atif > > > > James wrote: >> >> user propel's "setDisctinct();" method. >> >> james >> >> >> On Sep 27, 2008, at 9:43 PM, Atif Khan wrote: >> >>> >>> Hello how can I create below in propel. >>> I cannot seem to get this right. >>> >>> select distinct(ev_c),ev_n, ev_d from tf where e_n like '%xyz%'; >>> >>> >>> Thank you >>> Atif >>> >>> >>> >> >> >>> > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "symfony users" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en -~----------~----~----~----~------~----~------~--~---
