Re: import_bytea function (resolved)

[Stephen Davies <sdavies@xxxxxxxxxx>]

On 08/10/16 17:16, Thomas Kellerer wrote:
> Stephen Davies schrieb am 08.10.2016 um 02:57:
> > A follow-up question.
> > Once the bytea column is populated, how best to display  the content in a
> > web page?
> >
> > I have :
> >
> > byte [] imgB;
> > ResultSet rs = st1.executeQuery("select pic from part where pno='" + p + "'");
> >       if(rs.next()){
> >           imgB = rs.getBytes(1);
> >           if (imgB != null){
> >             out.write("Content-type: image/jpeg");
> >             out.write("Content-length: " + (int)imgB.length);
> >             out.write(imgB.toString());
> >           }
> >       }
> >
> > but this does not work.
> > The toString() looks wrong but removing it makes the write fail.
>
> What is "out"?
>
> (And please use a PreparedStatement to run the SELECT for security reasons)

Thanks to all.
Both the update and display now work.


Cheers,
Stephen


--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general