---
title: "Invalid operation"
type: "forum-thread"
url: "https://www.webforum.nu/amne/databaser-sql/123667-invalid-operation"
topic: "Databaser & SQL"
topic_url: "https://www.webforum.nu/amne/databaser-sql"
author: "Eclipse"
published: "2005-03-03T16:09:19.000Z"
updated: "2005-03-04T08:37:27.000Z"
replies: 5
views: 241
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/123667-invalid-operation"
---

# Invalid operation

## #1 — Eclipse, 2005-03-03T16:09Z

Den första fungerar, den andra  fungerar inte.
Access 2000, förändring markerad \*, community c\*

```
IF request("ID") <> "" THEN
	SQL = "SELECT c.intID, c.strName,(SELECT COUNT(*) FROM bannerAccess ba, navigation n[b], community c[/b]    WHERE " _
	& " ba.intBannerID = " & request("ID") & " AND ba.intNavigationID = n.intID AND c.intID = n.intCommunityID)" _
	& "FROM community c ; "
	set mySQL = Conn.Execute(SQL)
	IF NOT mySQL.EOF THEN myRow = mySQL.GetRows()
	response.write UBound(myRow,2) & "  3.sssss<BR>"
	FOR j = 0 TO UBound(myRow,2)
		response.write myRow(1,j) & " " & myRow(2,j) & "<BR>"
	NEXT
END IF

IF request("ID") <> "" THEN
	SQL = "SELECT c.intID, c.strName,(SELECT COUNT(*) FROM bannerAccess ba, navigation n WHERE " _
	& " ba.intBannerID = " & request("ID") & " AND ba.intNavigationID = n.intID AND c.intID = n.intCommunityID)" _
	& "FROM community c ; "
	set mySQL = Conn.Execute(SQL)
	IF NOT mySQL.EOF THEN myRow = mySQL.GetRows()
	response.write UBound(myRow,2) & "  3.sssss<BR>"
	FOR j = 0 TO UBound(myRow,2)
		response.write myRow(1,j) & " " & myRow(2,j) & "<BR>"
	NEXT
END IF

Microsoft JET Database Engine error '80004005' 

Invalid operation. 

/admin/banner/edit.asp, line 122
```

Koden fungerade igår! Nu har jag ändrat så mycket... att jag snart inte vet varken in eller ut!

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

## #2 — LarsG, 2005-03-03T16:16Z

Access har ju lite konstiga begränsningar, den kanske blir förvirrad av att du har samma korrelationsnamn på flera ställen.

```
community c
```

Vad händer om du använder ett annat (för frågan unikt) namn? (Det här är bara en gissning från min sida.)

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

## #3 — Eclipse, 2005-03-03T16:34Z

```
SQL = "SELECT cc.intID, cc.strName,(SELECT COUNT(*) FROM bannerAccess ba, navigation n  WHERE " _
& " ba.intBannerID = " & request("ID") & " AND ba.intNavigationID = n.intID AND cc.intID = n.intCommunityID)" _
& "FROM community cc ; "
```

Du menar byta c mot cc?
Fungerar givetvis inte...

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

## #4 — Eclipse, 2005-03-03T16:36Z

På samma sida, efter den felande koden finns denna koden som fungerar:

```
IF request("communityID") <> "" THEN
	' ## SELECT NAVIGATION PER MENU
	SQL = " SELECT n.intID, n.strName, 'TRUE', c.intID " _
	& " FROM navigation n, community c " _
	& " WHERE n.intCommunityID = c.intID AND c.intID = " & request("communityID") & " AND EXISTS " _ 
	& " (SELECT ba.intID FROM bannerAccess ba, banner b WHERE " _
	& " ba.intBannerID = " & request("ID")_
	& " AND ba.intBannerID = b.intID AND ba.intNavigationID = n.intID " _
	& " ORDER BY n.intSortfield ) " _
	& " UNION " _
	& " SELECT n.intID, n.strName, 'FALSE', c.intID " _
	& " FROM navigation n, community c " _
	& " WHERE n.intCommunityID = c.intID AND c.intID = " & request("communityID") & " AND NOT EXISTS " _
	& " (SELECT ba.intID FROM bannerAccess ba, banner b WHERE " _
	& " ba.intBannerID = " & request("ID") _
	& " AND ba.intBannerID = b.intID AND ba.intNavigationID = n.intID " _
	& " ORDER BY n.intSortfield );"

	set mySQL = Conn.Execute(SQL)
	DIM listBanners
	IF NOT mySQL.EOF THEN listBanners = mySQL.GetRows()
END IF
```

Detta är ju egentligen bara en vanlig "räkna alla posterna"-grej! Snacka om att man tappar takten när bara en sån enkel grej att räkna alla posterna inte fungerar! Farcinerande och skrämmande på samma gång...!

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

## #5 — LarsG, 2005-03-03T17:23Z

inte en susning, tyvärr.

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

## #6 — Eclipse, 2005-03-04T08:37Z

Tack Lars!

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

---

Tråden på webben: https://www.webforum.nu/amne/databaser-sql/123667-invalid-operation