FruitBatInShades Code

Simple Permissions

The permission system is simple in design but allows complicted permissions to be created by layering the mixed key, role and level properties. The concept is that we have permissions that any item wanting to check just asks the permission system if the logged in user can carry out the action.  At its simplest form it is used thus: Read more…

I spent all weekend trying to convert a Sql Server db to a MySql v5 db and found it quite a frustrating experience!  When you’re sytnax is incorrect MySql helpfully says ‘You have an error in your sql syntax near:’ and error 1064. No help with which command causes the error and the position it picks for the start of the problem is usually wrong.  God we’ve been spoilt by Sql Server.

Read more…