Textpattern CMS support forum
[Solved] SQL Select and single quote into records
Hi TXP experts!
I’m having a problem with an SQL query due to the use of a single quote sign (
') within one of the article title:
implode(',', safe_column('ID', 'textpattern', '1=1 AND Section="one-section" OR Section="another-section" ORDER BY SUBSTRING_INDEX(Title, "@", -1) LIMIT 0, 999'))
The corresponding title isn’t extracted… 😢
Is there a way to got safe results?
Thank you lot by advance. 😉
EDIT: The problem isn’t due to the use of a single quote, the query extract only 10 results…
Last edited by Pat64 (2021-10-30 09:28:14)
Re: [Solved] SQL Select and single quote into records
Whoops. I’m the worst Textpattern user from this forum: I omitted to set the limit parameter within my article_custom tag…