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

18 February 2010 2) Store both the formatted count and the value of column1.table in the next array entry Reverse this array Display the first 10 rows of this array (if we are doing a top ten) My new method is: SELECT column1, COUNT(*) AS CountOrder FROM table1 GROUP BY...

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

Project Plan for Freelance Websitehttp://www.joellipman.com/articles/web-development/project-plan-for-freelance-website.html

25 February 2010 process. It may look clean, clear, obvious... it's just an outline of what I picture as a perfect project; unfortunately the first 2 pages tend to be completed in just over a day and the rest of the time is spent faffing around with design and...

• Type: Article
• Author: Joel Lipman
• Category: Web-Development
• Language: *

Windows Live Messenger: Error 80048820http://www.joellipman.com/articles/microsoft/windows-os/windows-live-messenger-error-80048820.html

08 March 2010 the box next to Synchronize with an Internet time server is ticked Select an option from the dropdown menu starting with the first Click on the Update now button Text will appear beneath the button If you get an error, then select a different server...

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

Windows 7 Aero Featureshttp://www.joellipman.com/articles/microsoft/windows-os/windows-7-aero-features.html

27 April 2010 this was not my idea but quite ingenious and worth a mention. Did anyone else have any problems with Aero effects when they first installed Windows 7? What’s your favourite Aero feature or do you even use them? Let us know by leaving a comment.

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

Joes Word Cloud (JWC)http://www.joellipman.com/component/content/article/module-joes-word-cloud-jwc.html?catid=40

13 October 2010 View the module on your front-end to see if it does what you want it to do. Modify the module parameters as necessary. Setup First of all, you need to make it visible. These 3 steps will have your module ready: The further steps below are how to...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

Accessing a MySQL Database with Business Intelligence Development Studiohttp://www.joellipman.com/articles/database/mysql/accessing-a-mysql-database-with-business-intelligence-development-studio.html

05 January 2011 the "Shared Data Source" you just created > Next Click on the "Query Builder" button Right-click on any empty space in the first frame > Select "Add Table..." Add and specify the query as you would with any SQL query. (to create the dataset) Select the...

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

Returned a data type that is not validhttp://www.joellipman.com/articles/database/t-sql/returned-a-data-type-that-is-not-valid.html

06 January 2011 ORDER BY a.DateTimeStamp DESC) t1 GROUP BY CONCAT(MONTH(t1.Date), ' ', YEAR(t1.Date)) Caused by SQL statement returning first column date as CONCAT(MONTHNAME(t1.Date), ' ', YEAR(t1.Date)) AS Month Solved by changing SQL statement to t1.Date AS Month...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: *

Developer's Checklist: Taking over a projecthttp://www.joellipman.com/articles/web-development/developers-checklist-taking-over-a-project.html

01 March 2011 and still after 2 years there is no new site (blamed on the customer for not knowing what their application did in the first place... tut tut. How long have you been a developer? And this is new?). Can the developer be contacted? Yes! Questions to ask...

• Type: Article
• Author: Joel Lipman
• Category: Web-Development
• Language: *

The ReportServer Databasehttp://www.joellipman.com/articles/database/the-reportserver-database.html

08 August 2011 3=Snapshot, 4=History) Status nvarchar(32) NOT NULL either rsSuccess or an error code; if multiple errors occur, only the first error is recorded ByteCount bigint NOT NULL Size of rendered reports in bytes. RowCount bigint NOT NULL Number of rows...

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

SSRS Redirect after a report is runhttp://www.joellipman.com/articles/microsoft/ssrs/ssrs-redirect-after-a-report-is-run.html

12 August 2011 This article serves to describe several workarounds or proofs of concept. Why? We have a first report which acts like a search page. You enter the student you are looking for by reference or name and if there is only 1 result in the results page, then...

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

MySQL parameters in Excel 2007 PivotTableshttp://www.joellipman.com/articles/database/mysql/mysql-parameters-in-excel-2007-pivottables.html

