Form to upload documents

webby · October 21st, 2004, 07:52 PM

I am new to ASP and would appreciate help.

I created a form to let my users upload word and pdf docs to the server. The form is not live yet cause don't know how to complete this process. I would like once the documents are uploaded the document name will go to a SQL server database, then recordsets are displayed as hyperlinks in an HTML table.

Is this project even realistic and possible? Please help as I am very confused right now.

rajanikrishna · October 21st, 2004, 08:25 PM

for uploading file to server,

use any of third party components. One such component is
ASPSmartUpload http://www.aspsmart.com

After upload the file, insert the filename to the table(database).
When retrieving data, form links with the file name

response.write "<a href='" & rs("filename") & "'>" & rs("filename") & "</a>"

http://www.aspfaqs.com/aspfaqs/ShowFAQ.asp?FAQID=131

----------
Rajani

webby · October 21st, 2004, 08:54 PM

Thanks for the reply raj. I'd rather do the upload without any 3rd party componets. I also would like my users to submit a file name to the database during an upload of the document. Hope I am making sense. I have no asp code in it so far, but this is how my form looks like.

<TITLE></TITLE>
</HEAD>
<BODY>
<FORM METHOD="POST" ENCTYPE="multipart/form-data" ACTION="uploadexmple.asp">
    <TABLE BORDER=0>
    <tr><td><b>Enter File Name:</b><br><INPUT TYPE=TEXT SIZE=40 NAME="FULLNAME"></td></tr>
    <tr><td><b>Select a file to upload:</b><br><INPUT TYPE=FILE SIZE=50 NAME="FILE1"></td></tr>
    <tr><td> </td></tr>
    <tr><td align="center"><INPUT TYPE=SUBMIT VALUE="Upload!"></td></tr>
    </TABLE>
</FORM>
</BODY>
</HTML>

Quote:

quote:Originally posted by rajanikrishna

for uploading file to server,

use any of third party components. One such component is
ASPSmartUpload http://www.aspsmart.com

After upload the file, insert the filename to the table(database).
When retrieving data, form links with the file name

response.write "<a href='" & rs("filename") & "'>" & rs("filename") & "</a>"

http://www.aspfaqs.com/aspfaqs/ShowFAQ.asp?FAQID=131

----------
Rajani

rajanikrishna · October 22nd, 2004, 07:43 PM

Hello,

I think many host servers support ASPSmartUpload control. Or ask your server administrator which they supports.

You are doing right way. When you submit form after selecting the file, upload the file to any folder in your tree using upload control(any...) and store the filename in the database.

Using these components is suggestable.

---------
Rajani

webby · October 23rd, 2004, 11:34 PM

Once again, thanks. Very helpful.

Quote:

quote:Originally posted by rajanikrishna
Hello,

I think many host servers support ASPSmartUpload control. Or ask your server administrator which they supports.

You are doing right way. When you submit form after selecting the file, upload the file to any folder in your tree using upload control(any...) and store the filename in the database.

Using these components is suggestable.

---------
Rajani