PCHome
Posts: 57
|
| Posted: 01/27/2014, 11:37 AM |
|
I've done this countless times and know how to do it but in this case, nothing was happening so I tried echoing the WHERE to the display yet nothing appears.
//End recording_review_ds_BeforeBuildSelect
//Custom Code @413-2A29BDB7
echo $recording_review->ds->Where;
Then I tried echoing the entire query, using the sample directly from the CCS Help but all I get on the screen are the titles:
echo "SQL: " . $recording_review->ds->SQL . "<br>";
echo "ORDER BY: " . $recording_review->ds->Order . "<br>";
echo "WHERE: " . $recording_review->ds->Where . "<br>";
How could it NOT find the WHERE from the query which was created in the Query Builder (rather than manually)?
I remember that older versions of CCS had a special diagnostic function for showing the complete query but I couldn't locate it on v5.1. Is it gone?
|
 |
 |
eratech
Posts: 513
|
| Posted: 01/30/2014, 7:39 PM |
|
Hi - I think the db_mysql.php file has a $debug around line 27 (assuming you are using MySQL)
Set to 1 and publish - all the queries for a page will be echo'd on the page.
E
_________________
CCS 3/4/5 ASP Classic, VB.NET, PHP
Melbourne, Victoria, Australia |
|
|
|
PCHome
Posts: 57
|
| Posted: 01/30/2014, 7:54 PM |
|
Thank you, yes, MySQL so I'll give it a try. I know there used to be a CCS function too for doing this but it seems to have disappeared. Even when I used to use it many years ago, it was only after Yes support told me about it that I knew it existed as it was nowhere to be found in the Help files. The problem I posted seems to be limited to a single page's grid so far out of a couple I tested.
|
|
|
|
|
