ASP Free Lounge
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
 
User Name:
Password:
Remember me
Go Back   ASP Free ForumsOtherASP Free Lounge

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread ASP Free Forums Sponsor:
  #1  
Old September 16th, 2004, 10:51 AM
Rhonda S Rhonda S is offline
Registered User
ASP Free Newbie (0 - 499 posts)
 
Join Date: Sep 2004
Posts: 1 Rhonda S User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Input Form to Database Help (will pay)

Hi everyone,
I have created a web site which is database driven using Microsoft Access and Microsoft Frontpage 2003. Our results are displaying as planned. So everything is fine in that area. However, we are trying to create an input form page so members can create their own information in the database (okay, no problem,) but we also want the user to UPLOAD a picture to the database which would store the pic in a default folder and ALSO create the file path into the PHOTO FIELD of the database so it points to that directory...............any help will be appreciated. I will pay someone to create this for me just for the fact that I will learn from it......Hope this makes sense.

P.s. I know how to use the FP upload feature for the graphic, but how do I store the file path in the table of the database to point to that directory including the filename

Reply With Quote
  #2  
Old December 4th, 2004, 08:26 AM
guymclaren's Avatar
guymclaren guymclaren is offline
Contributing User
ASP Free Newbie (0 - 499 posts)
 
Join Date: Dec 2004
Location: Nelspruit South Africa
Posts: 179 guymclaren User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 9 h 1 m 21 sec
Reputation Power: 4
upload script

Quote:
Originally Posted by Rhonda S
Hi everyone,
I have created a web site which is database driven using Microsoft Access and Microsoft Frontpage 2003. Our results are displaying as planned. So everything is fine in that area. However, we are trying to create an input form page so members can create their own information in the database (okay, no problem,) but we also want the user to UPLOAD a picture to the database which would store the pic in a default folder and ALSO create the file path into the PHOTO FIELD of the database so it points to that directory...............any help will be appreciated. I will pay someone to create this for me just for the fact that I will learn from it......Hope this makes sense.

P.s. I know how to use the FP upload feature for the graphic, but how do I store the file path in the table of the database to point to that directory including the filename

Try throwing away front page and coding yourself, for the upload check out ASPUpload, www.aspupload.com

upload.asp

<div id="divContent">
<table width="405"><tr><td>Upload your graphics here.
<br><br>Graphic sizes in pixels width x height
<br>letting and sales thumbnails 150 x 110
<br>standard image 250 x 180
<br>contact photo 150 x 110
<br><br>
Also it is important that the graphic is either in jpg or gif format. The graphic should also be limited to about 15K, less is more. The graphic name is what you add in the image URL part of the database. If you attempt to upload a graphic file that is too large it will upload a maximum of 25K and not the rest. These files will not work.</td></tr></table>

<FORM METHOD="POST" ENCTYPE="multipart/form-data" ACTION="upload1.asp">
<INPUT TYPE=FILE SIZE=40 NAME="uploadfile1"><BR>
<INPUT TYPE=FILE SIZE=40 NAME="uploadfile2"><BR>
<INPUT TYPE=FILE SIZE=40 NAME="uploadfile3"><BR>
<INPUT TYPE=FILE SIZE=40 NAME="uploadfile4"><BR>

<INPUT TYPE=SUBMIT VALUE="Upload!" onclick="LimitAttach(this.form, this.form.uploadfile.value)">
</FORM>
</div>

upload1.asp

<div id="divContent">
<%
Set Upload = Server.CreateObject("Persits.Upload.1")
Upload.SetMaxSize 60000
Upload.Save (Server.mappath ("../htdocs/images/uploads"))
%>
<% = Count %> images were successfully uploaded
<br>
<a href="upload.asp">Upload more images</a>
</div>


Guy McLaren
webtech
www.webtech.co.za

Reply With Quote
  #3  
Old December 4th, 2004, 08:29 AM
guymclaren's Avatar
guymclaren guymclaren is offline
Contributing User
ASP Free Newbie (0 - 499 posts)
 
Join Date: Dec 2004
Location: Nelspruit South Africa
Posts: 179 guymclaren User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 9 h 1 m 21 sec
Reputation Power: 4
code for viewing images

While Not objRSi.EOF

If len(objRSi("paraimage")) > 0 Then
Response.Write "</td></tr><tr><td width= ""470"" valign= ""top"" colspan=""2"" bgcolor=""#cbcbcb"" >"
Response.Write "<img src=""../images/uploads/" & objRSi("paraimage") & """ "
Response.Write " width=""150"" height=""110"" border=""3"" vspace=""3"" hspace=""3"" align=""" & objRSi("imgposition") & """>"
Response.Write objRSi("paratext") & "<br><br>"

Else
Response.Write "</td></tr><tr><td width= ""470"" valign= ""top"" colspan=""2"" bgcolor=""#cbcbcb"" >"
Response.Write objRSi("paratext")& "<br><br>"

End If

Guy McLaren
webtech
www.webtech.co.za
guy@webtech.co.za

Reply With Quote
Reply

Viewing: ASP Free ForumsOtherASP Free Lounge > Input Form to Database Help (will pay)


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 4 hosted by Hostway