Wrox Programmer Forums
|
Classic ASP Databases Discuss using ASP 3 to work with data in databases, including ASP Database Setup issues from the old P2P forum on this specific subtopic. See also the book forum Beginning ASP.NET Databases for questions specific to that book. NOT for ASP.NET 1.0, 1.1, or 2.0.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Databases section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old August 2nd, 2008, 02:10 PM
Authorized User
 
Join Date: Feb 2008
Posts: 17
Thanks: 3
Thanked 0 Times in 0 Posts
Default How do I upload files in classic ASP?

I have two questions really.
one is how to upload files to the server (I know how to create folders/directories using FSO but not the actual handling of the data from the form to the server).

two is how I might instead store the files (images mostly) inside of an MS Access field.


I've been searching on google and most of the results either advertise some add-on component (I want to learn to do it in-code, myself) or refer to newer (.NET) components and technologies.

Thanks in advance :)

 
Old August 2nd, 2008, 02:21 PM
Imar's Avatar
Wrox Author
 
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

Hi there,

Search Google for "pure asp upload" and you'll find scripts that allow you to upload files using ASP only.

However, IMO you're much better off using a third party component. They are more reliable and offer a lot more features than you can typically develop yourself.

Cheers,

Imar


---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of Beginning ASP.NET 3.5 : in C# and VB, ASP.NET 2.0 Instant Results and Dreamweaver MX 2004
Want to be my colleague? Then check out this post.
 
Old August 2nd, 2008, 03:41 PM
Authorized User
 
Join Date: Feb 2008
Posts: 17
Thanks: 3
Thanked 0 Times in 0 Posts
Default

hi,
I've googled for some answers via "pure asp upload", I think some of them might be ideas I can work with.

I thought it would be simple to have the FSO create a folder and have asp handle the upload from the client to the folder created. I really didn't imagine that I'd have this much difficulty finding a way to do this. I've had a look at how it's done via php/MySQL and that's surprisingly simple (in comparison)...

I'm surprised there aren't more threads regarding uploading files to the server/database in asp/access, on these forums.


anyway, thank you for the search tip and advice :)

 
Old August 3rd, 2008, 03:36 AM
Imar's Avatar
Wrox Author
 
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

Yeah, with classic ASP it's pretty difficult as it doesn't ship with any features to handle this. That's why there are so many third parties available that offer this. ASP.NET makes this much simpler though.

Many of the third parties also offer functionality to store the uploaded files in a database with just a few lines of code.

For a general idea about uploading files and saving them on disk or in a database, take a look here: http://imar.spaanjaars.com/QuickDocId.aspx?quickdoc=414

It's aimed at .NET but the intro on (dis)advantages applies to classic ASP as well.

Cheers,

Imar

---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of Beginning ASP.NET 3.5 : in C# and VB, ASP.NET 2.0 Instant Results and Dreamweaver MX 2004
Want to be my colleague? Then check out this post.
 
Old August 3rd, 2008, 09:15 AM
Authorized User
 
Join Date: Feb 2008
Posts: 17
Thanks: 3
Thanked 0 Times in 0 Posts
Default

Hi,
sorry to keep bugging you but, would you recommend AspUpload and if so, which version would you recommend?

my needs are simple as it's mostly for uploading and displaying pictures from directories/access.

I don't imagine there'll be more than a thousand records (6-9,000 images related to them) in all.

 
Old August 3rd, 2008, 09:50 AM
Imar's Avatar
Wrox Author
 
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

If you mean ASPUpload from Persits, then yes, I can recommend it. I have used it a lot in the past and it works fine. There are other components available as well with a different feature set and pricing strategy, so I think it's best tow download a few trials and see what you like.

Is ASP.NET an option for you? It has uploading built-in using the FileUpload control...

Cheers,

Imar

---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of Beginning ASP.NET 3.5 : in C# and VB, ASP.NET 2.0 Instant Results and Dreamweaver MX 2004
Want to be my colleague? Then check out this post.
 
Old August 3rd, 2008, 04:19 PM
Authorized User
 
Join Date: Feb 2008
Posts: 17
Thanks: 3
Thanked 0 Times in 0 Posts
Default

hi,
yes ASPUpload is the component I was referring to.
I'm reading through the documentation and checking with my hosts to make sure that I set it up correctly.

I'm interested in .NET and would love to get upto speed with it quickly but, everytime I look at Visual Studio it all seems very intimidating and confusing. so much easier to write code and read up on MySQL/PHP (which is surprisingly easy) or carry on with asp (which does most jobs I want to do, this particular case notwithstanding).
I'll probably have to buy your book to really get my head around using Visual Studio, hehe.
I think I might do that soon :)

 
Old August 4th, 2008, 06:19 AM
Imar's Avatar
Wrox Author
 
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

My book is aimed at beginners in ASP.NET so IMO, it should be easy to get started working with ASP.NET with it. You'll probably find that eventually it's easier to work with ASP.NET than classic ASP or PHP.

Having a background in web programming will certainly help you to get up and running with ASP.NET as fast as possible.

Have fun!

Imar

---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of Beginning ASP.NET 3.5 : in C# and VB, ASP.NET 2.0 Instant Results and Dreamweaver MX 2004
Want to be my colleague? Then check out this post.
 
Old August 4th, 2008, 05:26 PM
Authorized User
 
Join Date: Feb 2008
Posts: 17
Thanks: 3
Thanked 0 Times in 0 Posts
Default

I'll probably be off to Borders sometime this week to check out some books.
I had a good session with VWD 2008 today, went through a few walk-throughs and generally familiarised myself a little with the Microsoft-way of doing things.
It still feels very restrictive compared to coding in Dreamweaver's codeview, but I think you're right it's just about getting acclimatised to the layout and the tools. the power on offer at your finger tips is really quite tempting.

I could build very complex applications very very fast (though I wouldn't have a clue "how" they really work - in code - as most of the interesting/complicated stuff would be masked in their widgets and components :().






Similar Threads
Thread Thread Starter Forum Replies Last Post
CSV files export with Classic ASP, special chars tn_bobbie Classic ASP Basics 1 July 9th, 2015 08:12 AM
Upload files from asp to the database sunilssil Classic ASP Professional 1 October 23rd, 2007 12:46 PM
Converting Classic Asp to Asp.Net 2.0 vikaspatyal ASP.NET 2.0 Professional 2 October 7th, 2007 06:33 PM
asp.net vs classic asp "URGENT" naeem_ul_hussan Classic ASP Professional 1 August 1st, 2007 03:14 PM
UPLOAD FILES FROM ASP TO ORACLE bbarnettm Classic ASP Components 0 February 7th, 2006 04:01 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.