Issue Details (XML | Word | Printable)

Key: MDL-16141
Type: New Feature New Feature
Status: Resolved Resolved
Resolution: Fixed
Priority: Minor Minor
Assignee: Tim Hunt
Reporter: Tim Hunt
Votes: 0
Watchers: 0
Operations

Add/Edit UI Mockup to this issue
If you were logged in you would be able to see more operations.
Moodle

Need an sql_position method

Created: 20/Aug/08 02:49 PM   Updated: 20/Aug/08 04:51 PM
Return to search
Component/s: Database SQL/XMLDB
Affects Version/s: 1.7.6, 1.8.7, 1.9.3, 2.0
Fix Version/s: 1.7.6, 1.8.7, 1.9.3, 2.0

Participants: Tim Hunt
Security Level: None
QA Assignee: Eloy Lafuente (stronk7)
Resolved date: 20/Aug/08
Affected Branches: MOODLE_17_STABLE, MOODLE_18_STABLE, MOODLE_19_STABLE, MOODLE_20_STABLE
Fixed Branches: MOODLE_17_STABLE, MOODLE_18_STABLE, MOODLE_19_STABLE, MOODLE_20_STABLE


 Description  « Hide
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.

 All   Comments   Change History   Version Control      Sort Order: Ascending order - Click to sort in descending order
Tim Hunt added a comment - 20/Aug/08 02:50 PM
Method implemented, with a unit test. I have only tested on Oracle, I would be really grateful if you (Eloy) could run the new unit test (in testdml.php) on the other databases we support. Thanks.