Re: Inserting into BLOBS

Lou Person <lperson@mcny.com> wrote in article <5l7uh4$d87@cssun.mathcs.emory.edu>... > We have looked at it, and it worked. > We also read in the documentation that it > works quite well for everything except > UPDATES. I was hoping that someone might > have come up with a quick fix, as we are new to > this list. > > Thank you, > > Lou Person > lperson@mcny.com > > -----Original Message----- > From: Jonathan Leffler [SMTP:johnl@informix.com] > Sent: Monday, May 12, 1997 3:45 PM > To: informix-list@rmy.emory.edu; lperson@mcny.com > Subject: Re: Inserting into BLOBS > > >From: "Lou Person" <lperson@mcny.com> > >Date: 12 May 1997 02:46:06 GMT > >X-Informix-List-Id: <news.37835> > > > >We are trying to insert into BLOBS > >using DBD/DBI. Does anyone have experience > >inserting or updatting BLOB fields using > >the perl libraries DBD/DBI to access Informix? > > I hate to be obnoxious, but have you looked at the blob test code? Its in > the files t/blob0?.t under the directory where you built the DBD::Informix > software. And have you read the documentation... > > Yours, > Jonathan Leffler (johnl@informix.com) #include <witticism.h> > > > I am not sure if this will help, but perl 4.036 'perlsql' code for Informix had a subtle bug (an index incremented in 'for' loop control part, in stead if body), that prevented it to work with blobs. I don't remember execactly, but I can take a look. The point is that the code is quite well organised and commented, so it should be relatively easy to drop around few debugging messages and see what is happening (if there indeed is a problem with this, as far as I understand, perl 5 code). IAATADNHM (I am affraid this actually doesn't help much) -- Dragi "Bonzi" Raos 4-MATE Information Engineering (http://www.4mate.hr) Zagreb, Croatia