[sqlalchemy] Re: Unsupported Type

2009-11-03 Thread Sir Rawlins
Hey Wichert, Thanks for the excellent advice! this appears to work perfectly! Thanks, Rob On 2 Nov, 14:19, Wichert Akkerman wich...@wiggy.net wrote: On 11/2/09 14:04 , Sir Rawlins wrote: Hello Guys, I'm getting an exception thrown when trying to save an entity into a SQLite

[sqlalchemy] Unsupported Type

2009-11-02 Thread Sir Rawlins
Hello Guys, I'm getting an exception thrown when trying to save an entity into a SQLite database, this is a database/app which has been ported over from a MySQL backend. The exception looks like this: InterfaceError: (InterfaceError) Error binding parameter 0 - probably unsupported type.

[sqlalchemy] Re: Help Writing Portable Query

2009-10-28 Thread Sir Rawlins
solutions seem to work nicely, I've placed those into a query an upon my initial tests it appears to be returning the data that I would expect. Cheers guys, Rob On 27 Oct, 15:35, Michael Bayer mike...@zzzcomputing.com wrote: Sir Rawlins wrote: Hello Guys, I've got a query which I'm currently

[sqlalchemy] Help Writing Portable Query

2009-10-27 Thread Sir Rawlins
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 hoping someone here will have a