On Thu, Nov 29, 2007 at 04:05:55AM +0100, Bart wrote: > Ah, you inserted it with something other than SQLObject then fetched > it with SQLObject?
No. The program that I have posted is a complete program - it INSERTs a huge BLOB and fetches it back. Works for for both BLOBCol and PickleCol. > I've been hacking in my sqlobject installation to convert it from > literal to parameter style. I had been converting SQLObject to paramstyles queries in this branch: http://svn.colorstudy.com/home/phd/SQLObject/paramstyles/ but stopped working on it for two reasons: -- different DB API drivers have different problems converting some datatypes; some choked on mxDateTime, some on datetime, etc. -- Luke Opperman reworked SQLObject in the trunk unifying SQLObject.select(), sqlbuilder.Select() and dbConnection.queryForSelect(); by itself it is a great job (will be in SQLObject 0.10); but it is incompatible with what I was doing for parameterized queries, so I have to start almost from beginning. > It seems to work, but there's probably a > reason SQLObject uses literal instead of parametric queries There is one - datatypes problem. Ian Bicking started SQLObject long ago, when DB API drivers were even worse than now. > It just occurred to me that for my project at least, it would probably > be cleaner to just add my own wrapping code that just updates the > database without SQLObject knowing about it. Don't forget about cache coherency problem. Oleg. -- Oleg Broytmann http://phd.pp.ru/ [EMAIL PROTECTED] Programmers don't die, they just GOSUB without RETURN. ------------------------------------------------------------------------- SF.Net email is sponsored by: The Future of Linux Business White Paper from Novell. From the desktop to the data center, Linux is going mainstream. Let it simplify your IT future. http://altfarm.mediaplex.com/ad/ck/8857-50307-18918-4 _______________________________________________ sqlobject-discuss mailing list sqlobject-discuss@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
