[TYPO3-core] RFC: Bug #9442: SQL LIKE wildcards are not escaped correctly for list queries

Oliver Hader oliver at typo3.org
Wed Oct 1 17:17:00 CEST 2008


FYI: Committed to SVN:
* TYPO3_4-2 (rev. 4265)
* Trunk (rev. 4266)

olly


Oliver Hader schrieb:
> The first patch was created from the Hackontest branch and was wrong. I
> attached the correct one...
> 
> olly
> 
> 
> Oliver Hader schrieb:
>> This is a SVN patch request.
>>
>> Problem:
>> Using t3lib_db::listQuery('some_Tag') - and knowing that "_" and "%" are
>> wildcard characters in SQL LIKE statements - will produce wrong result
>> sets.
>>
>> Solution:
>> Escape "%" and "_" correctly when they are used in a LIKE statement.
>>
>> Bugtracker references:
>> http://bugs.typo3.org/view.php?id=9442
>>
>> Branches: TYPO3_4-2, Trunk
>>
>> olly
-- 
Oliver Hader
TYPO3 4.3 Release Manager


More information about the TYPO3-team-core mailing list