If you have not already, login to the Control Center at
and from the menu item DATABASE select SQL and click on SQL QUERY TEST.
SQL Query Tester
This page is used to test your sql queries against your database without having to write a test page. Enter your query, without dynamic values, in the text area. Click ""Test Query"". If the query is a success it will return the results in a datagrid on the bottom half of the page. If it errors please look at the top of the page for the error.
- Check the query label to see if that was the query you were trying to execute.
- Dynamic values can cause the query to return either no results or error out completely. Do not use dynamic values.
- Table does not exist in database.
- Column does not exist in table. Try selecting all columns (*) first, then narrow the query down.
This page is meant to server as a quick test page, not an absolute results page. It was designed to enter static queries and return the results quickly. How you use it is entirely up to you.