Re: Scaricare un file memorizzato su un campo blob

"Cristian Costantini [email protected] [cfmentor]" <[email protected]> Thu, 11 Sep 2014 14:24:21 +0200
Newsgroups gmane.comp.cms.cold-fusion.devel.italian
Message-ID <[email protected]>
--Apple-Mail=_D19103DE-E022-4784-B820-7942596F8536
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain;
	charset=windows-1252

Ciao,

hai provato in file?

Cristian

Il giorno 11/set/2014, alle ore 12:52, 'Puglia Marco' marco.puglia@business=
-e.it [cfmentor] <[email protected]> ha scritto:

>=20
> Eccomi di  nuovo con un=92altra domanda.
>=20
> All=92interno di un database Oracle, ho una tabella con un campo blob.
>=20
> Sono riuscito a memorizzare il file all=92interno del campo, ma ora non r=
iesco a leggerlo e consentire il download dello stesso.
>=20
>=20=20
>=20
> Che tecnica mi consigliate?
>=20
> Grazie
>=20
>=20=20
>=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. (an Itway Group Company)
>=20
> Via F.lli Lumi=E8re, 65 - 48010 Ravenna
>=20
> Tel. +39 0544.460413 - Fax +39 0544.272297
>=20
> Cell. 348 4759233
>=20
>=20
> 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
>=20=20
>=20
>=20
>=20


--Apple-Mail=_D19103DE-E022-4784-B820-7942596F8536
Content-Type: text/html; charset=windows-1252
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><head><meta http-equiv=3D"Content-Type" content=3D"text/html charset=
=3Dwindows-1252"></head><body style=3D"word-wrap: break-word; -webkit-nbsp-=
mode: space; -webkit-line-break: after-white-space;">


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

<br><br>

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


Ciao,<div><br></div><div>hai provato in file?<br><div apple-content-edited=
=3D"true">
<span class=3D"Apple-style-span" style=3D"border-collapse: separate; color:=
 rgb(0, 0, 0); font-family: Helvetica; font-style: normal; font-variant: no=
rmal; font-weight: normal; letter-spacing: normal; line-height: normal; orp=
hans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; =
white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizonta=
l-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorati=
ons-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-wi=
dth: 0px;  "><span class=3D"Apple-style-span" style=3D"border-collapse: sep=
arate; color: rgb(0, 0, 0); font-family: Helvetica; font-style: normal; fon=
t-variant: normal; font-weight: normal; letter-spacing: normal; line-height=
: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-tran=
sform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-bor=
der-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-=
text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-t=
ext-stroke-width: 0px;  "><div style=3D"word-wrap: break-word; -webkit-nbsp=
-mode: space; -webkit-line-break: after-white-space; "><span class=3D"Apple=
-style-span" style=3D"border-collapse: separate; color: rgb(0, 0, 0); font-=
family: Helvetica; font-style: normal; font-variant: normal; font-weight: n=
ormal; letter-spacing: normal; line-height: normal; orphans: 2; text-align:=
 -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal;=
 widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -web=
kit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none;=
 -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px;  "><div st=
yle=3D"word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break:=
 after-white-space; "><span class=3D"Apple-style-span" style=3D"border-coll=
apse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-style: no=
rmal; font-variant: normal; font-weight: normal; letter-spacing: normal; li=
ne-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; =
text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -w=
ebkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px;=
 -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; =
-webkit-text-stroke-width: 0px;  "><div style=3D"word-wrap: break-word; -we=
bkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><span class=
=3D"Apple-style-span" style=3D"border-collapse: separate; color: rgb(0, 0, =
0); font-family: Helvetica; font-style: normal; font-variant: normal; lette=
r-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-aut=
o; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; =
word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-v=
ertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-tex=
t-size-adjust: auto; -webkit-text-stroke-width: 0px;  "><div style=3D"word-=
wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white=
-space; "><span class=3D"Apple-style-span" style=3D"border-collapse: separa=
te; color: rgb(0, 0, 0); font-family: Helvetica; font-style: normal; font-v=
ariant: normal; letter-spacing: normal; line-height: normal; orphans: 2; te=
xt-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space=
: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: =
0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effe=
ct: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px;  =
"><div style=3D"font-weight: normal; font-size: 13px; font-family: Arial, H=
elvetica, sans-serif; "><strong><br class=3D"Apple-interchange-newline"></s=
trong></div></span></div></span></div></span></div></span></div></span></sp=
an></div><div apple-content-edited=3D"true">
<span class=3D"Apple-style-span" style=3D"border-collapse: separate; color:=
 rgb(0, 0, 0); font-family: Helvetica; font-style: normal; font-variant: no=
