Thread

Assume {segment_2} = “hi-there”

I’m doing the following.

{assign_variable:foo="{exp:tag:tag_name}{segment_2}{/exp:tag:tag_name}"}

{foo} // outputs "hi there"

{exp:query sql='SELECT * FROM exp_weblog_titles WHERE title = "{foo"}'}

That query is processing as,

SELECT * FROM exp_weblog_titles WHERE title = "M00o93H7pQ09L8X1t49cHY01Z5j4TT91fGfr"

Why?

Andrew,

You problem here has to do with the Parse Order of the template.

Can I ask why you don’t just use this

{exp:query sql="SELECT * FROM exp_weblog_titles WHERE title = '{segment_2}'"}

This is a simplified version of what we’re doing really, but fundamentally we need the hyphen removed from the string.

I’ll have a look at parse ordering.

Thank you.

Andrew,

Why not use url_tile instead?

{exp:query sql="SELECT * FROM exp_weblog_titles WHERE url_title = '{segment_2}'"}

EE Docs :  Weblog Entries - Single Variables - url_title

Yep, like I said, that query is simplified, I’ve gotten around the problem though by placing the query in an embed and passing the variable.

All is well now thanks for your help 😊

Glad you found a solution. Feel free to post again if you have any more questions.