---
title: "Unspecified"
type: "forum-thread"
url: "https://www.webforum.nu/amne/databaser-sql/73166-unspecified"
topic: "Databaser & SQL"
topic_url: "https://www.webforum.nu/amne/databaser-sql"
author: "Eclipse"
published: "2003-04-04T15:58:23.000Z"
updated: "2003-04-06T17:35:36.000Z"
replies: 7
views: 245
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/databaser-sql/73166-unspecified"
---

# Unspecified

## #1 — Eclipse, 2003-04-04T15:58Z

```
SQL = "INSERT INTO [" & myTable & "] " _
& "(dteCreated, dteViewFrom, dteViewTo, intSortfield, intVersionID) VALUES (" _
& " #" & date() & "#, #" & date() & "#, #" & date() & "#, " _
& " (SELECT (COUNT(*)+1) FROM [" & myTable & "] WHERE " _ 
& " intVersionID = " & intVersionID & " ), " & intVersionID & " );"
response.write sql
34. --> Conn.Execute(SQL)
```

INSERT INTO \[webadmin\] (dteCreated, dteViewFrom, dteViewTo, intSortfield, intVersionID) VALUES ( #2003-04-04#, #2003-04-04#, #2003-04-04#, (SELECT (COUNT(\*)+1) FROM \[webadmin\] WHERE intVersionID = 3 ), 3 );

Microsoft JET Database Engine error '80004005'

Unspecified error

/admin/webadmin/confirm.asp, line 34

\*\*\*
Gud vad trött jag blir på detta! Vad menas med "Unspecified error"??

Databasen heter Access men jag vet inte om det är en SQL eller ASP tråd.

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

## #2 — LarsG, 2003-04-04T16:01Z

Har inte detta varit uppe tidigare? Då kom vi väl fram till att det inte går med en select på det sätte utan att du får skriva

insert into ... select  date(),date(),date(), count(\*) + 1  ...

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

## #3 — Eclipse, 2003-04-06T17:14Z

Jo jag trodde det och jag trodde också att det var den koden jag hade kopierat.

Nu har jag trixat en timme med detta och det fungerar fortfarande inte.  Detta vill jag uppnå: (response.write ger...)

```
INSERT INTO [webadmin]
(strName, strRollOver, dteCreated, dteViewFrom, dteViewTo, intSortfield , intVersionID)
VALUES
('', '', #2003-04-06#, #2003-04-06#, #2003-04-06#, 
(SELECT COUNT(*)+1 FROM [webadmin] WHERE intVersionID = 1), 1 );
```

Här är ett kodexempel:

```
SQL = "INSERT INTO [" & myTable & "] " _
& " (strName, strRollOver, dteCreated, dteViewFrom, dteViewTo, intSortfield , intVersionID) VALUES " _
& "('" & strName & "', '" & strRollOver & "', #" _
& dteCreated & "#, #" & dteViewFrom & "#, #" & dteViewTo & "#, " _
& " ((SELECT COUNT(*) FROM [" & myTable & "] " _
& " WHERE intVersionID = " & intVersionID & ")+1), " & intVersionID & " );"
```

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

## #4 — @nders, 2003-04-06T17:19Z

Testa detta: 

```
SQL = "INSERT INTO [" & myTable & "] " _
& " (strName, strRollOver, dteCreated, dteViewFrom, dteViewTo, intSortfield , intVersionID) VALUES " _
& " SELECT '" & strName & "', '" & strRollOver & "', #" _
& dteCreated & "#, #" & dteViewFrom & "#, #" & dteViewTo & "#, " _
& " COUNT(*)+1, " & intVersionID & " FROM [" & myTable & "] " _
& " WHERE intVersionID = " & intVersionID
```

Mvh

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

## #5 — Eclipse, 2003-04-06T17:20Z

Här är ett annat exempel på samma tema...

Fungerande originalkod:

```
SQL = "INSERT INTO [" & myTable & "] " _
& "(strName, dteCreated, dteViewFrom, dteViewTo, intSortfield) " _
& " SELECT " _
& "'" & strName & "', " _
& "#" & dteCreated  & "#, " _
& "#" & dteViewFrom & "#, " _
& "#" & dteViewTo   & "#, " _
& " COUNT(*)+1 FROM [" & myTable & "];"
```

Här i består problemet: 
("Number of query values and destination fields are not the same.")

```
SQL = "INSERT INTO [" & myTable & "] " _
& "(strName, dteCreated, dteViewFrom, dteViewTo, intSortfield, intVersionID) " _
& " SELECT " _
& "'" & strName & "', " _
& "#" & dteCreated  & "#, " _
& "#" & dteViewFrom & "#, " _
& "#" & dteViewTo   & "#, " _
& [b]" COUNT(*) + 1 FROM [" & myTable & "] WHERE [intVersionID] = " & intVersionID [/b] _
& ", " & intVersionID & ";"
```

\[r\] Oups! Jag var inte snabb nog där!

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

## #6 — @nders, 2003-04-06T17:26Z

Se till att WHERE-satsen är sist i din select så bör ditt sista försök fungera.

Mvh,

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

## #7 — Eclipse, 2003-04-06T17:33Z

Ja, det fungerade! Jag förstod det av ditt inlägg.

Skönt... Sånt här är ju helt omöjligt att komma på själv!

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

## #8 — LarsG, 2003-04-06T17:35Z

```
SQL = "INSERT INTO [" & myTable & "] " _
& "(strName, dteCreated, dteViewFrom, dteViewTo, intSortfield, intVersionID) " _
& " SELECT " _
& "'" & strName & "', " _
& "#" & dteCreated  & "#, " _
& "#" & dteViewFrom & "#, " _
& "#" & dteViewTo   & "#, " _
& " COUNT(*) + 1, " _
&  intVersionID & _
" FROM [" & myTable & "] WHERE [intVersionID] = " & intVersionID
```

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

---

Tråden på webben: https://www.webforum.nu/amne/databaser-sql/73166-unspecified