InstantDB Project
About InstantDB
Project Mail Lists
Short History
Reporting Bugs
Screen Shots
3rd Party Examples
FAQs

Software
Downloads
Documentation
CVS Repositories
Roadmap
License

About Enhydra.org
Who We Are
News, Articles & Events
Getting Involved
Contact Us

Community
Demos
Contributions
Resources
Case Studies
On The Edge! -NEW-
Commercial Vendors


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

InstantDB: Aggregate expression with math expression problem


I just downloaded instantDB last week and I am trying to get it working
with a project I am working on.  I have a table where I have several
values I want averages on.

Assume a table "T" with columns C1,C2,C3,C4 all long values

The following statements work:
select avg(C1) from T
select avg(C1*C2) from T
select avg(C1*5) from T

This statement does not work:

select avg(C1*C2*C3) from T
select avg(C1*C2*5) from T

For some reason, it there are three or more values in the mathmatical
expression, instantDB returns a error that it found a * where it
expected a ) symbol.  Does anybody have a workaround for this problem?

Thank you!

Doug Thistlethwaite

P.S: I saw some old messages on integrating JBuilder with instantDB but
no answers.  If anybody is still looking for this info, let me know and
I will post the solution that is working for me.


-----------------------------------------------------------------------------
To unsubscribe from this mailing list, send email to majordomo@enhydra.org
with the text "unsubscribe instantdb" in the body of the email.
If you have other questions regarding this mailing list, send email to
the list admin at owner-instantdb@enhydra.org.