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
