Posted July 21st, 2011 by John
Over the past few weeks I have been creating an Application Programming Interface (API) for the Student Success eSolution (SSeS). Why does the SSeS need an API? Well, because numerous School Boards are achieving much success from the system and want to integrate directly to it. For some background, an API is a set of [...]
Tags: api, rest, sses, Student Success eSolution
Posted March 8th, 2011 by John
I have included a simple Java function to print data to a tab delimited file with the extension csv for the convenience of opening the file with Microsoft Excel. I found this very helpful in my last project and hope it will help someone else .
Tags: java
Posted December 2nd, 2010 by John
I have found that ExtJS is very useful in many of my web application projects, so I thought about posting some samples relating to overcoming specific obstacles that I have successfully overcome. The first problem I encountered pertained to the rigidity of declaring a GridPanel’s column model. For this instance I needed the column model [...]
Tags: extjs, grids
Posted June 6th, 2010 by John
MySQL has a relatively new feature very similar to a crontab job (Unix/Linux) or task scheduler (Windows) for scheduling and executing tasks. Ever since the release of MySQL version 5.1.6 MySQL “Events” or “temporal triggers” have been included. So what are they? Well you can now say: "I want the MySQL server to execute this [...]
Tags: events, mysql
Posted March 16th, 2010 by John
So you are looking for a simple way to log a history of changes to a table. There is a common practice for that, and it involves creating a logging function in your source code (maybe php) that will require you to connect to the database, and then write the values into the log table. [...]
Tags: mysql, triggers