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 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? Regards -- Andy ------------------------------------------------------------------------- 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
