dbQuery

DataBase (db) Query placeholder affords the option of retrieving a result from the database displaying the FIRST result. If you want more then one result, review the dbReport placeholder.

Example: /playground/dbQuery

Warning: Potential for abuse exists in the form of an SQL injection attack.

The dbQuery placeholder has one Custom Attribute:

• query - the SQL query where the first row, first column returned is displayed.

SELECT COUNT(*) FROM web_page where WP_Status_ID='1'

All tables in the CMS may be queried, including the _Forms.

This demonstrates the render.

<placeholder_dbquery query="SELECT COUNT(*) FROM web_page where WP_Status_ID='1'" />pages.