Inserting word files into SQL server

[ScottNeth]

Ok, this is probably a &quot;designing web sites 101&quot; question, but how do I insert, upload, and store a word document (or pdf or rft, etc) into a SQL server? I've got the interface set up to accept a file - but I'm not sure what datatype the column is supposed to be...nor >sheepish grin< how to get the file back out.
Scott Scott Neth
Web Designer/Cyberpunk

 

[schase]

Actually, not sure.

Any reason for wanting to store the whole thing in there?

I usually just store a filename, then a dynamic link on out. &quot;Damn the torpedoes, full speed ahead!&quot;

-Adm. James Farragut

Stuart

 

[ScottNeth]

That's exactly what I've been doing - but I have a server push limit of two per day - so every time I push files, it counts toward my limit. I do everything in CF and store as much as I can in SQL so that I can update pages without hitting my limit. I have about 500 contracts I need to store, and it never fails, as soon as I use my two production pushes, someone urgently needs a contract put up. Scott Neth
Web Designer/Cyberpunk

 

[schase]

hmmm,

ok we'll classify this as out of my area.

But since I dived into it, I did a search over at the SQL forum and found this. - Hope it helps.

thread183-202938 &quot;Damn the torpedoes, full speed ahead!&quot;

-Adm. James Farragut

Stuart

 

[mlawson]

Hi,

Dunno what the thread that Stuart pointed you towards suggests but have you looked at using an SQL stored procedure? I don't how it would affect your predicament but it may offer a side door past the restriction.

Have a look at Rick Curtis' page over at Princeton:

http://www.princeton.edu/~rcurtis/ultradev/tutorial2.html

M &quot;There are 3 kinds of people; those that can count and those that can't&quot;