Returning values of aggregate functions

gregaryh

OK, here is a real stumper,
I am using php to connect to an access database using ADODB.
I am also using a simple sql query and sum function to get the total hours from a table. The sql looks like this:

$rs = $conn->Execute("SELECT Sum(BigTable.Hours) As SumOfHours FROM BigTable;");

I then assign a variable to the result like this:

$hours = $rs->Fields("SumOfHours");

but when i try to print $hours all I get is "Object".

I would assume that since BigTable.Hours is an integer data type it would simply display the sum of the hours in the table.

What object would the sum() function be returning and how can I convert it to the numerial value I am seeking?

Sxooter

Aggregate functions work on groups, so you need a group by clause in your query, like this:

select username, sum(costing) from costtable group by username

gregaryh

Thanks for the reminder.
I do have a GROUP BY clause in the actual SQL that i am using. The issue that perplexes me is that the function seems to return an object since the word "Object" is all that displays when i try to print the variable that was assigned the result of the query. Any tips on why this is?

Sxooter

nope. I don't use access myself. I use postgresql.

tomhath

Pay attention to the error message. Php is telling you that $rs->Fields("SumOfHours") is an Object.

What is $rs->Fields? A function? Or an array?

$hours = $rs->Fields("SumOfHours");

$hours = $rs->Fields["SumOfHours"];

gregaryh

I usually use mysql 😃 but for this project i am required to use an Access database. I am not familiar with the ADODB objects and API but i assume Fields() is a function. I found this code online so i am not sure. Using $rs->Fields("FieldName") on all other fields gives me the contents of that record in that field, It's just when i use the aggregate functions it returns the word Object and not the actual sum.

tomhath

Since php is telling you $hours is an object, try printing the value of the object:

echo $hours->value;

gregaryh

Ha!!!

That worked.

Thanks !!!