Animetal
Posts: 27
|
| Posted: 06/06/2009, 7:42 AM |
|
I'm typing some custom expressions in SQL query and I want to see how CCS its sending it,
Is theres any way when I hit the search button can I see the query with the actual values from the search grid?
Maybe printing in the html body this is just for debuggin the query...
Thanks
|
 |
 |
melvyn
Posts: 333
|
| Posted: 06/06/2009, 9:29 AM |
|
Place a custom code in the event AfterExecuteSelect:
$sql = $Container->ds->OptimizeSQL(CCBuildSQL($Container->ds->SQL, $Container->ds->Where, $Container->ds->Order));
echo $sql;
It will show the query at the start of the page.
Melvyn
_________________
Melvyn Perez
Puro Codigo
http://purocodigo.com |
|
|
|
Animetal
Posts: 27
|
| Posted: 06/06/2009, 9:49 AM |
|
Thank you, that help me alot
|
|
|
|
|
