Uploading GIF/JPG into SQL Server

[PDL]

How does one go about uploading an image into SQL server... we have been linking to images in other directories but that gets confusing FAST.

 

[GunJack]

You can use the "image" field type. This is commonly called a "blob" field and it can seriously affect your database performance so use it wisely. Here's a link to some information about using this.

http://rigel.dynip.com/extension/sql21_days/ch05/ch05.htm

Good Luck,
GJ

 

[PDL]

Is there an equivalent in Access... I usually develop in Access and UPSIZE to SQL Server using their tool.

What I am curious about is using Cold Fusion, what is used to move the image into the database.

Something like:

<INPUT TYPE=&quot;HIDDEN&quot; NAME=&quot;IMAGE&quot; VALUE=&quot;<IMG SRC='PICTURE.JPG'&quot;>

 

[GunJack]

I don't think there is a true equivalent in Access although the memo field would probably be the closest. I've never tried using one to store images but it might work. The input you'll need on the html form is an <input type=&quot;file&quot; name=&quot;f1&quot;> which will send the file and you'll need to put this extra code in your form tag.

<form method=.... enctype=&quot;multipart/form-data&quot;>

You could then try inserting the form variable &quot;f1&quot; into your memo field. I've never tried this so I can't say what problems you may run into. Just post any problems and I'll see if I can't help.

GJ

 

[CFProgrammer]

Getting the file to access is no problem, it should convert it into binary format. The question I have is, how are you going to convert from binary to regular image format.


CFProgrammer