Oh... That simple... Well, I feel stupid now. I'll just go write my code, and hope my wife won't see it.
On Aug 7, 5:37 pm, Marin Pranjic <[email protected]> wrote: > Hi, > > you can do: > array = [1,3,6] > db(db.tablename.fieldname.belongs(array)).select(db.tablename.ALL) > > > > > > > > On Sun, Aug 7, 2011 at 3:05 PM, guruyaya <[email protected]> wrote: > > Hi guys. > > Is there a way to use a SELECT... IN... syntax in dal? Something like > > "SELECT * FROM auth_user WHERE id IN (1,3,6) > > If not, I'll explain my use case, and hope to get your best answer. > > > I have 2 dbs, one holds auth_user, the other holds some data (projects > > in this case), with the id of the user that created it. After > > selecting the all projects, I wanted to show who created them. I > > cannot use join, because they don't sit on the same database (and they > > cannot sit on the same database). My 2nd option, is to create an > > array, of all the users that created project, and match username with > > it's creator. That's not that bad, but I don't know how to use SELECT > > IN in dal. The 3rd option, is to query for each user. That makes me > > want to die, jst so I can roll in my grave. It creates so many unneded > > queries. On the other hand - that's excatly what I do, as the other > > options are immpossible, from where I stand. > > > Any ideas? > > > Thanks > > Yair
