Fixing the Infamous “Maximum SOQL Limit” Error in Apex

|
| By Webner

The “Maximum SOQL Limit” error, often accompanied by the message System.LimitException: Too many SOQL queries: 101 is one of the most common and frustrating problems faced by Salesforce developers. It signifies a violation of a fundamental governing rule (governor limit)

CakePHP | How to change Epoch timestamp (unix timestamp) timezone in cakephp find query

| By Webner

Suppose we have a table cake_test with a column named modified that contains epoch values. CakePHP code: $options = array ( ‘fields’ => array ( “modified”, “to_timestamp(modified) as New__original”, “to_timestamp(modified) AT TIME ZONE ‘America/Denver’ as New__converted” ) ); $result =