| unexpected prob in dataset [message #164019] |
Wed, 24 May 2006 06:30 |
Eclipse User |
|
|
|
Originally posted by: jay_gh.yahoo.co.in
HI
I use
birt-report-framework-S20050928
in eclipse-SDK-3.1-win32
I have write a quary with using "count".When i use only one table then
it's ok but when i use multiple table
then there error occered.
ie, Probleam is in "count" with multiple table.
Though it is running well in Mysql.
This is my quary
************************************************************ *************
select
.course.course_id,
.course.course_name,
.course_creation_details.date_created,
count(.course_student_association.student_id)
from course_creation_details,course_student_association,course
where .course.course_id=.course_creation_details.course_id and
.course_creation_details.course_id=.course_student_associati on.course_id
group by .course_student_association.course_id
************************************************************ *************
This error in birt dataset
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ ++++++++++++
Cannot get the decimal value from column (4)
Cannot get big Decimal value in result set
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ ++++++++++++
There r no probleam in mysql
************************************************************ *************
mysql> select
course.course_id,.course.course_name,.course_creation_detail s.dat
e_created,count(.course_student_association.student_id)
-> from course_creation_details,course_student_association,course
-> where .course.course_id=.course_creation_details.course_id and
course_cr
eation_details.course_id=.course_student_association.course_ id
-> group by .course_student_association.course_id;
+-----------+-------------+---------------------+----------- --------------------
----------------+
| course_id | course_name | date_created |
count(.course_student_associat
ion.student_id) |
+-----------+-------------+---------------------+----------- --------------------
----------------+
| u | unit2 | 2006-05-20 01:51:34 |
2 |
| u1 | unit1 | 2006-05-20 01:50:55 |
4 |
| u3 | unit3 | 2006-05-20 01:52:04 |
3 |
+-----------+-------------+---------------------+----------- --------------------
----------------+
3 rows in set (0.00 sec)
mysql>
************************************************************ **************
Then WHAT IS THE PROBLEAM
Plz reply me.
jak
|
|
|
Powered by
FUDForum. Page generated in 0.02917 seconds
] 
Search
Help
Register
Login
Home
