Upload blobs to SQL server using DTC

[QatQat]

I am new to InterDev but I have already experienced some of the cool features. Is it possible to create a upload file form where one of the fields upoalds a blob to a image datatype field on a table? If it is, how do I do that?

All I could achieve on my own usin DTCs is how to access data.

Please help


Regards,

QatQat

 

[MerlinB]

Uploading files is a bit of an art. The most basic requirement is to set the FORM to be MultiPart. You will need to use getChunk/appendChuck to read/write to the database column. You may find that obtaining a third party control (e.g.

http://www.ASPUpload.com)

will simplify this rather gritty requirement.

When displaying a graphic from a database, create a page that accepts a query-string ID. Use this ID to locate the row in the database with the image. Set the pages' Content-Type to "image/bmp" or "image/gif" or whatever. Then stream the grapic data into the remainder of the page. To add an image to an existing page, just set the src= to this graphic-generating page:
<image src=&quot;database_image_page.asp?id=1234&quot;>

http://www.websitedesign.co.uk

http://www.zentext.com

(Content Management)

 

[QatQat]

I tried ASPupload with some results. However I definitely need to learn more about coding it myself.

Thanks for the advise

Regards,

QatQat