%s shortcut?

[james_027]

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