Blog

If you are running your site on SilverStripe CMS and need to migrate it to another machine but don't know how, you are at the right place.

A couple days ago we received an email from Twitter, informing us that someone had tried to reset password on our twitter account.

The email was:

There are many situations when it is needed to update one table from another table with SQL. We're providing the way we use all the time and it is also clear for understanding even for SQL beginners.

Here is the SQL code for updating one table from another table, just replace table and column names:

Syntax Highlighter is a fully functional self-contained code syntax highlighter in JavaScript developed by Alex Gorbatchev (http://alexgorbatchev.com/SyntaxHighlighter/) 
 
In our previous articles we described how to integrate Syntax Highlighter into SilverStripe CMS and how to remove green icon in Syntax Highligher.
 
However, many users reported that some browsers (Chromium, Firefox...) have problems with displaying scrollbars in Syntax Highligher.

As developers, we often work with SQL Server stored procedures. The SQL Server stored procedures can have many purposes.

One of them is to perform some logical operations and to return true or false value. The problem is that there is no boolean datatype so the only way is that stored procedure returns bit datatype.

Here is an example of stored procedure that will return bit value that could be used instead of boolean: