Creating a Top 10 chart with less codehttps://joellipman.com/articles/web-development/php/creating-a-top-10-chart-with-less-code.html

18 February 2010 I've decided to put something in here as it took me an age to find out how I could do it. This is when using a MySQL query within a PHP script. The process is used often to do a statistics table or top ten chart of your data (eg. movies, music, etc)....

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: *

Remove write-protect from USB pen in Windowshttps://joellipman.com/articles/microsoft/windows-os/remove-write-protect-from-pen-in-windows.html

13 April 2010 the disk size). I got badgered by my colleagues to splash out and get a worthwhile pen. Aside from some other failures, I decided to get the bulletproof, waterproof, fireproof, shockproof 32Gb USB Pretec Pen (as advertised by Gadget Show on Five.tv)....

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: en-GB

Inserting incremental weeks in MySQLhttps://joellipman.com/articles/database/mysql/inserting-incremental-weeks-in-mysql.html

15 April 2011 it will put these dates in automatically. Herein lies the problem The reason I'm doing this is for another system which decided to "cleverly" use the exports from CMIS Facility so that all the weeks correspond to the rest of the academic data....

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• Language: en-GB

SSRS Retrieving Oracle Stored Procedure Success or ErrorLevelhttps://joellipman.com/articles/microsoft/ssrs/ssrs-retrieving-oracle-stored-procedure-success-or-errorlevel.html

04 November 2011 level, and returned in a dataset for SSRS to complete the check. Instead of outputting the error code to our end-users, we decided to store the error code in the audit table and that in the eventuality of an error happening, the end-user would contact...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

How to Display Report Execution Time in SSRS (milliseconds)https://joellipman.com/articles/microsoft/ssrs/how-to-display-report-execution-time-in-ssrs.html

17 November 2011 considering the ReportServer database will be able to tell you how many milliseconds it took for a report to execute... I decided to do a database level calculation using two datasets: -- Oracle 10g: DataSet1 -- your normal dataset query with an added...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

How to change local folder for TFShttps://joellipman.com/articles/microsoft/tfs/how-to-change-local-folder-for-tfs.html

08 March 2012 instance and set my working local folder to my home directory. When the rest of my colleagues installed it however, they decided to use a common local directory for all workstations so configuration files would not need to be modified. So? Once...

• Type: Article
• Author: Joel Lipman
• Category: Team Foundation Server
• Language: *

DJI Phantom FC40 Paint-Job and AerialFreaks Cyclops FC40 Gimbal Upgradehttps://joellipman.com/articles/_other-misc/quadcopters/dji-phantom-fc40-paint-job-and-aerialfreaks-cyclops-fc40-gimbal-upgrade.html

04 September 2014 decided to repair the hull integrity of my DJI Phantom FC40 after a crash and sorta had the day off so... There are so many pictures because I wanted to be sure I could put it back together again, I'd recommend anyone who doesn't have a photographic...

• Type: Article
• Author: Joel Lipman
• Category: Quadcopters
• Language: *

Zoho Projects: Get All Eventshttps://joellipman.com/articles/crm/zoho/zoho-projects-get-all-events.html

22 July 2024 r_Projects = invokeUrl [ url: v_EndpointProjects type: GET connection: "my_projects_connection" ]; // // already decided as we only want one v_ProjectName = "My Project Board"; v_ProjectID = "1234567000001234567"; // // get all users (optional here)...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

MySQL day of week ending on Fridayhttps://joellipman.com/articles/database/mysql/mysql-day-of-week-ending-on-friday.html

26 April 2012 this Sunday -- 2012-04-29 -- this Sunday -- 2012-04-29 -- this Sunday Other Searches These didn't get me very far until I decided to write this article: DAYOFWEEK(myDate, 1) or WEEKDAY(mydate, 1) MySQL code for first and last day of week. Day of Week...

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• Language: en-GB

Mootools - How to contain a menu sidebar between header and footerhttps://joellipman.com/articles/web-development/mootools/mootools-how-to-contain-a-menu-sidebar-between-header-and-footer.html

10 August 2012 I hope I don't lose this note again. The only website that was titled similarly kept slowing down my computer too much so I decided to work out my own. The complexity is due to content also being dynamically resized in height. What? Basically I have a...

• Type: Article
• Author: Joel Lipman
• Category: MooTools Framework
• Language: en-GB