uploading file via ASP gui, then saving in a folder on the server

Not a one of my ASP books covers this. The one example
I've seen in message forums is designed to save files
in a database. Here's the problem:

Hosting server O/S: Windows Server 2003
Objective: have an asp page that allows the user to
upload a graphic file. The file will be saved in a
folder on the hosting server.

Anyone know have a working example, or know where I
can obtain a working example?

Thanks!
-Phil



__________________________________
Do you Yahoo!?
Yahoo! Small Business - Try our new resources site!
http://smallbusiness.yahoo.com/resources/

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: uploading file via ASP gui, then saving in a folder on the server

I'm assuming you don't want to store the file in the database itself,
which not many people recommend if you want to keep your database
running more efficiently. Which means yhat your question isn't really
mysql related, however:

I'm surprised you don't have a book that covers file uploading, and mind
you it has been some time since I did any vbscript (all PHP now) but
what you should need to use is the scripting.filesystemobject object.
Just google it and I'm sure you'll find plenty of resources. Also check
out freevbcode.com as I'm sure there are some examples there. A few
things to note though:

1) The code should be running as a user with write priviliges to the
server's file system (ie: the SYSTEM user) and not the user trying to
upload. The obvious reason is security; You don't want web anonymous
users to have write access to your server's file system.

2) If people are going to be uploading large graphics or files and they
perhaps are on slow connections, remember that scripts will timeout
after a set period. I believe it's 90 seconds (at least that's what it
is on IIS 5 on Win2K server if I recall correctly...) I believe you can
change the script timeout period with vbscript at the page level, though
I never had a need to do it myself, or you can change it at the server
level in the website properties through the IIS console.

3) Get a better ASP book :)

Cheers.

Armando

Phil Jones wrote:
> Not a one of my ASP books covers this. The one example
> I've seen in message forums is designed to save files
> in a database. Here's the problem:
>
> Hosting server O/S: Windows Server 2003
> Objective: have an asp page that allows the user to
> upload a graphic file. The file will be saved in a
> folder on the hosting server.
>
> Anyone know have a working example, or know where I
> can obtain a working example?
>
> Thanks!
> -Phil
>
>
>
> __________________________________
> Do you Yahoo!?
> Yahoo! Small Business - Try our new resources site!
> http://smallbusiness.yahoo.com/resources/
>

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

RE: uploading file via ASP gui, then saving in a folder on the server

Phil,
Here's the "free" version. Go to ASPUpload.com. Its trial version is free, but you can learn
the way to upload files/file names into the database or a specific directory. You can also get the
*free* tool from aspSmart.com, aspSmartUpload.

Both tools I have used with phenomenal success. However, if you want the code to upload graphics
into the database/specific directory, I have lots of code that you can use, or I can write it for
you.

The ASP Bible, which you can get at any bookstore, shows you how to do this in detail and it is
worth the $60. You can also go to
http://msdn.microsoft.com/library/default.asp?url=/library/e n-us/script56/html/vbscripttoc.asp for
more info.

As a side note, I use MySQL to store images and PDF files IN the database. Works really well for me
when creating/using functions for my sites. Don't knock it unless you've tried it. There are lots of
reasons to store images/PDFs/Word/etc docs into the database, you just have to have the right
reasons.

HTH,
J.R.

-----Original Message-----
From: Armando [mailto:dijital@shaw.ca]
Sent: Monday, March 14, 2005 1:09 AM
To: win32@lists.mysql.com
Subject: Re: uploading file via ASP gui, then saving in a folder on the server

I'm assuming you don't want to store the file in the database itself, which not many people
recommend if you want to keep your database running more efficiently. Which means yhat your question
isn't really mysql related, however:

I'm surprised you don't have a book that covers file uploading, and mind you it has been some time
since I did any vbscript (all PHP now) but what you should need to use is the
scripting.filesystemobject object.
Just google it and I'm sure you'll find plenty of resources. Also check out freevbcode.com as I'm
sure there are some examples there. A few things to note though:

1) The code should be running as a user with write priviliges to the server's file system (ie: the
SYSTEM user) and not the user trying to upload. The obvious reason is security; You don't want web
anonymous users to have write access to your server's file system.

2) If people are going to be uploading large graphics or files and they perhaps are on slow
connections, remember that scripts will timeout after a set period. I believe it's 90 seconds (at
least that's what it is on IIS 5 on Win2K server if I recall correctly...) I believe you can change
the script timeout period with vbscript at the page level, though I never had a need to do it
myself, or you can change it at the server level in the website properties through the IIS console.

3) Get a better ASP book :)

Cheers.

Armando

Phil Jones wrote:
> Not a one of my ASP books covers this. The one example I've seen in
> message forums is designed to save files in a database. Here's the
> problem:
>
> Hosting server O/S: Windows Server 2003
> Objective: have an asp page that allows the user to upload a graphic
> file. The file will be saved in a folder on the hosting server.
>
> Anyone know have a working example, or know where I can obtain a
> working example?
>
> Thanks!
> -Phil
>
>
>
> __________________________________
> Do you Yahoo!?
> Yahoo! Small Business - Try our new resources site!
> http://smallbusiness.yahoo.com/resources/
>

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=bullijr@innovatim.com



--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: uploading file via ASP gui, then saving in a folder on the server

Agreed that storing files in the database can be advantageous to a point
- it all depends on the site and the volume/data size of the content you
want to store.

