I dette særtema ser vi på, hvordan cloud og AI bliver fundamentet for virksomhedernes digitale forretning, og hvordan de nye muligheder for automatisering og forretningsværdi kan udnyttes uden at miste overblik, sikkerhed og menneskelig kontrol.
Slettet bruger
07. juli 2004 - 11:27#1
Noget i retning af:
SELECT * ,(SELECT COUNT(Nick) FROM CHAT_ONLINE WHERE ChannelID = CHAT_CHANNEL.ID) as OnlineNicks FROM CHAT_CHANNEL ORDER BY ONLINENICKS DESC
strSQL="SELECT *, (SELECT COUNT(Nick) FROM CHAT_ONLINE WHERE ChannelID = CHAT_CHANNEL.ID) as OnlineNicks FROM CHAT_CHANNELORDER BY ONLINENICKS DESC" set rs = dataConn.execute(strSQL)
Microsoft OLE DB Provider for ODBC Drivers (0x80040E09) [TCX][MyODBC]You have an error in your SQL syntax near 'SELECT COUNT(Nick) FROM CHAT_ONLINE WHERE ChannelID = CHAT_CHANNEL.ID) as Online' at line 1 /chat/iframe_listChannels.asp, line 39
strSQL = "SELECT CH.Name, CH.Nick, COUNT(ON.Nick) AS OnlineNicks FROM CHAT_CHANNEL AS CH LEFT JOIN CHAT_ONLINE AS ON ON CH.ID=ON.ChannelID GROUP BY CH.Name, CH.Nick ORDER BY OnlineNicks DESC" set rs = dataConn.execute(strSQL)
Du er nødt til at specificere dine feltnavne fra CHAR_CHANNEL (både lige efter SELECT og efter GROUP BY)
prøv: strSQL = "SELECT CH.Name, CH.Nick, COUNT(ON.Nick) AS OnlineNicks FROM CHAT_CHANNEL AS CH LEFT JOIN CHAT_ONLINE AS ON CH.ID=ON.ChannelID GROUP BY CH.Name, CH.Nick ORDER BY OnlineNicks DESC" set rs = dataConn.execute(strSQL)
strSQL = "SELECT C.Name, C.Nick, COUNT(O.Nick) AS OnlineNicks FROM CHAT_CHANNEL AS C LEFT JOIN CHAT_ONLINE AS O ON C.ID=O.ChannelID GROUP BY C.Name, C.Nick ORDER BY OnlineNicks DESC" set rs = dataConn.execute(strSQL)
strSQL = "SELECT C.*, COUNT(O.Nick) AS OnlineNicks FROM CHAT_CHANNEL AS C LEFT JOIN CHAT_ONLINE AS O ON C.ID=O.ChannelID GROUP BY C.Name ORDER BY OnlineNicks DESC" set rs = dataConn.execute(strSQL)
rahp tryk også lige svar :-D
Synes godt om
Slettet bruger
07. juli 2004 - 13:48#10
Svar.
Synes godt om
Ny brugerNybegynder
Din løsning...
Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.