RE: [Zope] Updating BLOB fields in Interbase database
I posted some stuff I was doing some time ago w/ mysql / blobs and zope some time ago so that my grandchildren could google for it :)... if you goggle for zope mysql blob bobb you'll get it. It's not interbase. hth bobb Also, your post came through as a newsgroup posting, which means I had to cut / paste / finagle the whole thing to reply... It's the first time I've ever seen that (I use m$ outlook express) How are you posting to here? (curious, that's all) "Ashley" <ashleylloyd@hotmail.com> wrote in message news:dcd0n1$ida$1@sea.gmane.org...
I'm not sure if this is the right place for this, if not, my apologies.
I've got a Clients table in an interbase db with various fields, one of which is a BLOB field (subtype text), used to maintain some notes.
When inserting a Client into the table, this field populates fine.
However, when attempting to update the client, for some reason, it won't. It just will not allow me to do an update with the notes field in the statement. I've googled around, and found lots of bits helping with Delphi, and lots of statements that BLOB fields in Interbase are tricky to update, but nothing that helps.
Has anyone out there found a way around this?
I'm using currently using gvib as my database adaptor, as kinterbase does not seem to want to install at all (seemingly problems with ldap ..).
My Zope instance is installed from a Plone installer. Zope Version (Zope 2.6.1 (binary release, python 2.1, win32-x86), python 2.1.3, win32) Python Version 2.1.3 (#35, Apr 8 2002, 17:47:50) [MSC 32 bit (Intel)] System Platform win32
Thanks in advance Ashley
_______________________________________________ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Hi bobb, thanks for your reply. If I found the right post (reading an image from blob in mysql and displaying it), then thanks very much but I don't think it'll apply too much to my situation. I can retrieve the contents of the blob field fine, its updating it that causes the problems. Thanks again, though. I posted directly out of Outlook Express, by the way, just hitting "New Post". Kind regards Ashley "bobb" <rawsystems@gmail.com> wrote in message news:009101c59513$c40d4b50$6400a8c0@rawlt1...
I posted some stuff I was doing some time ago w/ mysql / blobs and zope some time ago so that my grandchildren could google for it :)...
if you goggle for zope mysql blob bobb you'll get it. It's not interbase. hth
bobb
Also, your post came through as a newsgroup posting, which means I had to cut / paste / finagle the whole thing to reply... It's the first time I've ever seen that (I use m$ outlook express) How are you posting to here? (curious, that's all)
"Ashley" <ashleylloyd@hotmail.com> wrote in message news:dcd0n1$ida$1@sea.gmane.org...
I'm not sure if this is the right place for this, if not, my apologies.
I've got a Clients table in an interbase db with various fields, one of which is a BLOB field (subtype text), used to maintain some notes.
When inserting a Client into the table, this field populates fine.
However, when attempting to update the client, for some reason, it won't. It just will not allow me to do an update with the notes field in the statement. I've googled around, and found lots of bits helping with Delphi, and lots of statements that BLOB fields in Interbase are tricky to update, but nothing that helps.
Has anyone out there found a way around this?
I'm using currently using gvib as my database adaptor, as kinterbase does not seem to want to install at all (seemingly problems with ldap ..).
My Zope instance is installed from a Plone installer. Zope Version (Zope 2.6.1 (binary release, python 2.1, win32-x86), python 2.1.3, win32) Python Version 2.1.3 (#35, Apr 8 2002, 17:47:50) [MSC 32 bit (Intel)] System Platform win32
Thanks in advance Ashley
_______________________________________________ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
_______________________________________________ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
participants (2)
-
Ashley -
bobb