+1 for Marin's answer, as it doesn't care which database engine you use. In my opinion it's worth learning the DAL syntax because it abstracts the underlying database.
On Aug 7, 10:37 am, 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
