Re: asp & oracle & blob & image

From: <joer00_at_my-deja.com>
Date: 2000/04/11
Message-ID: <8cttiv$903$1@nnrp1.deja.com>#1/1

there are a few ways to do that,( i am using mssgl 7 but i think it;s the same with orcale)

you have to use the appendchunk method of the ado recordset. like
select picture,picturetext from pictures where picturetext="nothing"

rs.addnew
rs.("picturetext")=mytest
rs.("picture").appendchunk(picarray)
rs.update

however the best way is to make a small com. I got some great performance with an own comobject using ado's command object with the parameter collection and a stored procedure.

There are soem articles in the ms knwoledgebase and there is (like always) also an bug with the filesize, unfortunatley i do not know the Q number but you should be able to find it with keywoards binary data sql or image ,sql

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Apr 11 2000 - 00:00:00 CDT