[web2py] Re: Capturing history of values in a field

2011-02-03 Thread DenesL
This might be doable by using _select (note the underscore) for the inner selection. Can you post the SQL command that you wish to accomplish?. On Feb 3, 2:14 pm, Philip philip.el...@gmail.com wrote: Here's an example of what I am trying to do - suppose I have an app that tracks a sales

[web2py] Re: Capturing history of values in a field

2011-02-03 Thread howesc
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

[web2py] Re: Capturing history of values in a field

2011-02-03 Thread Philip
Thanks - I haven't used _select - I'm checking into it now. Thanks, Philip On Feb 3, 2:54 pm, DenesL denes1...@yahoo.ca wrote: This might be doable by using _select (note the underscore) for the inner selection. Can you post the SQL command that you wish to accomplish?. On Feb 3, 2:14 pm,