Image from database

Rails
1

Hello,
I want to displa a thumbnail image from the database. this is like when
a person logs in his thumbnail will be shown. The photo will be stored
in the database(MSSQL 2000) as binary data.Please help me to upload a
thumbnail sized image and display it on the screen.
Thank you.

2

On 2/1/08, Ank Ag [email protected] wrote:

I want to displa a thumbnail image from the database. this is like when
a person logs in his thumbnail will be shown. The photo will be stored
in the database(MSSQL 2000) as binary data.Please help me to upload a
thumbnail sized image and display it on the screen.

Where’s the code representing your own failed attempt?

Storing images in the database is a bad idea in the realm of
performance. Why not use the database you already have, the file
system?

–
Greg D.
http://destiney.com/

3

Greg D. wrote:

On 2/1/08, Ank Ag [email protected] wrote:

I want to displa a thumbnail image from the database. this is like when
a person logs in his thumbnail will be shown. The photo will be stored
in the database(MSSQL 2000) as binary data.Please help me to upload a
thumbnail sized image and display it on the screen.

Where’s the code represe

Here the piece of code:

def photo
@person = Person.find(params[:id])
send_data(@person.uploaded_data,
:filename=>@person.filename,
:type => @person.content_type,
:disposition => ‘inline’)

end

but when i goto http://localhost:3000/person/photo/2308
I get the following error.

private method `gsub’ called for #Array:0x47454c4

I also after reading a forum did the following
modified the following methods in the sqlserver_adapter.rb as follows
and things seems to work fine for me.

def self.string_to_binary(value)
Base64.encode64(value)
end

def self.binary_to_string(value)
Base64.decode64(value)
end

undefined method `unpack’ for #Array:0x4611800