We use cookies to improve your experience. No personal information is gathered and we don't serve ads. Cookies Policy.

ExpressionEngine Logo ExpressionEngine
Features Pricing Support Find A Developer
Partners Upgrades
Blog Add-Ons Learn
Docs Forums University
Log In or Sign Up
Log In Sign Up
ExpressionEngine Logo
Features Pro new Support Find A Developer
Partners Upgrades
Blog Add-Ons Learn
Docs Forums University Blog
  • Home
  • Forums

exp:query

Development and Programming

trevororr's avatar
trevororr
2 posts
12 years ago
trevororr's avatar trevororr

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'
       

Reply

Sign In To Reply

ExpressionEngine Home Features Pro Contact Version Support
Learn Docs University Forums
Resources Support Add-Ons Partners Blog
Privacy Terms Trademark Use License

Packet Tide owns and develops ExpressionEngine. © Packet Tide, All Rights Reserved.