If you want to set a default sort order for a CGridView, often used in admin views you can do so in the controller as part of the search() function:
$dataProvider = new CActiveDataProvider(get_class($this), array(
'criteria'=>$criteria,
'sort' => array('defaultOrder' => 'name')
));
A new law came into force on May 26th 2011 in the UK and Europe that affect websites and how they deal with the user flow of saving cookies to a visitors browser.
Previously websites could use cookies as much as they liked and we only limited by the browsers of the people visiting their websites, but as of late May the Privacy and Electronic Communications (EC Directive) Amendment Regulations 2011 require that certain information must be given to that site’s visitors and the user must give his or her consent to the placing of the cookies.
In english, that means that a site must ask all users permission before saving a cookie to their browser.
You can delete from multiple tables (which don’t have foreign keys set up) using one query if you create it using the following syntax:
Continue readingI love Postbox. I talk about it a lot. However Postbox is trying to be more than a mail client and as part of that is attempting to sneak into the world of GTD with the inclusion of todos and topics.
Now call me old fashioned but I use Things for my GTD stuff and so don’t use todos or topics in Postbox.
“Not a problem really is it?” I hear you yell. Well no until you look at the amount of space the topic row of Message View takes up. Believe me on a small screen this matters:
UPDATE `table_name` SET `field_name` = (SELECT CASE `field_name` WHEN 1 THEN 0 ELSE 1 END) WHERE `id_column` = 1
Or with text strings
UPDATE `table_name` SET `field_name` = (SELECT CASE `field_name` WHEN 'foo' THEN 'bar' ELSE 'foo' END) WHERE `id_column` = 1