---
title: "SQL fråga"
type: "forum-thread"
url: "https://www.webforum.nu/amne/asp/7156-sql-fråga"
topic: "ASP"
topic_url: "https://www.webforum.nu/amne/asp"
author: "Qonos"
published: "2000-11-17T17:44:00.000Z"
updated: "2000-11-17T19:16:00.000Z"
replies: 3
views: 229
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/7156-sql-fråga"
---

# SQL fråga

## #1 — Qonos, 2000-11-17T17:44Z

Jag försöker få denna att fungera:

SQLQuery = "Select (Select Count (\*) From tblUsers Where gender_id = 1) As female, " 
SQLQuery = SQLQuery & "(Select Count(\*) As male From tblUsers Where gender_id = 2)," 
SQLQuery = SQLQuery & "(Select Count (\*) As closed_female From tblUsers Where gender_id = 1 AND closed = 1)," 
SQLQuery = SQLQuery & "(Select Count(\*) As closed_male From tblUsers Where gender_id = 2 AND closed = 1)," 
SQLQuery = SQLQuery & "(Select Count (\*) As student_female From tblUsers Where gender_id = 1 AND occupation_id = 1)"
Set rs = OBJdbConnection.execute(SQLQuery)

men får bara ut:

Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
\[Microsoft\]\[ODBC Microsoft Access Driver\] Reserved error (|); there is no message for this error.
/clients/website/wwwroot/adminmeny/stat_members.asp, line 22

vad e felet.. jag kör mot access databas.. och ja iofs e d ett fel men :o)

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

## #2 — emission, 2000-11-17T18:03Z

Det hänger lite på vad det är för databas om du får göra en sådan SELECT-sekvens, men får du det så ska du lägga till en parentes till på slutet.

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

## #3 — Qonos, 2000-11-17T19:14Z

jag har provat både
 gender_id = 1 AND occupation_id = 1))"

och

 gender_id = 1 AND occupation_id = 1)") men inget fungerar 

jag får:

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
\[Microsoft\]\[ODBC Microsoft Access Driver\] Extra ) in query expression '(Select Count (\*) As student_female From tblUsers Where gender_id = 1 AND occupation_id = 1))'.
/clients/vegan.nu/wwwroot/adminmeny/stat_members.asp, line 22

alternativt:

Error Type:
Microsoft VBScript compilation (0x800A0401)
Expected end of statement
/clients/vegan.nu/wwwroot/adminmeny/stat_members.asp, line 21, column 116
SQLQuery = SQLQuery & "(Select Count (\*) As student_female From tblUsers Where gender_id = 1 AND occupation_id = 1)")
\-------------------------------------------------------------------------------------------------------------------^

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

## #4 — Qonos, 2000-11-17T19:16Z

betyder det att det inte fungerar på en access databas?

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

---

Tråden på webben: https://www.webforum.nu/amne/asp/7156-sql-fråga