How about with Java and straight sql call to put the blob in a datastream or what object type?
-----Original Message----- From: Kittiphum Worachat [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 22, 2002 1:08 AM To: ST Ooi; [EMAIL PROTECTED] Subject: Re: How to read blob field data as picture and display on browser? Hi If you use PHP it very simple to do by retrive data from BLOB field and then echo or print such as .... $sql="select fld_blob from tble_xxx"; $result=mysql_db_query($db,$sql); $row=mysql_fetch_array($result); //suppose your data is JPEG Header("Content-type: Image/JPEG"); echo $row['fld_blob']; .... Kittiphum Worachat,MT. www.hatyailab.com Thailand. >OK, I know how to insert the data into a database, now >how can i retrieve it and display it in client's browser? >Thanks >ST Ooi >Malaysia --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
