I created a plugin the generates a query string that I want to pass into a exp:query on a template. Here is an example. If I run this generated query directly against the database it works fine but the template is not outputting any data.
Any ideas? Can I not run the exp:query where a plugin is returning the query to execute?
Example Template
{exp:query sql="{exp:data_search:search}"}
{col_1}, {col_2}, {col_3}, {col_4}
{/exp:query}Examle Query String Returned from Plugin
select field_id_63, field_id_64, field_id_65, field_id_66, field_id_67 FROM exp_channel_data where channel_id = 3 AND field_id_67 = 'xyz' AND field_id_64 = '2011'Packet Tide owns and develops ExpressionEngine. © Packet Tide, All Rights Reserved.