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

Need an sql_position method

    XMLWordPrintable

Details

    • New Feature
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • 1.7.6, 1.8.7, 1.9.3, 2.0
    • 1.7.6, 1.8.7, 1.9.3, 2.0
    • Database SQL/XMLDB
    • None
    • MOODLE_17_STABLE, MOODLE_18_STABLE, MOODLE_19_STABLE, MOODLE_20_STABLE
    • MOODLE_17_STABLE, MOODLE_18_STABLE, MOODLE_19_STABLE, MOODLE_20_STABLE

    Description

      The standard SQL POSITION(needle IN haystack) for finding out if one string contains another does not work on MSSQL or Oracle. I need to use this syntax for part of MDL-15605, so we need a compatibility method.

      Attachments

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved:
              15/Oct/08