hi bjorn, > You could do [year]*12 + [order_by] like so: > > >>> [1970] * 12 + ['foo'] > > [1970, 1970, 1970, 1970, 1970, 1970, 1970, 1970, 1970, 1970, 1970, > 1970, 'foo'] > > > > I don't know which database you're using, but the above doesn't look > like SQL'92... >
Thanks, it works! I am using mysql 5, and it works (i am having a hard time with mysql's SP, firebird is very easy and nice) cheers, james -- http://mail.python.org/mailman/listinfo/python-list
