while not answering your select question, check out crud.archive: http://web2py.com/book/default/chapter/07?search=archive
it's pretty slick and does the archiving for you automagically. now your query is still a problem....
while not answering your select question, check out crud.archive: http://web2py.com/book/default/chapter/07?search=archive
it's pretty slick and does the archiving for you automagically. now your query is still a problem....