SQL Functions in ASP (Max, Min, Count

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   I have a question about a SQL-query with a function in it.
For instance:
SELECT Max(Balance) FROM Accounts
Now I want to get the result of that query in a variable in ASP.

So, I have in my sourcecode:
DIM maxbalance
strSQL = "SELECT Max(Balance) FROM Accounts"
SET rs_Results = Conn.Execute(strSQL)
Where Conn is my database connection.
How do I get the result of the query in the variable maxbalance? Waht is the sourcecode which I should put in my ASP-page.

Edited by coolnlstuff