|
| |
|
|
Horndogweb
Posts: 1
From: Phoenix, AZ, USA
Status: offline
 |
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
< Message edited by Spooky -- 8/21/2002 1:14:04 AM >
|
|
|
|
cky
Posts: 10
Joined: 12/2/2001
From:
Status: offline
|
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?
| |
|
|
|
cky
Posts: 10
Joined: 12/2/2001
From:
Status: offline
|
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
Posts: 10
Joined: 12/2/2001
From:
Status: offline
|
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
Posts: 10
Joined: 12/2/2001
From:
Status: offline
|
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
Posts: 527
From: St. Louis MO USA
Status: offline
|
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
Posts: 10
Joined: 12/2/2001
From:
Status: offline
|
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
Posts: 26606
Joined: 11/11/1998
From: Middle Earth
Status: offline
|
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
Posts: 10
Joined: 12/2/2001
From:
Status: offline
|
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
Posts: 10
Joined: 12/2/2001
From:
Status: offline
|
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
Posts: 26606
Joined: 11/11/1998
From: Middle Earth
Status: offline
|
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
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
http://www.frontpagedatabase.com/downloads/FileUploadWhitePaper.zip
k₯ 