Page 1 of 1

Weird Mysql data type selection

Posted: Thu Feb 26, 2009 10:48 am
by mmurdock
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}


Weird Mysql data type selection

Posted: Fri Feb 27, 2009 5:43 am
by Edward
Hi Mat,

Could you please send us more detail about your task?

Thank you.