Scaricare un file memorizzato su un campo blob

"'Puglia Marco' [email protected] [cfmentor]" <[email protected]> Thu, 11 Sep 2014 12:52:59 +0200
Newsgroups gmane.comp.cms.cold-fusion.devel.italian
Message-ID <28CCFBE04D70AC47A1CE899BDF82809F0376875E@bera-mail.businesse.local>
------_=_NextPart_001_01CFCDAE.7DF0C66E
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Eccomi di  nuovo con un'altra domanda.

All'interno di un database Oracle, ho una tabella con un campo blob.

Sono riuscito a memorizzare il file all'interno del campo, ma ora non riesc=
o a leggerlo e consentire il download dello stesso.

=20

Che tecnica mi consigliate?

Grazie

=20

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D
Marco Puglia
Project Manager
Business-e S.p.A. <http://www.business-e.it/>  (an Itway Group Company)

Via F.lli Lumi=E8re, 65 - 48010 Ravenna

Tel. +39 0544.460413 - Fax +39 0544.272297

Cell. 348 4759233


Italy, France, Spain, Portugal, Greece, Turkey=20
Ravenna, Milano, Trento, Bari, Massa, Roma
Paris, Barcelona, Madrid, Lisboa, Athina, Istanbul, Ankara
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D

=20


------_=_NextPart_001_01CFCDAE.7DF0C66E
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable





<head>

<style type=3D"text/css">
<!--

/* start of attachment style */
       .ygrp-photo-title{
         clear: both;
         font-size: smaller;
         height: 15px;
         overflow: hidden;
         text-align: center;
         width: 75px;
       }
       div.ygrp-photo{
         background-position: center;
         background-repeat: no-repeat;
         background-color: white;
         border: 1px solid black;
         height: 62px;
         width: 62px;
       }

       div.photo-title=20
         a,
         div.photo-title a:active,
         div.photo-title a:hover,
         div.photo-title a:visited {
           text-decoration: none;=20
       }

       div.attach-table div.attach-row {
         clear: both;
       }

       div.attach-table div.attach-row div {
         float: left;
         /* margin: 2px;*/
       }

       p {
         clear: both;
         padding: 15px 0 3px 0;
	 overflow: hidden;
       }

       div.ygrp-file {
         width: 30px;
         valign: middle;
       }
       div.attach-table div.attach-row div div a {
         text-decoration: none;
       }

       div.attach-table div.attach-row div div span {
         font-weight: normal;
       }

       div.ygrp-file-title {
         font-weight: bold;
       }
 /* end of attachment style */
        -->
        </style>
        </head>
