10. marts 2004 - 15:13
Der er
7 kommentarer og
1 løsning
Persist ASP Upload hjælp
jeg har prøvet og implementere asp upload, men får fejl:
Persits.Upload.1 error '800a0005'
The system cannot find the path specified.
/odbc_upload.asp, line 13
<HTML>
<BODY>
<%
Set Upload = Server.CreateObject("Persits.Upload")
' Capture files
Upload.Save "/images/upload"
' Obtain file object
Set File = Upload.Files("THEFILE")
If Not File Is Nothing Then
' Build ODBC connection string
Connect = "Driver={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("/db/aspupload.mdb")
' If you use SQL Server, the connecton string must look something like this:
' Connect = "Driver=SQL Server;Server=MYSRV;Database=master;UID=sa;PWD=xxx"
' Build SQL INSERT statement
SQL = "INSERT INTO MYIMAGES(image_blob, filename, description, filesize) VALUES(?, '"
SQL = SQL & File.Filename & "', '"
SQL = SQL & Replace(Upload.Form("DESCR"), "'", "''") & "', "
SQL = SQL & File.Size & ")"
' Save to database
File.ToDatabase Connect, SQL
Response.Write "File saved."
Else
Response.Write "File not selected."
End If
%>
</BODY>
</HTML>
Linie 13 er: Upload.Save "/images/upload"
den sti er sat i forhold til der hvor min fil ligger
10. marts 2004 - 15:16
#1
Du skal bruge Upload.SaveVirtual i stedet for. Save-metoden tager kun en komplet sti, mens virtual kan håndtere en ... tadaaa... virtuel sti i stedet for :)
10. marts 2004 - 15:55
#5
its working... giver gerne flere point for dette tillægsspørgsmål: jeg har prøvet at ændre felterne for det der uploades så jeg får flere informationer med, kan bare ikke se om det ser rigtigt ud:
SQL = "INSERT INTO images(ImageBlob, Filename, Filesize, userID, Date, Time, Category, Title, Description) VALUES(?, '"
SQL = SQL & File.Filename & "', '"
SQL = SQL & File.Size & "', '"
SQL = SQL & Replace(Upload.Form("IDuser"), "'", "''") & "', "
SQL = SQL & Replace(Upload.Form("Date"), "'", "''") & "', "
SQL = SQL & Replace(Upload.Form("Time"), "'", "''") & "', "
SQL = SQL & Replace(Upload.Form("Category"), "'", "''") & "', "
SQL = SQL & Replace(Upload.Form("Title"), "'", "''") & "', "
SQL = SQL & Replace(Upload.Form("Description"), "'", "''") & ")"
deres oprindelige kode så sådan ud:
SQL = "INSERT INTO MYIMAGES(image_blob, filename, description, filesize) VALUES(?, '"
SQL = SQL & File.Filename & "', '"
SQL = SQL & Replace(Upload.Form("DESCR"), "'", "''") & "', "
SQL = SQL & File.Size & ")"
min tabel ser sådan ud:
IDimage
Filename
Filesize
ImageBlob
Hash
userID
Date
Time
Category
Title
Description
TAK for hjælpen!
10. marts 2004 - 16:26
#6
Persits.Upload.1 error '800a001c'
[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.
/odbc_upload.asp, line 37
Linie 37: File.ToDatabase Connect, SQL
10. marts 2004 - 16:32
#7
har ændret tabellen til myimages
og felterne Date og Time til: UploadDate og UploadTime
så får jeg denne fejl:
Persits.Upload.1 error '800a001c'
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression '10-3-2004', 4:36:''.
/odbc_upload.asp, line 37
