RES: Please confirm (conf#af90367104c78732cbd8571b54403a60)

-----Mensagem original-----
De: A mailing list for discussion about Sun Microsystem's Java Servlet
API Technology. [mailto:[email protected]] Em nome de Eric
J. Chet
Enviada em: terça-feira, 8 de abril de 2003 21:34
Para: [email protected]
Assunto: 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

___________________________________________________________________________
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