rmal; font-weight: normal; letter-spacing: normal; line-height: normal; orp=
hans: 2; text-align: auto; text-indent: 0px; text-transform: none; white-sp=
ace: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacin=
g: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-e=
ffect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px=
;  "><span class=3D"Apple-style-span" style=3D"border-collapse: separate; c=
olor: rgb(0, 0, 0); font-family: Helvetica; font-style: normal; font-varian=
t: normal; font-weight: normal; letter-spacing: normal; line-height: normal=
; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; =
widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webk=
it-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; =
-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px;  "><span cl=
ass=3D"Apple-style-span" style=3D"border-collapse: separate; color: rgb(0, =
0, 0); font-family: Helvetica; font-style: normal; font-variant: normal; fo=
nt-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2;=
 text-indent: 0px; text-transform: none; white-space: normal; widows: 2; wo=
rd-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-ver=
tical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-=
size-adjust: auto; -webkit-text-stroke-width: 0px;  "><div><div>Cristian</d=
iv><div><br></div></div></span></span></span></div><div><div>Il giorno 11/s=
et/2014, alle ore 12:52, 'Puglia Marco' <a href=3D"mailto:marco.puglia@busi=
ness-e.it">[email protected]</a> [cfmentor] &lt;<a href=3D"mailto:=
[email protected]">[email protected]</a>&gt; ha scritto:</div=
><br class=3D"Apple-interchange-newline"><blockquote type=3D"cite"><div sty=
le=3D"font-family: Helvetica; font-size: 12px; font-style: normal; font-var=
iant: normal; font-weight: normal; letter-spacing: normal; line-height: nor=
mal; orphans: auto; text-align: start; text-indent: 0px; text-transform: no=
ne; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stro=
ke-width: 0px; background-color: rgb(255, 255, 255);"><div id=3D"ygrp-mlmsg=
" style=3D"font-size: 13px; font-family: Arial, helvetica, clean, sans-seri=
f; position: relative;"><div id=3D"ygrp-msg" style=3D"line-height: 1.22em; =
z-index: 1;"><div id=3D"ygrp-text" style=3D"line-height: 1.22em; font-famil=
y: Georgia;"><div style=3D"line-height: 1.22em; margin: 0px 0px 1em;"><br c=
lass=3D"webkit-block-placeholder"></div><div class=3D"WordSection1" style=
=3D"line-height: 1.22em;"><p class=3D"MsoNormal" style=3D"margin: 0px 0px 1=
em; line-height: 1.22em;">Eccomi di&nbsp; nuovo con un=92altra domanda.<o s=
tyle=3D"font-size: 0px; line-height: 1.22em;"></o></p><p class=3D"MsoNormal=
" style=3D"margin: 0px 0px 1em; line-height: 1.22em;">All=92interno di un d=
atabase Oracle, ho una tabella con un campo blob.<o style=3D"font-size: 0px=
; line-height: 1.22em;"></o></p><p class=3D"MsoNormal" style=3D"margin: 0px=
 0px 1em; line-height: 1.22em;">Sono riuscito a memorizzare il file all=92i=
nterno del campo, ma ora non riesco a leggerlo e consentire il download del=
lo stesso.<o style=3D"font-size: 0px; line-height: 1.22em;"></o></p><p clas=
s=3D"MsoNormal" style=3D"margin: 0px 0px 1em; line-height: 1.22em;"><o styl=
e=3D"font-size: 0px; line-height: 1.22em;">&nbsp;</o></p><p class=3D"MsoNor=
mal" style=3D"margin: 0px 0px 1em; line-height: 1.22em;">Che tecnica mi con=
sigliate?<o style=3D"font-size: 0px; line-height: 1.22em;"></o></p><p class=
=3D"MsoNormal" style=3D"margin: 0px 0px 1em; line-height: 1.22em;">Grazie<o=
 style=3D"font-size: 0px; line-height: 1.22em;"></o></p><p class=3D"MsoNorm=