<html xmlns:v=3D"urn:schemas-microsoft-com:vml" xmlns:o=3D"urn:schemas-micr=
osoft-com:office:office" xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" xmlns=3D"http:=
//www.w3.org/TR/REC-html40"><head><meta http-equiv=3DContent-Type content=
=3D"text/html; charset=3Diso-8859-1"><meta name=3DGenerator content=3D"Micr=
osoft Word 14 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
	{font-family:"Cambria Math";
	panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
	{font-family:Calibri;
	panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
	{font-family:Verdana;
	panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0cm;
	margin-bottom:.0001pt;
	font-size:11.0pt;
	font-family:"Calibri","sans-serif";
	mso-fareast-language:EN-US;}
a:link, span.MsoHyperlink
	{mso-style-priority:99;
	color:blue;
	text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
	{mso-style-priority:99;
	color:purple;
	text-decoration:underline;}
span.StileMessaggioDiPostaElettronica17
	{mso-style-type:personal-compose;
	font-family:"Calibri","sans-serif";
	color:windowtext;}
.MsoChpDefault
	{mso-style-type:export-only;
	font-family:"Calibri","sans-serif";
	mso-fareast-language:EN-US;}
@page WordSection1
	{size:612.0pt 792.0pt;
	margin:70.85pt 2.0cm 2.0cm 2.0cm;}
div.WordSection1
	{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext=3D"edit">
<o:idmap v:ext=3D"edit" data=3D"1" />
</o:shapelayout></xml><![endif]--></head><body lang=3DIT link=3Dblue vlink=
=3Dpurple>


<!-- |**|begin egp html banner|**| -->

<br><br>

<!-- |**|end egp html banner|**| -->


<div class=3DWordSection1><p class=3DMsoNormal>Eccomi di=A0 nuovo con un&#8=
217;altra domanda.<o:p></o:p></p><p class=3DMsoNormal>All&#8217;interno di =
un database Oracle, ho una tabella con un campo blob.<o:p></o:p></p><p clas=
s=3DMsoNormal>Sono riuscito a memorizzare il file all&#8217;interno del cam=
po, ma ora non riesco a leggerlo e consentire il download dello stesso.<o:p=
></o:p></p><p class=3DMsoNormal><o:p>&nbsp;</o:p></p><p class=3DMsoNormal>C=
he tecnica mi consigliate?<o:p></o:p></p><p class=3DMsoNormal>Grazie<o:p></=
o:p></p><p class=3DMsoNormal><o:p>&nbsp;</o:p></p><p class=3DMsoNormal><spa=
n style=3D'font-size:7.5pt;font-family:"Verdana","sans-serif";color:#1F497D=
;mso-fareast-language:IT'>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D<br></span><b><span style=
=3D'color:#1F497D;mso-fareast-language:IT'>Marco Puglia<br></span></b><i><s=
pan style=3D'color:#1F497D;mso-fareast-language:IT'>Project&nbsp;Manager<br=
></span></i><b><span style=3D'color:navy;mso-fareast-language:IT'><a href=
=3D"http://www.business-e.it/"><span style=3D'color:blue'>Business-e S.p.A.=
</span></a></span></b><span style=3D'color:#1F497D;mso-fareast-language:IT'=
> </span><span style=3D'color:navy;mso-fareast-language:IT'>(an Itway Group=
 Company)<br><br></span><span style=3D'color:#1F497D;mso-fareast-language:I=
T'>Via F.lli Lumi=E8re, 65 - 48010 Ravenna<o:p></o:p></span></p><p class=3D=
MsoNormal><span style=3D'color:#1F497D;mso-fareast-language:IT'>Tel. +39 05=
44.460413 - Fax +39 0544.272297<o:p></o:p></span></p><p class=3DMsoNormal><=
span style=3D'color:#1F497D;mso-fareast-language:IT'>Cell. 348 4759233<o:p>=
</o:p></span></p><p class=3DMsoNormal><span style=3D'color:#1F497D;mso-fare=
ast-language:IT'><br></span><b><span style=3D'font-size:7.5pt;font-family:"=
Verdana","sans-serif";color:#1F497D;mso-fareast-language:IT'>Italy</span></=
b><span style=3D'font-size:7.5pt;font-family:"Verdana","sans-serif";color:#=
1F497D;mso-fareast-language:IT'>, <b>France</b>, <b>Spain</b>, <b>Portugal,=
 Greece, Turkey</b> <br>Ravenna, Milano, Trento, Bari, Massa, Roma<br>Paris=
, Barcelona, Madrid, Lisboa, Athina, Istanbul, Ankara<br>=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D</span><span style=3D'color:#1F497D;mso-fareast-language:IT'><o:p></o:p>=
</span></p><p class=3DMsoNormal><o:p>&nbsp;</o:p></p></div>



<!-- |**|begin egp html banner|**| -->

<br>


<br>

<!-- |**|end egp html banner|**| -->


<div width=3D"1" style=3D"color: white; clear: both;"/>__._,_.___</div>

=20=20=20=20=20=20
=20=20

=20=20=20=20
    <div id=3D"fromDMARC" style=3D"clear:both; margin-top: 10px;">
         <hr style=3D"height:2px ; border-width:0; color:#E3E3E3; backgroun=
d-color:#E3E3E3;">
         Inviato da: &quot;Puglia Marco&quot; &lt;[email protected]=
t&gt;         <hr style=3D"height:2px ; border-width:0; color:#E3E3E3; back=
ground-color:#E3E3E3;">
    </div>
<!-- Start Recommendations -->
<!-- End Recommendations -->


<!-- |**|begin egp html banner|**| -->

<br><br>
<tt>
CFMentor<BR>
<a href=3D"http://www.cfmentor.com">http://www.cfmentor.com</a></tt>
<br><br>

<!-- |**|end egp html banner|**| -->



<!-- |**|begin egp html banner|**| -->

  <img src=3D"http://geo.yahoo.com/serv?s=3D97490485/grpId=3D170861/grpspId=
=3D559000199/msgId=3D41903/stime=3D1410432814" width=3D"1" height=3D"1"> <b=
r>

<!-- |**|end egp html banner|**| -->

=20=20=20=20
<!-- |**|begin egp html banner|**| -->

<br>



=20=20=20
=20=20=20=20=20
=20
        <!-- |**|begin egp html banner|**| -->
        <div id=3D"ygrp-vital" style=3D"background-color: #f2f2f2; font-fam=
ily: Verdana; font-size: 10px; margin-bottom: 10px; padding: 10px;">

        <span id=3D"vithd" style=3D"font-weight: bold; color: #333; text-tr=
ansform: uppercase; "><a href=3D"https://it.groups.yahoo.com/neo/groups/cfm=
entor/info;_ylc=3DX3oDMTJjNDJyamFtBF9TAzk3NDkwNDg3BGdycElkAzE3MDg2MQRncnBzc=
ElkAzU1OTAwMDE5OQRzZWMDdnRsBHNsawN2Z2hwBHN0aW1lAzE0MTA0MzI4MTQ-" style=3D"t=
ext-decoration: none;">Visita il tuo gruppo</a></span>

     <ul style=3D"list-style-type: none; margin: 0; padding: 0; display: in=
line;">
                                                    </ul>
  </div>


<div id=3D"ft" style=3D"font-family: Arial; font-size: 11px; margin-top: 5p=
x; padding: 0 2px 0 0; clear: both;">
  <a href=3D"https://it.groups.yahoo.com/neo;_ylc=3DX3oDMTJianA0M2ZoBF9TAzk=
3NDkwNDg1BGdycElkAzE3MDg2MQRncnBzcElkAzU1OTAwMDE5OQRzZWMDZnRyBHNsawNnZnAEc3=
RpbWUDMTQxMDQzMjgxNA--" style=3D"float: left;"><img src=3D"http://l.yimg.co=
m/ru/static/images/yg/img/email/new_logo/yahoo_groups_it-IT_135x19.png" hei=
ght=3D"19" width=3D"135" alt=3D"Yahoo! Gruppi" style=3D"border: 0;"/></a>
  <div style=3D"color: #747575; float: right;"> &bull; <a href=3D"https://i=
nfo.yahoo.com/privacy/it/yahoo/groups/details.html" style=3D"text-decoratio=
n: none;">Privacy</a> &bull; <a href=3D"mailto:cfmentor-unsubscribe@yahoogr=
oups.com?subject=3DAnnulla iscrizione" style=3D"text-decoration: none;">Ann=
ulla iscrizione</a> &bull; <a href=3D"https://info.yahoo.com/legal/it/yahoo=
/tos.html" style=3D"text-decoration: none;">Condizioni generali di utilizzo=
 del servizio</a> </div>
</div>

<!-- |**|end egp html banner|**| -->

  </div> <!-- ygrp-msg -->

=20=20=20


  <br>

<!-- |**|end egp html banner|**| -->


<div style=3D"color: white; clear: both;"/>__,_._,___</div>
</body></html>
------_=_NextPart_001_01CFCDAE.7DF0C66E--