displaying image in front end

[Gopinath]

Hi
I am facing a problem with ASP and SQL Server
I have a table in SQL Server called 'picture'
create table picture(pic_id int, pic_path image)
insert into picture values(1, 'e:\picture1.gif')
In front end, I want to display the current image path and filename.
Fetching the record from 'picture' table.
It displays like that 1, '????????????????????'.
I want to get the correct file name and id. Is there any parsing method?

Thanx in advance

-Gopi

[Marcelo]

You cannot insert a string value into a image field.
You need to keep the image field to receive the image and create another field to insert the path of the image.

You cannot insert image directly. You can store it in a binary format. While reading you have to read in binary format.