al" style=3D"margin: 0px 0px 1em; line-height: 1.22em;"><o style=3D"font-si=
ze: 0px; line-height: 1.22em;">&nbsp;</o></p><p class=3D"MsoNormal" style=
=3D"margin: 0px 0px 1em; line-height: 1.22em;"><span style=3D"line-height: =
1.22em; font-size: 7.5pt; color: rgb(31, 73, 125);">=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 style=3D"line-height: 1.22em;"></span><b style=3D"line-height: 1.22em;"=
><span style=3D"line-height: 1.22em; color: rgb(31, 73, 125);">Marco Puglia=
<br style=3D"line-height: 1.22em;"></span></b><i style=3D"line-height: 1.22=
em;"><span style=3D"line-height: 1.22em; color: rgb(31, 73, 125);">Project&=
nbsp;Manager<br style=3D"line-height: 1.22em;"></span></i><b style=3D"line-=
height: 1.22em;"><span style=3D"line-height: 1.22em; color: navy;"><a href=
=3D"http://www.business-e.it/" style=3D"line-height: 1.22em; font-family: V=
erdana;"><span style=3D"line-height: 1.22em; color: blue;">Business-e S.p.A=
.</span></a></span></b><span style=3D"line-height: 1.22em; color: rgb(31, 7=
3, 125);">&nbsp;</span><span style=3D"line-height: 1.22em; color: navy;">(a=
n Itway Group Company)<br style=3D"line-height: 1.22em;"><br style=3D"line-=
height: 1.22em;"></span><span style=3D"line-height: 1.22em; color: rgb(31, =
73, 125);">Via F.lli Lumi=E8re, 65 - 48010 Ravenna<o style=3D"font-size: 0p=
x; line-height: 1.22em;"></o></span></p><p class=3D"MsoNormal" style=3D"mar=
gin: 0px 0px 1em; line-height: 1.22em;"><span style=3D"line-height: 1.22em;=
 color: rgb(31, 73, 125);">Tel. +39 0544.460413 - Fax +39 0544.272297<o sty=
le=3D"font-size: 0px; line-height: 1.22em;"></o></span></p><p class=3D"MsoN=
ormal" style=3D"margin: 0px 0px 1em; line-height: 1.22em;"><span style=3D"l=
ine-height: 1.22em; color: rgb(31, 73, 125);">Cell. 348 4759233<o style=3D"=
font-size: 0px; line-height: 1.22em;"></o></span></p><p class=3D"MsoNormal"=
 style=3D"margin: 0px 0px 1em; line-height: 1.22em;"><span style=3D"line-he=
ight: 1.22em; color: rgb(31, 73, 125);"><br style=3D"line-height: 1.22em;">=
</span><b style=3D"line-height: 1.22em;"><span style=3D"line-height: 1.22em=
; font-size: 7.5pt; color: rgb(31, 73, 125);">Italy</span></b><span style=
=3D"line-height: 1.22em; font-size: 7.5pt; color: rgb(31, 73, 125);">,<span=
 class=3D"Apple-converted-space">&nbsp;</span><b style=3D"line-height: 1.22=
em;">France</b>,<span class=3D"Apple-converted-space">&nbsp;</span><b style=
=3D"line-height: 1.22em;">Spain</b>,<span class=3D"Apple-converted-space">&=
nbsp;</span><b style=3D"line-height: 1.22em;">Portugal, Greece, Turkey</b><=
span class=3D"Apple-converted-space">&nbsp;</span><br style=3D"line-height:=
 1.22em;">Ravenna, Milano, Trento, Bari, Massa, Roma<br style=3D"line-heigh=
t: 1.22em;">Paris, Barcelona, Madrid, Lisboa, Athina, Istanbul, Ankara<br s=
tyle=3D"line-height: 1.22em;">=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"li=
ne-height: 1.22em; color: rgb(31, 73, 125);"><o style=3D"font-size: 0px; li=
ne-height: 1.22em;"></o></span></p><p class=3D"MsoNormal" style=3D"margin: =
0px 0px 1em; line-height: 1.22em;"><o style=3D"font-size: 0px; line-height:=
 1.22em;">&nbsp;</o></p></div><div style=3D"line-height: 1.22em; margin: 0p=
x 0px 1em;"><br class=3D"webkit-block-placeholder"></div></div><div style=
=3D"line-height: 1.22em; color: rgb(255, 255, 255); height: 0px;"></div></d=
iv></blockquote></div><br></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: Cristian Costantini &lt;[email protected]&gt=
;         <hr style=3D"height:2px ; border-width:0; color:#E3E3E3; backgrou=
nd-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=3D41904/stime=3D1410438280" 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=3DX3oDMTJjaHY4djQxBF9TAzk3NDkwNDg3BGdycElkAzE3MDg2MQRncnBzc=
ElkAzU1OTAwMDE5OQRzZWMDdnRsBHNsawN2Z2hwBHN0aW1lAzE0MTA0MzgyNzk-" 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=3DX3oDMTJicmUwMTU0BF9TAzk=
3NDkwNDg1BGdycElkAzE3MDg2MQRncnBzcElkAzU1OTAwMDE5OQRzZWMDZnRyBHNsawNnZnAEc3=
RpbWUDMTQxMDQzODI4MA--" 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>
--Apple-Mail=_D19103DE-E022-4784-B820-7942596F8536--