February 5th, 2004, 08:08 AM
Firebird with Dreamweaver
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:
it works fine.
However, if I write SQL as follows:
and Click TEST button, error message pops up saying:
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.
February 8th, 2004, 04:02 PM
February 9th, 2004, 05:56 AM
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;"
April 20th, 2004, 03:05 PM
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
April 23rd, 2004, 09:49 AM
...another contrib. from mariuz ... yeah
Originally Posted by mariuz
Romania it's a beautiful country ... too bad that it's populated with ... peoples!
April 23rd, 2004, 11:32 AM
Well i try to be helpful
Originally Posted by goreXP
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 ;-)