Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-18243

MSSQL doesn't allow text or ntext columns in WHERE clause

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • 1.7.7, 1.8.8, 1.9.4
    • 1.7.7+, 1.8.9, 1.9.5
    • Database SQL/XMLDB
    • None
    • RedHat Linux, Apache 2.2.3, PHP 5.2.8, SQL Server
    • Microsoft SQL
    • MOODLE_17_STABLE, MOODLE_18_STABLE, MOODLE_19_STABLE
    • MOODLE_17_STABLE, MOODLE_18_STABLE, MOODLE_19_STABLE
    • Easy

    Description

      The data_filter() function in mod/data/filter.php has a SQL query that compares a text (or, in MSSQL, an ntext) column in a WHERE clause. MSSQL doesn't allow ntext columns in a WHERE clause, so the SQL statement throws errors.

      Attachments

        Issue Links

          Activity

            People

              stronk7 Eloy Lafuente (stronk7)
              luciandipeso Lucian DiPeso
              Andrew Lyons, Huong Nguyen, Jun Pataleta, Michael Hawkins, Shamim Rezaie, Simey Lameze, Stevani Andolo
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:
                13/May/09