Note, if you want help generating some SQL that you will then tweak, you can use the DAL's _select(), _insert(), _update(), and _delete() methods -- all of which generate and return the relevant SQL without actually executing it.
Anthony On Thursday, January 3, 2013 3:39:30 PM UTC-5, Paul Rykiel wrote: > > I must of missed this ...thank you! I think this will do the trick. I hate > writing SQL in general, but as long as I know what to do I am good to go. > Thanks, > > On Thursday, January 3, 2013 2:22:06 PM UTC-6, Jim S wrote: > >> There is a section in the book on it... >> >> http://web2py.com/books/default/chapter/29/06#Raw-SQL >> >> -Jim >> >> On Thursday, January 3, 2013 2:14:05 PM UTC-6, Paul Rykiel wrote: >>> >>> Hello, >>> Are there any reference guides to build SQL statements in Web2py? >>> >> --