Please confirm (conf#af90367104c78732cbd8571b54403a60)

<< IMPORTANT INFORMATION! >>

This is an automated message.

The message you sent (attached below) requires confirmation
before it can be delivered. To confirm that you sent the
message below, just hit the "R"eply button and send this
message back (you don't need to edit anything). Once this is
done, no more confirmations will be necessary.

<< INFORMAÇÃO IMPORTANTE >>

Esta é uma mensagem automática

A mensagem que você enviou (em anexo) requer confirmação
antes de ser entregue. Para confirmar o envio basta
pressionar o botão de "Reply" e enviar esta mensagem de
volta (não é necessário editar). Uma vez que isto seja
feito, novas confirmações não serão necessárias.

This email account is protected by:
Active Spam Killer (ASK) V2.2 - (C) 2001-2002 by Marco Paganini
For more information visit http://www.paganini.net/ask

--- Original Message Follows ---

Date:         Mon, 7 Apr 2003 10:37:37 EDT
From: Bob Prah <[email protected]>
Subject:      How to display a jpeg msql Blob field
To: [email protected]

--part1_1ca.6e897f7.2bc2e731_boundary
Content-Type: text/plain; charset="US-ASCII"
Content-Transfer-Encoding: 7bit

Hi to All,

I am having difficulties trying to display a jpeg Blob field from a mysql
table in a servlet. All other fields from this table render their text fields
apart from this particular jpeg Blob field - it'll simply not display
anything at all.

Has anyone dealt with with a similar situation using mysql and how?

Will be appreciate any help.


Thank you,

Bob.

Here is snippet from my code:
<<<<
.....

Connection con;
ResultSet res=null;

 public void service(ServletRequest request, ServletResponse response)
    throws ServletException, java.io.IOException {

      response.setContentType("image/jpeg");
      PrintWriter out = response.getWriter();

try {

            stmt = con.createStatement();
            res=stmt .executeQuery(
            "SELECT textField1,textField2,imageField1 FROM tech_bks ORDER BY
id ;");
            out.println("<table border=0 cellpadding=5 cellspacing=2
align=center width=970>");
            InputStream ipsrt =null;
            while (res.next()){
                blob = res.getBlob("imageField1");
                out.println("<tr><td width=40% >" +
res.getString("textField1"));

                out.print("</td><td width=20% align=left>" +
res.getString("textField2")+ "</td><td width=40% align=left>");


(Original message truncated)

___________________________________________________________________________
To unsubscribe, send email to [email protected] and include in the body
of the message "signoff SERVLET-INTEREST".

Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html