Web2py DAL is Freaking Best Piece of Software Ever come into existance :) !
" Use it , You Must! " On Sat, Oct 8, 2011 at 9:54 PM, Chris Rowson <christopherrow...@gmail.com>wrote: > Thanks Massimo, > > I'm very new at this and found the DAL a bit intimidating. I'm > beginning to get the hang of it now though so I'm sticking with it. I > think I was trying to overthink it before when in actual fact, the > more I try and get my head around it, the more sense it makes. > > Chris > > On Sat, Oct 8, 2011 at 4:19 PM, Massimo Di Pierro > <massimo.dipie...@gmail.com> wrote: > > You don't mind to write engine specific queries but who is going to > > use your app will mind because the app is not going to be portable. > > Almost any query an be build using the dal. > > > > Massimo > > > > On Oct 8, 6:20 am, Chris Rowson <christopherrow...@gmail.com> wrote: > >> Call me wierd, but I'm finding it a little hard to get my head around > >> putting together select statements using the DAL. I think I must just > >> be having a stupid couple of weeks! > >> > >> I understand that using the DAL & SQLFORM etc for inserts will help > >> protect me against SQL Injection so I'm happy to keep on doing that, > >> but is there any particular reason I shouldn't just use db.executesql > >> to perform my selects (because I find it easier)? > >> > >> I also understand that raw SQL queries are database specific but I > >> don't mind, as I don't intend to move databases. > >> > >> Chris >