Thread

I have this query in a template. The idea is that it will embed an empty Safecracker form if an entry for that user doesn’t already exist, but it does not work. If there are no results, nothing happens. Not sure why. It does display an entry if one exists.

{exp:query sql="SELECT entry_id FROM exp_channel_titles WHERE channel_id = '18' AND author_id = '{member_id}'"}
 {embed="dashboard/.profile" entry="{entry_id}"}
 {if no_results}
  No results.
 {/if}
{/exp:query}

Hi Geoff,

Have you turned on the Output Profiler yet? That’ll let you see the actual query that’s being run, and I suspect you’ll see what the problem is.

Without looking at your actual site and template, my guess is that because the {member_id} is parsed very late in the parsing order, it’s not available yet when the Query module needs it. Therefore the query isn’t actually what you expect it to be.

I’m not 100% sure about this, but have you tried using the {logged_in_member_id} variable instead? I think that one parses sooner than {member_id}, so that might work.

Kevin,

We’re thinking it’s possibly a User module issue. I’ll report back as I learn more. Thanks.

Geoff

Sure thing, let me know when you find something!