24 August 2011 the name value... The one query to rule them all SELECT CONCAT(s.LogID, ' ') AS ActivityID, t.TeamName AS Team, CONCAT(u.Firstname, ' ', u.Lastname) AS StaffName, CASE WEEKDAY(s.DateTimeCreated) WHEN 0 THEN 'Monday' WHEN 1 THEN 'Tuesday' WHEN 2 THEN...

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

Excel PivotTable Filter List Orderinghttp://www.joellipman.com/articles/microsoft/excel/excel-pivottable-filter-list-ordering.html

05 September 2011 the filter, a dropdown appears with all available values listed. The Problem The values are listed in alphabetical order at first. If any new values come along then they get added to the bottom of the list... This is the problem. For example, if the...

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

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

04 November 2011 procedure. This requires using 2 data sources in SSRS. A user will specify the student reference in the parameters of the first report (the one with all the main details), as well as a job reference (for audit purposes) and click "View Report". The...

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

Basic Oracle Stored Procedure Structurehttp://www.joellipman.com/articles/database/pl-sql/basic-oracle-stored-procedure-structure.html

16 January 2012 to run standard PL/SQL commands... unless they're run from within a stored procedure. Our aim is to run a small query first to return the ID of the student, and then to use this number in a second query which we're hoping will be quicker than a...

• Type: Article
• Author: Joel Lipman
• Category: Oracle PL/SQL
• Language: en-GB

MySQL: Display Users and Duration in Matrix Timesheethttp://www.joellipman.com/articles/database/mysql/mysql-display-users-and-duration-in-matrix-timesheet.html

27 April 2012 the work: User Query $t_value = $the_team_id_that_i_want_to_look_at; $user_list_query=" SELECT DISTINCT u.UserID, CONCAT(u.FirstName, ' ', u.LastName) AS 'Fullname' FROM Users u WHERE u.StatusType NOT IN ('expired','guest','test account') AND...

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

Copy a table with structure and data into a temporary tablehttp://www.joellipman.com/articles/database/t-sql/copy-a-table-with-structure-and-data-into-a-temporary-table.html

03 August 2012 WHERE TABLE_NAME = @TableName ORDER BY ORDINAL_POSITION FOR XML PATH ('') ),1,1,'' ) + ';'; EXEC(@TableDeclaration); -- Get First Column Name SET @ColName=( SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = @TableName AND...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: *

Slideshow div layer through a windowhttp://www.joellipman.com/articles/web-development/mootools/slideshow-div-layer-through-a-window.html

11 September 2012 Replace contents of the hidden slide with contents of the displayed slide. Hide currently displayed slide to expose the first slide again (restores the starting position of "next slide"). The Gist Strategy This may not be a great idea, I'm just trying...

• Type: Article
• Author: Joel Lipman
• Category: MooTools Framework
• Language: *

Battery Constantly Drained on iPhonehttp://www.joellipman.com/articles/apple/battery-constantly-drained-on-iphone.html

27 November 2012 take notice but I think this is a brilliant example where trying to fix the problem is the very cause of the problem in the first place: The empty arrow next to the battery indicator tells you that location services is enabled but it is attached to a...

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

Licence GNU/GPLhttp://www.joellipman.com/static-items/licence-gnugpl.html

03 April 2009 holder is reinstated permanently if the copyright holder notifies you of the violation by some reasonable means, this is the first time you have received notice of violation of this License (for any work) from that copyright holder, and you cure the...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

Setup a copy of your Joomla websitehttp://www.joellipman.com/articles/cms/joomla/setup-a-copy-of-your-joomla-website.html

19 December 2012 » Compress your LIVE files into a ZIP and extract to TEST to copy over any hidden files. You only have to do this on the first refresh. For further refreshes, you can simply select all files in LIVE (except for configuration.php) and copy these to TEST...

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