I’m using v2.0.1, build 2217 on Windows 7 x86. While modifying a query to use a global variable (DB_DATE_FORMAT), I noticed the syntax highlighting changed from being bright green to a dark green throughout the rest of the query. Queries below that display fine. I’ve attached a screenshot of the issue. I’m using the Dawn theme if that makes any difference.
Here is some text to copy/paste for troubleshooting purposes:
$result = $this->db->query("SELECT ah.id, ah.member_id, ah.create_date, ah.create_user_id, ah.status_id, IF(ISNULL(ah.period_historical_from), 'N/A', DATE_FORMAT(ah.period_historical_from, '". DB_DATE_FORMAT ."')) AS period_historical_from, IF(ISNULL(ah.period_historical_to), 'N/A', DATE_FORMAT(ah.period_historical_to, '". DB_DATE_FORMAT ."')) AS period_historical_to, IF(ISNULL(ah.period_projected_from), 'N/A', DATE_FORMAT(ah.period_projected_from, '". DB_DATE_FORMAT ."')) AS period_projected_from, IF(ISNULL(ah.period_projected_to), 'N/A', DATE_FORMAT(ah.period_projected_to, '". DB_DATE_FORMAT ."')) AS period_projected_to, IF(ISNULL(ah.period_adjusted_from), 'N/A', DATE_FORMAT(ah.period_adjusted_from, '". DB_DATE_FORMAT ."')) AS period_adjusted_from, IF(ISNULL(ah.period_adjusted_to), 'N/A', DATE_FORMAT(ah.period_adjusted_to, '". DB_DATE_FORMAT ."')) AS period_adjusted_to, IF(ISNULL(ah.bs_effective_date), 'N/A', DATE_FORMAT(ah.bs_effective_date, '". DB_DATE_FORMAT ."')) AS bs_effective_date, ah.cd_id, ah.is_consolidated,...");