Andy Grover <[EMAIL PROTECTED]> writes: > Jorge Godoy wrote: >> I'm trying to write a query that will generate SQL like: >> SELECT * FROM table WHERE id IN (1, 2, 3); > > from sqlobject import IN
Hmmm... This is why I missed IN. I was looking at sqlobject.sqlbuilder... :-\ It is available there as well, but undocumented. > amostras_ids = [(amostra.id) for amostra in amostras] > > if amostras_ids: > resultados = > model.VAuditoriaResultado.select(IN(model.VAuditoriaResultado.q.amostraID, > amostras_ids)) > > Does that work? Yes. You an Oleg were right. Thanks. -- Jorge Godoy <[EMAIL PROTECTED]> ------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ sqlobject-discuss mailing list sqlobject-discuss@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
