IceBB : THe Story (Part II)

We are now less than 1 hour till mid-night, that means, all this 2 week of sweat and tears momment will end. We know that theres too much thing to be handle by just three man working on this project, added task at work.
 
The significant thing that we learn from this project is Database layer called Zend db. We surely will continue using Zend db as our Db Layer because the way that they generate the sequal is impresive. As developer that usually using MySQL, limiting the select is easy. just put LIMIT at the back or the sql syntax (etc. SELECT * FROM abc LIMIT 1) and you done.
 
But when come to MSSQL, the same result need to be converted into SELECT TOP 1 * FROM abc. You know how the pain is to change just between MySQL to MSSQL, how about others? added with LEFT JOIN and UNION?
 
But with Zend db, it just as simple as $db->select()->from('abc')->limit(1) and just leave it there for Zend to convert your sql into selected database type. That the reason we choose it, and also IceBB team.
 
 

 
Hopefully, from what we get here (in this two week time), can bring something back to the community. For everyone who involve in this event, thank you and all the best.
IceBB in IIS and MSSQL for LAMP2WIN