CiviCRM Community Forums (archive)

I am using CiviCRM to execute the following SQL:  "SHOW CREATE TRIGGER `civicrm_contact_before_insert`"

But one of the field names returned is "SQL Original Statement". My syntax to get the field is not working because of the spaces: 

$dao->SQL Original Statement
What syntax should I use to get the field "SQL Original Statement"

Thanks,

I tried single quotes
 $dao->'SQL Original Statement';
and get the error message:

Parse error: syntax error, unexpected ''SQL Original Statement'' (T_CONSTANT_ENCAPSED_STRING), expecting identifier (T_STRING) or variable (T_VARIABLE) or '{' or '$' in /home/dev17/public_html/test/myscript.php

Those docs were helpful - it seems the only option is to turn the result set of fields into an array.  So I called the following method:

 $dao = & CRM_Core_DAO::executeQuery(" SHOW CREATE TRIGGER `civicrm_website_after_delete" ,    CRM_Core_DAO::$_nullArray ) ;
 $tmp =  $dao->toArray();
 print_r( $tmp );
The code runs without error, but the resulting $tmp array is empty.  Does CiviCRM need to implement this method?

The syntax  {'SQL Original Statement'} did not blow up.   Also I got the syntax for toArray(); is working too. By working, I mean not blowing up or throwing an error message.    However, the weird issue I am having is there is no data in the field "SQL Original Statement", even though I am able to get the data for the other fields, such as character_set_client.