How to save image using Stored Procedure in 3 tier application

[essa2000]

Dears
we are developing 3-Tier Application and we
have to send the image as a parameter from PO to BO
and then to DO. We have to send the image as a
parameter to the Stored Procedure from PO to DO.
We are using ADO 2.5 library.

PO = presentation Object
BO = Business object
DO = Data Object

We have not been accomplishing it for one week please
, send me the example code or guide me.

I am looking forward for your quick responce
positively.

Regards ,
essa2000

 

[dellyjm]

Hi, i've been doing some development using SQL Server and the whole interaction with images.

The way how i store my images is in a seperate directory, with the path to the directory & the image name in the database field and it just references it.

Not sure if i was clear.

Delton Phillips.
deltonphillips@hotmail.com

 

[chiph]

Dellyjm -

So you aren't storing the images as BLOBs in the database, but rather the path to where the images are located?

Any problems with duplicate filenames?

Chip H.

 

[dellyjm]

Duplicate filenames, haven't run into that problem. Probably because each record was/is going to be forced to have a unique filename ala id. This would be done by the application entering the data into the table.

Sounds ok?

Delton Phillips.
deltonphillips@hotmail.com

 

[chiph]

Probably because each record was/is going to be forced to have a unique filename ala id.

That will work. If you're using MSSQL Server, you could use an identity column for that. You'd also want to write a small application that would spit out a list of filenames and image descriptions so that if things ever got corrupt, you could match them up again. Or, maybe so you could run a free-text query against it.

Chip H.