Does Query Module Allow MySQL Functions?
Development and Programming
15 years ago
I want to place the following in a exp:query tag
SELECT REPLACE(page_name,"_"," ") As wiki_title, UCASE(page_namespace) As page_namespace, page_name
FROM exp_wiki_page
ORDER BY exp_wiki_page.last_updated DESC
LIMIT 5The idea being to return the last 5 wiki entry updates but having a title that can be used in a hyperlink i.e. one that doesn’t have the “_” underscore to separate the words.
I know the SQL is valid but within the EE query tag it throws an error. Is it that the query tag doesn’t like SQL functions?
15 years ago
are you using double quotes around the query for the sql parameter?
{exp:query sql="query goes here"}If so, you’ll need to replace your double quotes within the REPLACE function with single quotes.
15 years ago
Indeed I was - so busy looking for the hard reasons that I forgot to look for the obvious!
Many thanks