[TYPO3] CoolUri: Value of an extension-parameter as part of the URL, but problems with special chars like inverted comma

lee perry leeperry at slack.de
Thu Mar 27 21:26:00 CET 2008


hello,

i'm using CoolUri and use the value of a parameter of an extension as 
part of the url - the problem is, this value is a string and so it could 
be a string like "O'Reilly" - and now i have the problem with the 
inverted comma. because of this inverted comma i've got three sql-errors:

1. SELECT * FROM link_cache WHERE url='search/O'Reilly'

2. INSERT INTO link_cache(url,params,crdatetime) 
VALUES('search/O'Reilly','a:5:{s:1:\"L\";s:1:\"0\";s:2:\"id\";s:2:\"22\";s:8:\"no_cache\";s:1:\"1\";s:26:\"tx_myextension_pi1[search]\";s:6:\"search\";s:25:\"tx_myextension_pi1[sword]\";s:8:\"O\'Reilly\";}',NOW())

3. INSERT INTO link_cache(url,params,crdatetime) 
VALUES('de/suche/O'Reilly','a:5:{s:1:\"L\";s:1:\"1\";s:2:\"id\";s:2:\"22\";s:8:\"no_cache\";s:1:\"1\";s:26:\"tx_myextension_pi1[search]\";s:5:\"suche\";s:35:\"tx_myextension_pi1[sword]\";s:8:\"O\'Reilly\";}',NOW())


i'm using the following xml-part in the CoolUriConf.xml:

<part key="([0-9]+)" regexp="1">
	<parameter>tx_myextension_pi1[sword]</parameter>
</part>

how i have to change the key for the regexpression, that i will get an 
url- and sql-clean word for instance without any inverted comma?

or any other ideas to solve the problem?


thanx and greetings,
lee


More information about the TYPO3-english mailing list