[sqlalchemy] Re: Help Writing Portable Query

2009-10-28 Thread Sir Rawlins
Hello Guys, Thanks to your both for your suggestion, they're of a great help. Michael, I see your point about this, seems there isn't going to be any way to create a truely portable version of the query, I'll just opt for a custom one for each build for now I think :-) Conor, your suggestion sol

[sqlalchemy] Re: Help Writing Portable Query

2009-10-27 Thread Michael Bayer
Sir Rawlins wrote: > > Hello Guys, > > I've got a query which I'm currently running as literal SQL against a > MySQL database. I'm looking to create a ported version of the query > for SQLite but am totally new to that platform so am looking for a > little help with my date/time functions, I'm hop

[sqlalchemy] Re: Help Writing Portable Query

2009-10-27 Thread Conor
Sir Rawlins wrote: > Hello Guys, > > I've got a query which I'm currently running as literal SQL against a > MySQL database. I'm looking to create a ported version of the query > for SQLite but am totally new to that platform so am looking for a > little help with my date/time functions, I'm hopin