Weird Mysql data type selection
Posted: Thu Feb 26, 2009 10:48 am
Why is it that the report writer says that "student_list" is a byte array? I'm using mysql .net connector 5.2.5 and stimulsoft 2009.1.33.8. What is weird is if I change it to string the report writer seems to ignore it.
Thanks,
Mat
SELECT distinct
concat(concat_ws(', ', sis_student_info.last_name, sis_student_info.first_name),'-',sis_student_enrollment.student_id) as student_list
FROM
sis_student_enrollment
Inner Join sis_student_info ON sis_student_enrollment.student_id = sis_student_info.student_id
Inner Join sis_course_semester ON sis_student_enrollment.semester_id = sis_course_semester.semester_id
Inner Join sis_course_school_year ON sis_course_semester.school_year_id = sis_course_school_year.school_year_id
WHERE
sis_student_enrollment.withdrawn = 'N'
{student_filter_list}
Thanks,
Mat
SELECT distinct
concat(concat_ws(', ', sis_student_info.last_name, sis_student_info.first_name),'-',sis_student_enrollment.student_id) as student_list
FROM
sis_student_enrollment
Inner Join sis_student_info ON sis_student_enrollment.student_id = sis_student_info.student_id
Inner Join sis_course_semester ON sis_student_enrollment.semester_id = sis_course_semester.semester_id
Inner Join sis_course_school_year ON sis_course_semester.school_year_id = sis_course_school_year.school_year_id
WHERE
sis_student_enrollment.withdrawn = 'N'
{student_filter_list}