#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Feb 2004
    Posts
    2
    Rep Power
    0

    Unhappy 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.
  2. #2
  3. Bug Hunter
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2003
    Location
    Transylvania (Romania)
    Posts
    309
    Rep Power
    24
    what driver do you use ?
  4. #3
  5. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Feb 2004
    Posts
    2
    Rep Power
    0
    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
  6. #4
  7. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2004
    Location
    St Louis, Mo
    Posts
    1
    Rep Power
    0
    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
  8. #5
  9. Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2003
    Location
    Bucharest
    Posts
    72
    Rep Power
    12
    Originally Posted by mariuz
    what driver do you use ?
    ...another contrib. from mariuz ... yeah
    Romania it's a beautiful country ... too bad that it's populated with ... peoples!
  10. #6
  11. Bug Hunter
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2003
    Location
    Transylvania (Romania)
    Posts
    309
    Rep Power
    24

    Lightbulb


    Originally Posted by goreXP
    ...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 ;-)
    My home page: http://www.firebirdsql.org and work place :http://www.reea.net

IMN logo majestic logo threadwatch logo seochat tools logo