They are all field that are in my model. I could access all the data with DM or raw SQL.
find_by_sql seems like the ticket. Thanks a million especially for the 0 second response. :) On Dec 1, 10:03 am, Mark Richman <[email protected]> wrote: > The find_by_sql method only works if all the columns from your > arbitrary query are mapped/mappable to your model's DM properties, no? > The DataMapper::Collection will be an array of your Model, as opposed > to what I did above. I'm not saying I'm more correct, but if you have > results that don't cleanly map to your Model's DM properties, it's an > option. > > On Dec 1, 9:55 am, Ted Han <[email protected]> wrote: > > > > > > > > > Check out the find_by_sql method in dm-ar-finders. > > > This is exactly what find_by_sql does. > > > On Wed, Dec 1, 2010 at 9:33 AM, dev2 <[email protected]> wrote: > > > I have a very complex query that runs much more efficiently with > > > direct repository access. So it returns a Struct which makes sense, > > > but that means my views that use that data have to process as an array > > > instead of a DataMapper object. It would be nice if I could convert > > > the Struct to a DataMapper object to have consistency in my views. > > > > Any advice/ideas/etc? > > > > Thanks! > > > > -- > > > You received this message because you are subscribed to the Google Groups > > > "DataMapper" group. > > > To post to this group, send email to [email protected]. > > > To unsubscribe from this group, send email to > > > [email protected]<datamapper%2bunsubscr...@googlegrou > > > ps.com> > > > . > > > For more options, visit this group at > > >http://groups.google.com/group/datamapper?hl=en. -- You received this message because you are subscribed to the Google Groups "DataMapper" 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/datamapper?hl=en.
