FP 2002 image upload & database

FP 2002 image upload & database (Full Version)

All Forums >> [Web Development] >> ASP and Database

Message

Horndogweb -> FP 2002 image upload & database (11/23/2001 16:20:00)
Hi -<P>I am trying to configure a FP 2002 form to a.) upload a file b.) save it to a directory and c.) have the corresponding database create a link to that image in the directory for uploaded images.<P>So far my experiments have failed. I have followed the FP help instructions as best I can. I have set the directory on the server to accept uploads, but it is not working...<P>My questions are: a.) can an image upload component be located within a form with other elements and b.) how should the Access database column be configured (OLE object, Text, Memo, Hyperlink, etc).<P>Here is my test page to date:<P><A HREF=" http://4537.2k.adahost.com/IHS-NET/horns4sale/post-sale2.asp" TARGET=_blank>http://4537.2k.adahost.com/IHS-NET/horns4sale/post-sale2.asp</A><P>Any suggestions or link referrals would be greatly appreciated!<P>------------------<BR>Bruce Hembd<BR>www.horndogweb.com

Spooky -> RE: FP 2002 image upload & database (11/25/2001 20:21:00)
Here you go [:D]http://www.frontpagedatabase.com/downloads/FileUploadWhitePaper.zip

cky -> RE: FP 2002 image upload & database (12/3/2001 22:06:12)
I used the instructions in the File Upload Whitepaper editing them to be used with my form fields. I get this error on the Custom Query in the process2.asp page======>>> Server error: Unable to retrieve schema information from the query: INSERT INTO Results (FirstName, LastName, Email, City, State, AdTitle, Description, Price, Category, Image, Date) VALUES (‘1’, ‘2’, ‘3’, ‘4’, ‘5’, ‘6’, ‘7’, ‘8’, ‘9’, ‘10’, ‘11’) against a database using the connection string DRIVER={Microsoft Access Driver (*.mdb)};DBQ=URL=fpdb/midwestdreams.mdb. The following error message comes from the database driver software; it may appear in a different language depending on how the driver is configured. ------------------------------------------------------- [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement. Source: Microsoft OLE DB Provider for ODBC Drivers Number: -2147217900 (0x80040e14) What does this mean? Did I mess it up?

Spooky -> RE: FP 2002 image upload & database (12/4/2001 0:38:05)
"Date" is a reserved name So either use a different one, or do [date] http://support.microsoft.com/directory/article.asp?ID=KB;EN-US;Q209187 §þððk¥ Database / DRW Q & A VP-ASP Shopping cart

cky -> RE: FP 2002 image upload & database (12/9/2001 0:22:26)
Afer I wrote the last reply I noticed several mistakes so to test this I followed the instructions exactly and now I have new problems. The process1.asp page will not display. Something in the code that you put directly under the html tag is preventing it from working. I do not understand this because I copied it from the white paper.

cky -> RE: FP 2002 image upload & database (12/9/2001 2:46:14)
Never mind the previous reply. I fixed that problem now I have a new one. In the process2.asp page I am receiving syntax errors in all fields but the name field. Why is this and how do I fix it?

cky -> RE: FP 2002 image upload & database (12/9/2001 2:47:09)
Never mind the previous reply. I fixed that problem now I have a new one. In the process2.asp page I am receiving syntax errors in all fields but the name field. Why is this and how do I fix it? And the information is not being processed to the database.

ginnie -> RE: FP 2002 image upload & database (12/9/2001 10:47:51)
Have you tried placing a Response.Write strSQL or whatever your variable name is for your sql statement? Place this before executing it so you can see what exactly it's trying to use for the sql statement. ginnie Global Presence Web Design

cky -> RE: FP 2002 image upload & database (12/9/2001 17:05:36)
Ok...here is the deal. I have finally got this to work but I skipped the process2.asp page and had the information send to the database from the process1.asp page. It works just fine! The problem is there is no way to prevent a user from trying to upload a file with the same name as one already in the upload file directory. Is there a simple way to fix this?

Spooky -> RE: FP 2002 image upload & database (12/9/2001 17:31:17)
In the properties for the folder, there is a setting which doesnt allow uploaded files to have the same name. FP [destination]folder > right click > properties §þððk¥ Database / DRW Q & A VP-ASP Shopping cart

cky -> RE: FP 2002 image upload & database (12/9/2001 18:22:04)
The only options I can see are Allow files to be browsed, Allow anonymous upload to this directory,and Allow uploaded files to overwrite existing filenames. I've tried with the later cleared or checked and neither way prevents the problem.

cky -> RE: FP 2002 image upload & database (12/9/2001 20:57:46)
Another question...... In the Schema.ini file all the char width settings are at 255. If I try to change this to 500 for like the comments and actually use 500 characters in the form it will not display the process1.asp page. My question is.... can you change the 255 to a higher number and if so why isn't it working?

Spooky -> RE: FP 2002 image upload & database (12/10/2001 14:34:18)
I would assume the last option would prevent that? You are saying yours doesnt? 2) Are you using MEMO fields? §þððk¥ Database / DRW Q & A VP-ASP Shopping cart

Page: [1]

Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI

9.179688E-02