22. august 2001 - 02:50
Der er
2 kommentarer og 2 løsninger
SELECT AVG
Hej, jeg skal finde gennemsnittet af nogle tal der står i en kollone der hedder age. Jeg har følgende: ------------------ Set Conn = Server.CreateObject(\"ADODB.Connection\") Conn.Open \"DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=\" & Server.MapPath(\"database.mdb\") SQL = \"SELECT AVG(age) from users\" Set objRS = Conn.execute(SQL) Response.Write objRS(\"age\") Set objRS = nothing Set Conn = nothing --------------------------- Jeg får følgende fejl: ADODB.Recordset error \'800a0cc1\' Item cannot be found in the collection corresponding to the requested name or ordinal. /gennemsnit.asp, line 9 Hvad gør jeg galt ?
Annonceindlæg fra Admin By Request
22. august 2001 - 02:52
#1
Set Conn = Server.CreateObject(\"ADODB.Connection\") Conn.Open \"DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=\" & Server.MapPath(\"database.mdb\") SQL = \"SELECT AVG(age) as age from users\" Set objRS = Conn.execute(SQL) Response.Write objRS(\"age\") Set objRS = nothing Set Conn = nothing
22. august 2001 - 02:59
#2
Nu fik jeg en ny fejl: Microsoft OLE DB Provider for ODBC Drivers error \'80004005\' [Microsoft][ODBC Microsoft Access Driver] Circular reference caused by alias \'age\' in query definition\'s SELECT list. /gennemsnit.asp
22. august 2001 - 09:48
#3
Prøv: Set Conn = Server.CreateObject(\"ADODB.Connection\") Conn.Open \"DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=\" & Server.MapPath(\"database.mdb\") SQL = \"SELECT AVG(age) AS AvgAge from users\" Set objRS = Conn.execute(SQL) Response.Write objRS(\"AvgAge\") Set objRS = nothing Set Conn = nothing