---
title: "COUNT ... vaddå??"
type: "forum-thread"
url: "https://www.webforum.nu/amne/databaser-sql/169198-count-vaddå"
topic: "Databaser & SQL"
topic_url: "https://www.webforum.nu/amne/databaser-sql"
author: "Eclipse"
published: "2008-02-19T16:39:32.000Z"
updated: "2008-02-22T22:03:02.000Z"
replies: 16
views: 835
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/169198-count-vaddå"
---
# COUNT ... vaddå??
## #1 — Eclipse, 2008-02-19T16:39Z
Ingen av dessa varianter fungerar. Access + ASP
```
' ## COUNT MOST FAMOUS PHOTOGRAPHER
SQL = "SELECT TOP 10 u.intID, u.strNickname " _
& ", (SELECT [b]COUNT(tmpPhotos)[/b] FROM images i WHERE i.intUserID = u.intID ) " _
& " FROM users u, images i WHERE tmpPhotos > 0 ORDER BY tmpPhotos DESC;"
set mySQL = Conn.Execute(SQL)
IF NOT mySQL.EOF THEN application("listUsersTOP10") = mySQL.GetRows() ELSE application("listUsersTOP10") = ""
' ## COUNT MOST FAMOUS PHOTOGRAPHER
SQL = "SELECT TOP 10 u.intID, u.strNickname " _
& ", (SELECT [b]COUNT(*) AS tmpPhotos[/b] FROM images i WHERE i.intUserID = u.intID ) " _
& " FROM users u, images i WHERE tmpPhotos > 0 ORDER BY tmpPhotos DESC;"
set mySQL = Conn.Execute(SQL)
IF NOT mySQL.EOF THEN application("listUsersTOP10") = mySQL.GetRows() ELSE application("listUsersTOP10") = ""
```
Permalänk: https://www.webforum.nu/p/169198
## #2 — voigtann1, 2008-02-19T16:52Z
```
' ## COUNT MOST FAMOUS PHOTOGRAPHER
SQL = "SELECT TOP 10 u.intID, u.strNickname " _
& ", (SELECT COUNT(*) FROM images i WHERE i.intUserID = u.intID ) [b]AS tmpPhotos[/b] " _
& " FROM users u, images i WHERE tmpPhotos > 0 ORDER BY tmpPhotos DESC;"
set mySQL = Conn.Execute(SQL)
IF NOT mySQL.EOF THEN application("listUsersTOP10") = mySQL.GetRows() ELSE application("listUsersTOP10") = ""
```
Permalänk: https://www.webforum.nu/p/2083817
## #3 — Eclipse, 2008-02-19T17:14Z
Gött mos, broder!
```
Fungerar:
& " FROM users u, images i ;"
Fungerar EJ:
& " FROM users u, images i WHERE tmpPhotos <> 0;"
& " FROM users u, images i ORDER BY tmpPhotos DESC;"
```
Kan jag inte använda tmpPhotos senare i urvalet...!?
Permalänk: https://www.webforum.nu/p/2083827
## #4 — voigtann1, 2008-02-19T17:36Z
Nej. Men det är nog inte omöjligt att RecordSet.Filter kanske kan hjälpa dig med Sortering eller liknande?
Permalänk: https://www.webforum.nu/p/2083832
## #5 — Eclipse, 2008-02-19T17:44Z
Hmm... tragiskt. Tål att funderas på. Jag ska utveckla min tanke. Kanske bättre i ny tråd?
Permalänk: https://www.webforum.nu/p/2083833
## #6 — Peter S, 2008-02-19T17:49Z
```
select top 10
u.intId
, u.strNickName
, count(*)
from users u
inner
join images i
on u.intId = i.intUserId
group
by u.intId
, u.strNickName
having count(*) > 0
order
by 3 desc
```
Permalänk: https://www.webforum.nu/p/2083835
## #7 — Eclipse, 2008-02-21T13:16Z
Tack!!
Detta fungerar bra:
```
SQL = "select top 10 u.intId, u.strNickName, count(*)" _
& " from users u " _
& " inner join images i on u.intId = i.intUserId " _
& " group by u.intId, u.strNickName having count(*) > 0 " _
& " order by 3 desc ;"
set mySQL = Conn.Execute(SQL)
IF NOT mySQL.EOF THEN
myRow = mySQL.GetRows()
FOR j = 0 TO UBound(myRow,2)
response.write j+1 & ". " & myRow(1,j) & " -- " & myRow(2,j) & "
"
NEXT
END IF
```
Men hur frågar jag "WHERE u.strNickName \<\> '' " ???
```
SQL = "select top 10 u.intId, u.strNickName, count(*)" _
& " from users u " _
& " inner join images i on u.intId = i.intUserId " _
& " group by u.intId, u.strNickName having count(*) > 0 " _
& " [b]WHERE u.strNickname <> ''[/b] order by 3 desc ;" <--- FUNGERAR EJ. Har även prövat alternativ.
```
Permalänk: https://www.webforum.nu/p/2084227
## #8 — voigtann1, 2008-02-21T13:21Z
Where u.strNickname != ''
?
Permalänk: https://www.webforum.nu/p/2084230
## #9 — @nders, 2008-02-21T13:21Z
Where skall vara före group by.
Permalänk: https://www.webforum.nu/p/2084231
## #10 — aasah, 2008-02-21T14:20Z
Borde det inte vara \<\> istället för != ? Eller funkar det senare i Access?
Permalänk: https://www.webforum.nu/p/2084251
## #11 — voigtann1, 2008-02-21T14:23Z
Tror det är mer i det @nders skriver.
Permalänk: https://www.webforum.nu/p/2084252
## #12 — aasah, 2008-02-21T14:25Z
> **voigtann1 skrev:**
>
> Tror det är mer i det @nders skriver.
Det @nders skriver är rätt. :) Det jag funderade på var om ditt råd var det? :q
Permalänk: https://www.webforum.nu/p/2084254
## #13 — voigtann1, 2008-02-21T14:26Z
!= borde fungera... har faktist inte testat det i Access ;)
Permalänk: https://www.webforum.nu/p/2084255
## #14 — Eclipse, 2008-02-22T15:25Z
```
SQL = "select top 10 u.intId, u.strNickName, count(*)" _
& " from users u " _
& " inner join images i on u.intId = i.intUserId " _
& " WHERE u.strNickname <> '' group by u.intId, u.strNickName having count(*) > 0 " _
& " order by 3 desc ;"
set mySQL = Conn.Execute(SQL)
IF NOT mySQL.EOF THEN
myRow = mySQL.GetRows()
FOR j = 0 TO UBound(myRow,2)
response.write j+1 & ". " & myRow(1,j) & " -- " & myRow(2,j) & "
"
NEXT
END IF
```
Tack! Gütt mos.... Vem vill ha cred för detta...!?
Permalänk: https://www.webforum.nu/p/2084416
## #15 — Eclipse, 2008-02-22T15:27Z
> **voigtann1 skrev:**
>
> != borde fungera... har faktist inte testat det i Access ;)
```
Microsoft JET Database Engine error '80040e14'
Syntax error (missing operator) in query expression 'u.strNickname != '''.
/admin/login.asp, line 33
```
Kanske i senare/andra versioner men inte i den version jag har.
Permalänk: https://www.webforum.nu/p/2084418
## #16 — voigtann1, 2008-02-22T15:41Z
Då vet man ;)
Permalänk: https://www.webforum.nu/p/2084424
## #17 — aasah, 2008-02-22T22:03Z
> **Eclipse skrev:**
>
> ```
> Microsoft JET Database Engine error '80040e14'
>
> Syntax error (missing operator) in query expression 'u.strNickname != '''.
>
> /admin/login.asp, line 33
> ```
>
>
>
>
> Kanske i senare/andra versioner men inte i den version jag har.
Jag **tror** att det är specifikt för MS SQL Server.
Permalänk: https://www.webforum.nu/p/2084481
---
Tråden på webben: https://www.webforum.nu/amne/databaser-sql/169198-count-vaddå