CodeCharge Studio
search Register Login  

Web Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.

YesSoftware Forums -> CodeCharge Studio -> PHP

 Dynamically Modify Where

Print topic Send  topic

Author Message

Posts: 54
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?
View profile  Send private message

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.

CCS 3/4/5 ASP Classic, VB.NET, PHP
Melbourne, Victoria, Australia
View profile  Send private message

Posts: 54
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.
View profile  Send private message

Add new topic Subscribe to topic   

These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit

Web Database

Join thousands of Web developers who build Web applications with minimal coding.

Home   |    Search   |    Members   |    Register   |    Login

Powered by UltraApps Forum created with CodeCharge Studio
Copyright 2003-2004 by  and YesSoftware, Inc.