Hi @all, i have to solve a problem with doctrine which I normally would do with the mysql union function. Perhaps someone has an Idea for me, how I can do this:
I have a few tables whitch have the following setup: ------------------------------------------ table name: director first_name: string last_name: string name_slug: string ------------------------------------------ table name: actor first_name: string last_name: string name_slug: string ------------------------------------------ ... and so on. The tables contain different persons related to movies. For example: directors, screenwriters, actors, cutters and so on. Now, for a new function, i need to select all persons from all tables where last name ist starting with (for Example) A%, sortetd by last_name. How would you do the doctrine query? Perhaps I have to select the perons table per table and merge them later in arrays... and then write a sort function for the arrays? But somehow I dont like this way ;-) Any suggestions would be grat. Thanks, Kai --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
