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
At 16:31 +0800 1/22/02, ST Ooi wrote:
>OK, I know how to insert the data into a database, now
>how can i retrieve it and display it in client's browser?
If you're using Perl, you can get some sample code at
http://www.kitebird.com/mysql-perl. This page also
contains links to the online version o
CTED]>
>To: <[EMAIL PROTECTED]>
>Subject: How to read blob field data as picture and display on browser?
>Date: Tue, 22 Jan 2002 16:31:22 +0800
>
>OK, I know how to insert the data into a database, now
>how can i retri
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']
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:
