Re: import_bytea function (resolved)

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