SELECT
                    questionId,
                    title,
                    maxCharacter,
                    isRequired
                FROM
                    gvsite.adm_lor_question
                WHERE
                    majorId = <cfQueryParam VALUE="#form.majorId#" CFSQLType="CF_SQL_VARCHAR" />
                    AND isDeleted = '0'