Firebird with Dreamweaver

Hi everyone

I'm using Dreamweaver MX and firebird db for web design.

It has been working ok until i try to use aggregate functions like count(*), sum(price).

In Recordset popup of Dreamweaver MX, if I write SQL as follows:

SELECT *
FROM JOBDETL

it works fine.

However, if I write SQL as follows:

SELECT SUM(EXTPRICE)
FROM JOBDETL

and Click TEST button, error message pops up saying:


While executing onClick in ServerBeh4-AdvRS.htm, the following JavaScript error(s) occurred:

At line 120 of file "C:\Program Files\Macromedia\Dreamweaver MX\Configuration\Commands\ServerBeh4-AdvRS.js":
exception throw in native function


and then Dreamweaver gets frozen.

Could anyone help me to solve this problem?
It would be greatly appreciated.

By the way, I have tested with MS Access db and it works fine.
So it must be something to do with Firebird and Dreamweaver MX.

what driver do you use ?

Thanks for the reply.
I'm using Firebird/InterBase(r) driver.

Following is the exact connection string in Dreamweaver:


"DRIVER=Firebird/InterBase(r) driver;UID=SYSDBA;PWD=masterkey;DBNAME=localhost:C:\Program Files\Ezijobz SME\Database\ejdb.fDB;"

Please help!!!
Thanks

I'm not sure why dreamweaver is barfing but you may be able to create a stored procedure that will return the value for you and let dreamweaver call the sp

...another contrib. from mariuz ... yeah

Well i try to be helpful
Not always the best at it
Now we could do some constructive stuff like give the man a proper response ?
Could we start a contest ? heheh ;-)