Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> asp & oracle & blob & image
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