class SelectLectureInfoWithTeacherInfoByAll
{
public:
        LONG m_lectureNum;
        TCHAR m_lectureTitle[51];
        TCHAR m_teacherId[31];
        TCHAR m_teacherIp[21];
        LONG m_teacherPort;
        TCHAR m_teacherId[31];
        TCHAR m_teacherName[31];
        LONG m_teacherAuthorityLevel;

        DEFINE_COMMAND_EX(SelectLectureInfoWithTeacherInfoByAll,
                OLESTR(\"select a.lecture_num, a.lecture_title, \")
                OLESTR(\"  a.teacher_id, a.teacher_ip, a.teacher_port, \")
                OLESTR(\"  b.user_id, b.user_name, b.authority_level \")
                OLESTR(\"from lectureinfo a, userinfo b \")
                OLESTR(\"where a.teacher_id = b.user_id \")
                OLESTR(\"and b.authority_level <= 2 \")
                )

        BEGIN_COLUMN_MAP(SelectLectureInfoWithTeacherInfoByAll)
                COLUMN_ENTRY(1, m_lectureNum)
                COLUMN_ENTRY(2, m_lectureTitle)
                COLUMN_ENTRY(3, m_teacherId)
                COLUMN_ENTRY(4, m_teacherIp)
                COLUMN_ENTRY(5, m_teacherPort)
                COLUMN_ENTRY(6, m_teacherName)
                COLUMN_ENTRY(7, m_teacherName)
                COLUMN_ENTRY(8, m_authorityLevel)
        END_COLUMN_MAP()
};
typedef CCommand< CAccessor< SelectLectureInfoWithTeacherInfoByAll > >
QSelectLectureInfoWithTeacherInfoByAll;

항상 작명이 문제네 ㅡㅡ;;

그리고 쿼리 동적생성하게 할수는 없나요? 업데이트문 만들때가 특히 골치가 아픈 ㅠㅠ