Lumped all the different view-pages' query into one thus drastically slashing the amount of code that looks subtly different but effectively always retrieves calendar items for a particular interval.
The date format string is constant - it is always the ANSI date format. There is no need to create a variable in TCL and then pass it on as a bind variable to the database. Instead I have hard-wired the format string into the database which means less code and maybe even slightly more efficiency.
Loading ...