asp & oracle & blob & image

From: Arslan <lara0_at_caramail.com>
Date: 2000/03/25
Message-ID: <8bivjf$pp3$1@reader1.fr.uu.net>#1/1

hi
any sample to put binary file into BLOB column from ASP ?

i succeed to get the image from a input type=file FORM and o convert it into binary object
(i can show it in a html file later) but when i want to insert into the table i dont know how to do it

<%

 set serveurOracle = server.createobject("OracleInProcServer.XOraSession")
 set connexion     = serveurOracle.dbopendatabase("", "scott/tiger",0)
 requete_saisie    = "insert into table (BLOBcolumn)
values('"+the_image+"')"
 rc                =  connexion.dbexecutesql(requete_saisie)

 set serveurOracle = Nothing
%>

the_image is a binary content type variable but i have to merge it with a variable text which is the query to parse

thnx Received on Sat Mar 25 2000 - 00:00:00 CST