Re: [SQLObject] Error writing binary data to a blob

2009-07-28 Thread Aaron Robinson
Hi Oleg, That's terrific - thanks very much for your response. First off, the point you raised about setting many values at once; yes, I was aware of this, but a lot of the things we seem to want to do are more like we have a dict with strings for keys and associated values, and we want to write

Re: [SQLObject] Error writing binary data to a blob

2009-07-24 Thread Oleg Broytmann
On Fri, Jul 24, 2009 at 12:31:02PM +1200, Aaron Robinson wrote: > if I set the value of a blob column by setting a > varialbe on my object, it gets written to the db just fine, but when I do it > inside a transaction using sqlbuilder I have the error. Please see the code > below. > > Test Code: >

Re: [SQLObject] Error writing binary data to a blob

2009-07-23 Thread Aaron Robinson
Hi Oleg, Thanks for your quick response. In writing a short test program I think I may have come across the problem, although again I'm not familiar enough with SQLObject to know where to from here... It seems that if I set the value of a blob column by setting a varialbe on my object, it gets wri

Re: [SQLObject] Error writing binary data to a blob

2009-07-23 Thread Oleg Broytmann
On Thu, Jul 23, 2009 at 04:54:11PM +1200, Aaron Robinson wrote: > I'm wanting to write some binary data to the database - specifically the > data is produced by something like: > array.array('H',[1,2,3]).tostring() > and the database is Postgres 8.3 with a sqlobject.BLOBCol(default=None) > colu

[SQLObject] Error writing binary data to a blob

2009-07-22 Thread Aaron Robinson
Hi All, I'm new to SQLObject, but have picked through the documentation as much as possible and done numerous searches and am still at a loss... I'm wanting to write some binary data to the database - specifically the data is produced by something like: array.array('H',[1,2,3]).tostring() and