Firebird SQL Development
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Dev Shed ForumsDatabasesFirebird SQL Development

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
  #1  
Old February 5th, 2004, 07:08 AM
ozrok ozrok is offline
Junior Member
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Feb 2004
Posts: 2 ozrok User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation 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.

Reply With Quote
  #2  
Old February 8th, 2004, 03:02 PM
mariuz's Avatar
mariuz mariuz is offline
Bug Hunter
Dev Shed Newbie (0 - 499 posts)
 
Join Date: May 2003
Location: Transylvania (Romania)
Posts: 274 mariuz User rank is Corporal (100 - 500 Reputation Level)mariuz User rank is Corporal (100 - 500 Reputation Level)mariuz User rank is Corporal (100 - 500 Reputation Level)mariuz User rank is Corporal (100 - 500 Reputation Level) 
Time spent in forums: 20 h 12 m 34 sec
Reputation Power: 9
what driver do you use ?

Reply With Quote
  #3  
Old February 9th, 2004, 04:56 AM
ozrok ozrok is offline
Junior Member
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Feb 2004
Posts: 2 ozrok User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation 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

Reply With Quote
  #4  
Old April 20th, 2004, 02:05 PM
ronblack ronblack is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Jan 2004
Location: St Louis, Mo
Posts: 1 ronblack User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Send a message via Yahoo to ronblack
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

Reply With Quote
  #5  
Old April 23rd, 2004, 08:49 AM
goreXP's Avatar
goreXP goreXP is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Jun 2003
Location: Bucharest
Posts: 72 goreXP User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 2 h 10 m 10 sec
Reputation Power: 6
Send a message via MSN to goreXP Send a message via Yahoo to goreXP
Quote:
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!

Reply With Quote
  #6  
Old April 23rd, 2004, 10:32 AM
mariuz's Avatar
mariuz mariuz is offline
Bug Hunter
Dev Shed Newbie (0 - 499 posts)
 
Join Date: May 2003
Location: Transylvania (Romania)
Posts: 274 mariuz User rank is Corporal (100 - 500 Reputation Level)mariuz User rank is Corporal (100 - 500 Reputation Level)mariuz User rank is Corporal (100 - 500 Reputation Level)mariuz User rank is Corporal (100 - 500 Reputation Level) 
Time spent in forums: 20 h 12 m 34 sec
Reputation Power: 9
Lightbulb

Quote:
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

Reply With Quote
Reply

Viewing: Dev Shed ForumsDatabasesFirebird SQL Development > Firebird with Dreamweaver


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 3 hosted by Hostway
Stay green...Green IT