aggregate functions: problem with SELECT SUM()

**xianwinwin** · 05-11-2007, 01:09 AM

Hi all,
I am in dire need of help here.

my code below does not return the expected value.
mind that code works if I replace the sql statement with something such as:
SELECT c_name FROM c_production WHERE id=513

I did some reading and I suspect the following
1. not sure if objDB.Execute is the right syntax (some wrote OpenRecordset)
2. I'm not sure the loop is necessary because the sql suppose to return one value.

THANKS FOR ANY POINTERS!!!

Please Login or Register  to view this content.

**mrice** · 05-12-2007, 11:42 AM

You might already have tried this. Just in case you haven't...

Try running your SQL statement against the DB directly - does it work then?

**xianwinwin** · 05-12-2007, 11:47 AM

hi there,
yes in my db, this query returns a value and it's working fine.

**WinteE** · 05-12-2007, 11:50 AM

Try this WHERE at the end of your SELECT :

Please Login or Register  to view this content.

**xianwinwin** · 05-12-2007, 11:58 AM

mmm..still not.
even with your suggested query it doesn't work

**WinteE** · 05-13-2007, 05:06 AM

And this way : ?

Please Login or Register  to view this content.

**xianwinwin** · 05-13-2007, 03:53 PM

thank you for trying. I didn't test your code because it is obvious it will not work. the problem is not in the id section! it's in the sum section.

I don't need to test that because I'm trying to get this

SELECT sum(c_amount) FROM c_production WHERE id=513

id= 513

so my conclusion is somewhere around the sum(c_amount) which is wrong.

once again, thanks for trying.

**WinteE** · 05-14-2007, 01:47 AM

Please Login or Register  to view this content.

**xianwinwin** · 05-14-2007, 01:51 AM

why do you think this would solve it? the 'AS' is for developers...it facilitates their queries, it has nothing to do with the query's result.

SELECT sum(c_amount) AS SumAmount FROM

aggregate functions: problem with SELECT SUM()

LinkBack

Thread Tools

Rate This Thread

Display

aggregate functions: problem with SELECT SUM()

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions