List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:March 19 2003 3:14pm
Subject:Re: how to display blob data back to text
View as plain text  
At 5:39 -0800 3/19/03, Karthikeyan Balasubramanian wrote:
>Hi,
>
>   I m using the following query
>
>SELECT id,
>        subject,
>        news,
>        date_format(date, '%m/%d/%Y %h:%i %p') AS date,
>        author,
>        link
>     FROM news
>     ORDER BY id DESC LIMIT 5
>
>heres my table structure
>
>CREATE TABLE news
> (                                                      
>    id int(10) unsigned DEFAULT '0' NOT NULL
> auto_increment,              
>    subject varchar(50) NOT
> NULL,                                         
>    news blob NOT
> NULL,                                                   
>    date datetime DEFAULT '0000-00-00' NOT
> NULL,                          
>    author varchar(50) NOT
> NULL,                                          
>    link
> varchar(150),                                                    
>    PRIMARY KEY
> (id)                                                      
>   );     
>
>heres the output i get in my web page
>
>3 Test2 [B@1abcd9b 03/19/2003 06:28 PM karthikeyan
>2 Test1 [B@47b35d 03/19/2003 06:28 PM karthikeyan
>
>Can i tweak the query so that i can display BLOB data properly.

Possibly, but you specify neither what's wrong the the values as shown
above, or how you want them to be displayed, so I see no way to answer
your question without additional information.



>
>Have a great day.
>
>Karthikeyan.
>--
>   Karthikeyan Balasubramanian
>   mysql_karthik@stripped


-- 
Paul DuBois
http://www.kitebird.com/
sql, query
Thread
how to display blob data back to textKarthikeyan Balasubramanian19 Mar
  • Re: how to display blob data back to textPaul DuBois19 Mar
    • Re: how to display blob data back to textMark Matthews19 Mar