For the record, if you are building a server which must be highly
scalable, then no one I know who has any experience with DBMS' would
ever recommend storing BLOBs unless there's really no other option. And
there are always options :) Things may work wonderfully on a smaller
scale but as soon as the server grows, larger database sizes combined
with higher traffic is only going to decrease your server performance if
there are BLOBs involved.

My take on it has always been to make the server filesystem and the
network connection do the work, not the database. :) Cheers.

Armando


J.R. Bullington wrote:
> Phil,
> Here's the "free" version. Go to ASPUpload.com. Its trial version is free, but you can learn
> the way to upload files/file names into the database or a specific directory. You can also get the
> *free* tool from aspSmart.com, aspSmartUpload.
>
> Both tools I have used with phenomenal success. However, if you want the code to upload graphics
> into the database/specific directory, I have lots of code that you can use, or I can write it for
> you.
>
> The ASP Bible, which you can get at any bookstore, shows you how to do this in detail and it is
> worth the $60. You can also go to
> http://msdn.microsoft.com/library/default.asp?url=/library/e n-us/script56/html/vbscripttoc.asp for
> more info.
>
> As a side note, I use MySQL to store images and PDF files IN the database. Works really well for me
> when creating/using functions for my sites. Don't knock it unless you've tried it. There are lots of
> reasons to store images/PDFs/Word/etc docs into the database, you just have to have the right
> reasons.
>
> HTH,
> J.R.
>
> -----Original Message-----
> From: Armando [mailto:dijital@shaw.ca]
> Sent: Monday, March 14, 2005 1:09 AM
> To: win32@lists.mysql.com
> Subject: Re: uploading file via ASP gui, then saving in a folder on the server
>
> I'm assuming you don't want to store the file in the database itself, which not many people
> recommend if you want to keep your database running more efficiently. Which means yhat your question
> isn't really mysql related, however:
>
> I'm surprised you don't have a book that covers file uploading, and mind you it has been some time
> since I did any vbscript (all PHP now) but what you should need to use is the
> scripting.filesystemobject object.
> Just google it and I'm sure you'll find plenty of resources. Also check out freevbcode.com as I'm
> sure there are some examples there. A few things to note though:
>
> 1) The code should be running as a user with write priviliges to the server's file system (ie: the
> SYSTEM user) and not the user trying to upload. The obvious reason is security; You don't want web
> anonymous users to have write access to your server's file system.
>
> 2) If people are going to be uploading large graphics or files and they perhaps are on slow
> connections, remember that scripts will timeout after a set period. I believe it's 90 seconds (at
> least that's what it is on IIS 5 on Win2K server if I recall correctly...) I believe you can change
> the script timeout period with vbscript at the page level, though I never had a need to do it
> myself, or you can change it at the server level in the website properties through the IIS console.
>
> 3) Get a better ASP book :)
>
> Cheers.
>
> Armando
>
> Phil Jones wrote:
>
>>Not a one of my ASP books covers this. The one example I've seen in
>>message forums is designed to save files in a database. Here's the
>>problem:
>>
>>Hosting server O/S: Windows Server 2003
>>Objective: have an asp page that allows the user to upload a graphic
>>file. The file will be saved in a folder on the hosting server.
>>
>>Anyone know have a working example, or know where I can obtain a
>>working example?
>>
>>Thanks!
>>-Phil
>>
>>
>>
>>__________________________________
>>Do you Yahoo!?
>>Yahoo! Small Business - Try our new resources site!
>>http://smallbusiness.yahoo.com/resources/
>>
>
>
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe: http://lists.mysql.com/win32?unsub=bullijr@innovatim.com
>
>
>

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: uploading file via ASP gui, then saving in a folder on the server

Thanks to everyone who replied. I was so frustrated
over this issue that I failed to realize I posted an
ASP-only question to a MySQL Win list...my apologies
for being off topic. Originally I had planned to store
images in the MySQL dB, but responses to a previous
inquiry of this matter advised me to go the file
system route.

I did find a solution, and thought I would report back
to the list my finding. This article:
http://www.asp101.com/articles/jacob/scriptupload.asp
and this download:
http://www.asp101.com/articles/jacob/fileuploader.zip

were exactly what I needed. I modified the upload.asp
file so that it appends a number (idx num from the
database) to the beginning of the file name so that
duplicate file names will never be an issue, plus
referencing the file from a stored value in the
database will be a breeze.

-Phil


--- Phil Jones wrote:
> Not a one of my ASP books covers this. The one
> example
> I've seen in message forums is designed to save
> files
> in a database. Here's the problem:
>
> Hosting server O/S: Windows Server 2003
> Objective: have an asp page that allows the user to
> upload a graphic file. The file will be saved in a
> folder on the hosting server.
>
> Anyone know have a working example, or know where I
> can obtain a working example?
>
> Thanks!
> -Phil
>
>
>
> __________________________________
> Do you Yahoo!?
> Yahoo! Small Business - Try our new resources site!
> http://smallbusiness.yahoo.com/resources/
>



__________________________________
Do you Yahoo!?
Yahoo! Small Business - Try our new resources site!
http://smallbusiness.yahoo.com/resources/

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: uploading file via ASP gui, then saving in a folder on the server

Hi,

Phil Jones wrote:

> ASP-only question to a MySQL Win list...my apologies

This can happen once in a while.

> I did find a solution, and thought I would report back
> to the list my finding. This article:
> http://www.asp101.com/articles/jacob/scriptupload.asp
> and this download:
> http://www.asp101.com/articles/jacob/fileuploader.zip
>
This could be very helpfull for others in this list.

Erich

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org