On Apr 23, 2010, at 3:09 AM, Chris Withers wrote: > I can't reconcile your comment with mine... > > ...I want to limit the results returned to those matching a set of ids. > This isn't about storing schemaless content ;-) > > Any serious ideas or should I just go sulk in the corner?
you have to use IN, and you have to generate the SQL every time based on the number of values you'd like to put into the IN. > > Chris > > Michael Bayer wrote: >> yeah man , this is why we're all moving to mongodb .... :) >> On Apr 15, 2010, at 10:46 AM, Chris Withers wrote: >>> Michael Bayer wrote: >>>> you have to rewrite your SQL to support the number of values in the IN >>>> clause for each parameter set. >>> Hmm :'( >>> >>> While my code knows the number of values, they don't, and it may vary from >>> when they write the SQL to when that SQL gets executed by my code... >>> >>> Chris >>> >>> -- >>> You received this message because you are subscribed to the Google Groups >>> "sqlalchemy" group. >>> To post to this group, send email to sqlalch...@googlegroups.com. >>> To unsubscribe from this group, send email to >>> sqlalchemy+unsubscr...@googlegroups.com. >>> For more options, visit this group at >>> http://groups.google.com/group/sqlalchemy?hl=en. >>> > > -- > Simplistix - Content Management, Batch Processing & Python Consulting > - http://www.simplistix.co.uk > > -- > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To post to this group, send email to sqlalch...@googlegroups.com. > To unsubscribe from this group, send email to > sqlalchemy+unsubscr...@googlegroups.com. > For more options, visit this group at > http://groups.google.com/group/sqlalchemy?hl=en. > -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalch...@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.
