FAQs

How to debug database queries

In CFv5 RC4 the query generated by a DB Read action isn't shown in the debugger output. Here's a way to show it.

In a Custom Code action in the On Submit event of your form temprarily add a Custom Code action with this PHP in it:

<?php
pr(\GCore\Models\MODEL_NAME::getInstance()->dbo->log);
?>

Replace MODEL_NAME with the model name set in the DB Read action. This will then display a list of queries, the last is the one executed by the DB Read action.

When you are finished debugging either comment out the // pr(. . . line in the code or delete the Custom Code action