Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-01-11 : 08:31:47
|
hendrik writes "hi guys!
love your site ...
but pls let me tickle you with a question:
my 'boss' got kinda like a nice idea ... 'let's store our job applicants CV's in our db, so we can easily access them over the intranet, and they can upload through them our website' ...
ok, great idea ... so i start looking around, and build a little application that accepts a file upload through the browser, using a few asp's, and our sql ... very nice to work with ...
now he can browse the job applicants on the intranet, and download / open their cv's (mostly word-files) in his browser (you know, using response.binarywrite) ...
so then, the other day, the boss comes in again asking: well what if we could send these cv's by mail to the responsible manager? so i start looking into cdo/nts and aspmail + attachments, just to find that i don't really know how to export the binary/image field contents for the requested CV to a file on the disk (to be able to attach it)... i have been looking high and low, even tried playing with the fso-object from asp, but did not made it ...
am i missing a bit of the point here? should i search in another direction? should i go COM, or ASP+? if you ever encountered something like this, please hint me? i would owe you all a lot!
free drinks if you come to belgium once? ;)
we use: windows 2000 server, sql2000, asp 3.0 and have full control of the server ... together with the binarystream of a cv, we save the filename and the size + other info ...
thanks a million times in advance!
pls feel free to mail me for more info ...
lots of regards, hendrik ..." |
|
|
rrb
SQLTeam Poet Laureate
1479 Posts |
Posted - 2002-02-26 : 22:54:51
|
| MerkinI'm wondering if you have any suggestions as to how I can have SQL Server deliver the files to the user's hard drive -without giving the user read permissions on the file storage area...--I hope that when I die someone will say of me "That guy sure owed me a lot of money" |
 |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2002-02-26 : 23:17:02
|
| Are you using ASP or VB or what ?One way to do it, that I have implemented for an ASP application. We have an application where users can select multiple files for download.All the master files are kept completely away from the web path. When they are selected, we copy them into a holding directory, from there, they all all put into a ZIP. Then we delete the temp files and binary write the zip file to the client so it downloads.Works well for this application, if you tell me more about what you are doing I might have some other ideas.Damian |
|
|
|
rrb
SQLTeam Poet Laureate
1479 Posts |
Posted - 2002-02-26 : 23:24:59
|
quote:
Are you using ASP or VB or what ?
Sorry Damian - I had been led to believe you could read my mind!VB - LAN/WAN solution. I guess one option could be using an ADO binary stream? But I haven't tried this yet. I'd like to give the user their file in memory - so that I don't have to worry about having write access to their drive or them having read of mine...--I hope that when I die someone will say of me "That guy sure owed me a lot of money" |
|
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2002-02-26 : 23:38:12
|
LOLDon't belive everything you read  There are a few ways you could do this, I haven't done it though so I will just rattle off a few from the top of my head.I guess ADO Stream would be worth a look.Do your users have network shares you could copy into ?Can you set up a web server just for serving up files via HTTP ? Your VB app could put in a request for a file, and would get back an ID. Then have a browser control in your VB app that requests that file ID and have an ASP page that serves the file.They are the first things that came to my mind. Hope it gives you some things to play with.Damian |
|
|
|
rrb
SQLTeam Poet Laureate
1479 Posts |
Posted - 2002-02-27 : 00:13:32
|
quote:
Hope it gives you some things to play with.
Thanks mate. And play I will.... --I hope that when I die someone will say of me "That guy sure owed me a lot of money" |
|
|
|
|
|
|
|
|
EXporting blob/binary from my SQL to a file :)