Jag har samma kåd på två webbplatser enligt Katten Pejst, den beryktade.
' ## SELECT SUBSCRIBERS PER COMMUNITY
SQL = " SELECT c.intID, c.strName, 'TRUE', ( SELECT count(*) FROM subscribers s WHERE s.intCommunityID = c.intID ) " _
& " , s.intID, [b]s.strUser[/b], s.strPassword " _
& " FROM community c, subscribers s " _
& " WHERE s.intCommunityID = c.intID AND s.intUserID = " & request("ID") & " AND c.bolView = TRUE AND EXISTS " _
& " (SELECT s.intID FROM subscribers s, users u WHERE s.intUserID = u.intID " _
& " AND s.intCommunityID = c.intID AND u.intID = " & request("ID") & ") " _
& " UNION " _
& " SELECT c.intID, c.strName, 'FALSE', ( SELECT count(*) FROM subscribers s WHERE s.intCommunityID = c.intID ) " _
& " , FALSE, [b]FALSE[/b], FALSE " _
& " FROM community c" _
& " WHERE c.bolView = TRUE AND NOT EXISTS " _
& " (SELECT s.intID FROM subscribers s, users u WHERE s.intUserID = u.intID " _
& " AND s.intCommunityID = c.intID AND u.intID = " & request("ID") &");"
Nedan är det som inte fungerar på femman men som fungerar på sexan:
' ## PESONAL BOOKMARK
FOR j = 0 TO UBound(listCommunity,2)
response.write j & " " & listCommunity(5,j) & "<br>"
response.write j & " " & UCase(listCommunity(5,j)) & "<br>"
IF UCase( listCommunity(5,j)) <> FALSE THEN
myBookmark = "http://" & request.serverVariables("SERVER_NAME") & "/?U=" & listCommunity(5,j) & "&PW=" & listCommunity(6,j)
END IF
NEXT
************************************************
Vid utskrift: (Det är inte samma data i databasen, givetvis...)
Microsoft-IIS/5.0
0 0
0 0
1 0
1 0
2 0
2 0
3 MEUILE
3 MEUILE
4 0
4 0
Microsoft-IIS/6.0
0 0
0 0
1 0
1 0
2 MPMGFP
2 MPMGFP

