Thread

Any help as to how to use CE image with an SQL query? it seems to return a blank.

{exp:query sql="SELECT d.upload_date, d.file_name, c.channel_name 
FROM exp_files d INNER JOIN exp_channels c
WHERE c.channel_name='portfolios' ORDER BY d.upload_date DESC LIMIT 4"}

{exp:ce_img:single src=
{title}

for some weird reason I can’t put this in the forum code but it should be :
img src=”{exp:ce_img:single src="{file_name}” width=“120” height=“60”}

Moved to Community Help forum by Moderator

Hi, stevo_s.

Unfortunately we can’t provide direct support for third party add-ons, you’ll need to contact the developer directly. In the mean time, moving to the Community Help forum.

Have you tried rel_path instead of file_name?

stevo_s,

Use single quotes when nested within double quotes and it appears fine in the forum

{exp:ce_img:single src=

What appears when you add this?

{exp:query sql="SELECT d.upload_date, d.file_name, c.channel_name 
FROM exp_files d INNER JOIN exp_channels c
WHERE c.channel_name='portfolios' ORDER BY d.upload_date DESC LIMIT 4"}
<h2>{title}</h2>
<p>{file_name}<br />
{/exp:query}

ok thanks.

stevo_s,

Did the query return something for {file_name}?