file upload asp-mysql database

[fluff]

can anyone help me, i am really stuck.

I want my form to allow the user to upload a word document into the database (mysql) and then the view page allow this document to be opened. how can i do this. is there any good tutorials.

i am using asp this is then converted (chillsoft i think?) to my sql
:mad:

[Smokie]

What type of server/webserver have you got?

[fluff]

WebFusion: they support asp chillsoft, so i am converting my access database to mysql and altering the code in the asp page. I will also need to do it for our internal server which will support asp fine, but first i need it to work on webfusion.

I am new to this so if you have any suggestions can you tell me where to paste the code etc thank you

[Smokie]

Ive never heard of a "webfusion" server, are you talking about the hosting company called webfusion? Do you have a Sun/Cobalt RaQ server?

[fluff]

yes web fusion is the host- sorry, im new to this - therse are the details that webfusion have:
Server software includes:
Operating system
RedHat linux 7.3
Web server
Apache 1.3.27
Scripting language
PHP 4.1.2
Scripting language
SunONE ASP 3.6.2
CGI Scripting language
Perl 5.6.1
Database server
MySQL 3.23.56
Mail server
Exim 3.36

Instead of using PHP I am converting Access to Mysql and changing the connection code on my asp page to connect into the mysql server. (Our local server uses asp so I thought it would be easier to stick to asp rather than learning php aswell). I have found tutorials on most areas of asp but cant find anthing (that is laid out easy to follow) to allow me to upload files into the database;

It is a job page: so the staff login - on the form input details into text boxes (this is where i also need them to attach the job description, and job application documents word or PDF) submit the form. the information is updated in the my sql database and the information then is updated in the view page (here users need to be able to click on a link to open the document or download it.)

thanks

[Webforumz Staff]

I don't actually know if this is possibly with ASP over Chillisoft, so you'll have to try it out.

I assume you want the form code:

Code: Select all

<form ENCTYPE="multipart/form-data" method="POST"
action="upload.asp">
<INPUT TYPE="FILE" NAME="userfile"
SIZE="35">
<input type="hidden" name="MAX_FILE_SIZE"
value="1000000">
<input type="submit" value="Upload">
</form>

I'm not sure how this works on the ASP end? The other guys will have to help you with that.

If you can't get this working via ASP, then I can definetly tell you how to do it using PHP. You could simply have the upload script in PHP and everything else in ASP with no problems.

[fluff]

Thanks, I have the form created, what should the upload.asp contain??? and how does it tell the document to go into the databse?? if the upload is in php that would be fine.

[Smokie]

If you know how to do the upload in PHP, then do it in PHP!

otherwise... i found this:

<blockquote id="quote" class="ffs">quote:<hr height="1" noshade="noshade" id="quote" />
Chili!Soft ASP Spice Pack Components
The ChiliSoft Spice Pack is a group of COM components (see list, below) that handle commonly-used Web application functionality. These components make it easy to send and receive email and upload files from client browsers. We offer the following components:

Chili!Mail 1.0:
SMTP (Simple Mail Transfer Protocol) COM object used to send emails from an ASP page to an email server.
Chili!POP3 1.0:
POP3 (Post Office Protocol) COM object used to retrieve email from a mail server, using the same protocol used by most email clients.
Chili!Upload 1.0:
Used to upload files from a client (typically a Web browser) to the server and then save these files to the server's file system.
The best place to learn more about these components, and how to use them, is at ChiliSoft's own support pages - ChiliSoft Spice Pack Manual. http://www.chilisoft.com/caspdoc/30h...-SpicePack.htm

<hr height="1" noshade="noshade" id="quote" /></blockquote id="quote">