[TYPO3-core] RFC: #14615: Autosuggest function doesn't work with quotes

Martin Kutschker masi-no at spam-typo3.org
Fri Jun 4 08:31:38 CEST 2010


Steffen Kamper schrieb:
> Hi,
> 
> this is SVN patch request.
> 
> Type: bugfix
> 
> Branches: trunk, 4_3
> 
> BT reference: http://bugs.typo3.org/view.php?id=14615
> 
> Simple example: create a page with title 'havequote.
> Now try to find this page in autosuggest, example: page, type shortcut,
> Shortcut to page. Type 'ha => no results.
> 
> This is because this search gives an SQL error because of unescaped quote.
> 
> Solution: quote it.

+1 b reading.

> There would be a second solution as the escapeStrForLike-function is
> already called. I'm not sure, but shouldn't the function also take
> quotes into account?

I don't think so. Quotes don't affect LIKE (only $ and _ are meta characters).

Masi


More information about the TYPO3-team-core mailing list