Help.. how to browse to file and create hyperlink in database

Jon D · Jun 30, 2004

I have a form where a user enters their name, date etc.
i also want them to be able to click on a browse button and select a
file which will then appear in a textbox. when they press submit i
want the file name and path to be put into the database. e.g.
"C:\windows\work\work.doc". Basically I don't want to UPLOAD the file
just enable the user to browse to it and send the filename and path to
the database.

Any help would be appreciated,

thanks

Steven Burn · Jun 30, 2004

<%
'// eg.asp
strFile = Request.Form("TheFile")
Select Case strFile
Case ""
%>
Show your form here
<%
Case Else
'// Add your processing code here to add strFile to the
database.
End Select
%>

--

Regards

Steven Burn
Ur I.T. Mate Group
www.it-mate.co.uk

Keeping it FREE!

Bullschmidt · Jun 30, 2004

<<
I have a form where a user enters their name, date etc.
i also want them to be able to click on a browse button and select a
file which will then appear in a textbox. when they press submit i want
the file name and path to be put into the database. e.g.
"C:\windows\work\work.doc". Basically I don't want to UPLOAD the file
just enable the user to browse to it and send the filename and path to
the database.
Here is a test file that works for me:

<html>
<body>

<%
' If there was a post.
If Request.Form.Count > 0 Then
Response.Write "LName = " & Request.Form("LName") & "<br>"
Response.Write "FileLocationOnClientPC = " &
Request.Form("FileLocationOnClientPC") & "<br>"
Else
%>
<form id="frmMain" name="frmMain" action="<%=
Request.ServerVariables("SCRIPT_NAME") %>" method="post">
LName: <input type="text" name="LName"><br>
FileLocationOnClientPC: <input type="file"
name="FileLocationOnClientPC"><br>
<input type="submit" name="btnSubmit" value="Submit"><br>
<%
End If
%>

</form>
</body>
</html>

Best regards,
J. Paul Schmidt, Freelance ASP Web Designer
http://www.Bullschmidt.com
ASP Designer Tips, ASP Web Database Demo, Free ASP Bar Chart Tool...

*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!

Jon D · Jul 1, 2004

Thanks ever so much for your help but I have a problem with the
example you gave me and can't work out which parts wrong!

" method="post">

This part is displayed on the webpage rather then being part of the
form header. I've tried changing all different parts of the script but
to no avail. Im sure its something simple but I can't see it.

thanks

Bullschmidt · Jul 1, 2004

This should all be one line of code:

<form id="frmMain" name="frmMain" action="<%=
Request.ServerVariables("SCRIPT_NAME") %>" method="post">

Best regards,
J. Paul Schmidt, Freelance ASP Web Designer
http://www.Bullschmidt.com
ASP Designer Tips, ASP Web Database Demo, Free ASP Bar Chart Tool...

*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!

Evertjan. · Jul 1, 2004

Bullschmidt wrote on 01 jul 2004 in
microsoft.public.inetserver.asp.general:

This should all be one line of code:

<form id="frmMain" name="frmMain" action="<%=
Request.ServerVariables("SCRIPT_NAME") %>" method="post">

This will also do:

<form id="frmMain"
name="frmMain"
action="<%=Request.ServerVariables("SCRIPT_NAME")%>"
method="post">

And even this will do the same:

<form id="frmMain"
name="frmMain"
method="post">

How to create PDF file in Batch	5	May 11, 2022
How to connect MySQL DataBase to Java Application	2	Dec 11, 2023
Database schema for file organizer.	1	May 17, 2022
Can't execute php to delete multiple rows in database	3	May 14, 2023
How to convert a database data in predefined format and generate output in text format	1	Feb 10, 2022
Help to decide which sw to use	1	Nov 18, 2023
How to Create a random password generator in a separate window	4	May 26, 2022
Website with Database. use C#	1	Mar 25, 2023

Help.. how to browse to file and create hyperlink in database

Jon D

Steven Burn

Bullschmidt

Jon D

Bullschmidt

Evertjan.

Ask a Question

Similar Threads

Members online

Forum statistics

Latest Threads