SQL-Join with multiple conditions when using Propel

Posted by Eric Bartels

Propels (Creole) “criteria infrastructure” is a great speed-up for the development process and makes it easy to “write” queries. However if you are forced to create a SQL-Join which requires multiple join-conditions the criteria-api is not a helper anymore. In order to make use of the criteria-api even in this case a “hack” can be [...]

Problems with Internet Explorer and application/json

Posted by Eric Bartels

My current project based on Symfony and YUI was developed using Firefox (and its great plugin Firebug) and Safari. It made heavy use of JSON. My Symfony action looked like public function executeSomething () { $this->getResponse ()->setHttpHeader (’Content-Type’, ‘application/json’); // … Do something return $this->renderText ($myJsonCode); } Nothing spectacular. This code works with Opera, Firefox [...]

Performance increase when using case-insensitive queries with Symfony, Propel and PostgreSQL

Posted by Eric Bartels

Symfony makes heavy use of Propel. Propel finds objects in the storage container using criteria. If you want to let Propel (okay the database) ignore the case you can set this in the criteria. $c = new Criteria ();   // Allow case sensitive searches $c->setIgnoreCase (true);   // Find all posts which name contains [...]