---
title: "problem med upload"
type: "forum-thread"
url: "https://www.webforum.nu/amne/asp/13242-problem-med-upload"
topic: "ASP"
topic_url: "https://www.webforum.nu/amne/asp"
author: "dahlgren"
published: "2001-12-17T20:50:00.000Z"
updated: "2001-12-18T08:34:00.000Z"
replies: 5
views: 218
page: 1
pages: 1
language: "sv-SE"
site: "webForum — webforum.nu"
rights: "Upphovsrätten till varje inlägg tillhör dess författare."
attribution: "Citera som: webForum, https://www.webforum.nu/amne/asp/13242-problem-med-upload"
---

# problem med upload

## #1 — dahlgren, 2001-12-17T20:50Z

Hur får jag detta att funka jag får föjande felmedelande:
Request object error 'ASP 0207 : 80004005' 

Cannot use Request.Form 

/dweb/intern/dokument/Upload.asp, line 22 

Cannot use Request.Form collection after calling BinaryRead. 

```
<%Set Upload = Server.CreateObject("Persits.Upload.1")Upload.Save("e:\docs")Set File = Upload.Files(1)FILE2=Request.Form("FILE2")DESCRIPTION=Request.Form("DESCRIPTION")CATEGORY=Request.Form("CATEGORY")Set Connection = Server.CreateObject("ADODB.Connection")Connection.Open "driver={Microsoft Access Driver (*.mdb)};DBQ="& Server.MapPath("/dweb/db/database.mdb")SQLStmt = "Insert into docs "SQLStmt = SQLStmt &  " (namn, beskrivning, kategori) "SQLStmt = SQLStmt &  " Values('" & FILE2 & "', " & DESCRIPTION & ", '" & CATEGORY & "')"Connection.Execute(SQLStmt)SET SQLStmt = NothingSQLStmt = "Select Max(Id) as senasteid from fotogalleri"SET RS = Connection.Execute(SQLStmt)senasteid = RS("senasteid")RS.CloseSET SQLStmt = NothingIf file.ImageType = "DOC" ThenExtension = "doc"End Iffilnamn = "dokument" & senasteid & "." & ExtensionFor Each File in Upload.FilesFile.Copy "e:\docs" & senasteid & "." & ExtensionFile.Delete NextSQLStmt = "Update docs "SQLStmt = SQLStmt & " SET namn = '" & Filnamn & "'"SQLStmt = SQLStmt & " Where Id = " & senasteidConnection.Execute(SQLStmt)SET SQLStmt = NothingConnection.Close%>
```

Permalänk: https://www.webforum.nu/p/13242

## #2 — LarsG, 2001-12-17T20:59Z

Du får använda den form som skapas av uploadkomponenten, upload.form istället för request.form

Permalänk: https://www.webforum.nu/p/301038

## #3 — dahlgren, 2001-12-18T07:58Z

då fick jag genaast ett nytt felmedelande.
Microsoft OLE DB Provider for ODBC Drivers error '80040e14' 

\[Microsoft\]\[ODBC Microsoft Access Driver\] Syntax error (missing operator) in query expression 'Lilla Julafton 01'. 

/dweb/intern/dokument/Upload.asp, line 41 

```
SQLStmt = "Insert into docs "
SQLStmt = SQLStmt &  " (namn, beskrivning, kategori) "
SQLStmt = SQLStmt &  " Values('" & upload.Form("FILE2") & "', " & upload.Form("DESCRIPTION") & ", '" & upload.Form("CATEGORY") & "')"
[b]Connection.Execute(SQLStmt)[/b]
SET SQLStmt = Nothing
```

Rad 41 är i fetstil är det nån som har något förslag.

Permalänk: https://www.webforum.nu/p/301039

## #4 — @nders, 2001-12-18T08:01Z

Är inte beskrivning av typen text/pm?

```
SQLStmt = "Insert into docs "
SQLStmt = SQLStmt & " (namn, beskrivning, kategori) "
SQLStmt = SQLStmt & " Values('" & upload.Form("FILE2") & "', '" & upload.Form("DESCRIPTION") & "', '" & upload.Form("CATEGORY") & "')"
```

Apostrofer runt i så fall.

Mvh,

Permalänk: https://www.webforum.nu/p/301040

## #5 — dahlgren, 2001-12-18T08:19Z

Menar du så här?

```
SQLStmt = "Insert into docs "
SQLStmt = SQLStmt & " (namn, 'beskrivning', kategori) "
SQLStmt = SQLStmt & " Values('" & upload.Form("FILE2") & "', " & upload.Form("DESCRIPTION") & ", '" & upload.Form("CATEGORY") & "')"
Connection.Execute(SQLStmt)
SET SQLStmt = Nothing
```

DEt ger i alla fall samma felmedelande.

Permalänk: https://www.webforum.nu/p/301041

## #6 — @nders, 2001-12-18T08:34Z

Nej, jag menar som den SQL-frågan jag postade. :)

Apostrofer runt värdet, inte fältnamnet.

Mvh,

Permalänk: https://www.webforum.nu/p/301042

---

Tråden på webben: https://www.webforum.nu/amne/asp/13242-problem-med-upload