SQL Queries for Statisticshttps://www.joellipman.com/articles/database/mysql/sql-queries-for-statistics.html

13 December 2010 Basically, I've started using so much more SQL in our new Business Intelligence projects that I've been revising all my scripts to see what SQL I can optimize. One of my systems is a MediaWiki CMS which is used for the official Bournemouth University...

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

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

06 January 2011 or business intelligence development studio, you can specify in the report designer how to format the returned value to a more user-friendly date format (such as Month name then year - eg. November 2010). I have been told that data types are a nightmare...

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

Parameters not being used in report processinghttps://www.joellipman.com/articles/microsoft/ssrs/parameters-not-being-used-in-report-processing.html

07 January 2011 have), I found out you cannot declare the parameters used by the software within the SQL script... So the above should look more like this: -- =============================================================================== -- Description: Gets the room...

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

SSRS Hide results table if emptyhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-hide-results-table-if-empty.html

29 March 2011 version 2008 through combining Transact-SQL and MDX expressions" but boy what a mouthful, and it's not really iterating anymore. So it's "SSRS Hide results table if empty" though I will add that if you wanted to put a message instead of hiding the table...

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

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

15 April 2011 it, it should return the additional 52 rows we want add. Note that the table "WeekStructure" could have been any table with more than 52 rows, I'd say specify the table you will NOT be adding these rows to... SET @count:=0; SELECT '2012/2013' AS SetID,...

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

CSS keeping the footer at the bottomhttps://www.joellipman.com/articles/web-development/css/css-keeping-the-footer-at-the-bottom.html

25 April 2011 push layer which clears both (even though i had clear:both on the css for my #right div layer). For some reason, it has a more forceful effect in its own separate layer. In a joomla CMS template though, I wanted the "left" div to take over the whole...

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

Newbies guide to be the local computer guyhttps://www.joellipman.com/hardware/newbies-guide-to-be-the-local-computer-guy.html

28 April 2011 just to build up a client base and get some referalls. Put up a Web site describing your services. It makes you look more legit when you print it on your business cards. Hit up local colleges and post flyers there. If you’re going to market to college...

• Type: Article
• Author: Joel Lipman
• Category: IT Support
• Language: *

Joes Quicklist Weblinks (JQW)https://www.joellipman.com/component/content/article/joes-quicklist-weblinks-jqw.html?catid=40

03 July 2011 Services Thumbnail Services will give you a limited number of free thumbnail generations. About 100,000 on average which is more than enough for our Joomla! website (unless you're reinventing the wheel by making a Joomla! Google Directory). Let's say I...

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

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

08 August 2011 of summing the remaining columns? Correction, sum will only give me the total time but what if a report has been run twice more often then another, then is it slower? Not necessarily. Like all measures in bytes, I would like a thousand separator, and...

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

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

24 August 2011 off but after much Googling and Bing-ing, I still couldn't figure out how to do this. Hopefully this article will help you more than my search engine skills do. My Setup Windows XP Workstation...needs to open... Excel 2007 SP2...with ODBC to... MySQL...

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

Fun with DllCall in AutoHotkeyhttps://www.joellipman.com/articles/automation/autohotkey/fun-with-dllcall-in-autohotkey.html

27 September 2011 so there are more fun things to do out there. If you're the type of AutoHotkey programmer that doesn't like having to use the command prompt to write to an extra text file which your program has to read, then this is for you. DllCall will usually run...

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

Joes Network Transmission Detector (JTD)https://www.joellipman.com/component/content/article/joes-network-transmission-detector-jtd.html?catid=40

29 September 2011 just reads the size of packets sent and received. This allows me to test websites for example and compare page loads. It's more fun on a networked computer which is constantly writing back and forth to network shares, user profiles, browsing data, etc....

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

Migrate Joomla Users to WordPresshttps://www.joellipman.com/articles/cms/wordpress/migrate-joomla-users-to-wordpress.html

03 October 2011 -- NOTE THAT THIS IS DEPRECATED IN WORDPRESS 3.X a.name AS 'display_name' FROM my_joomla_db.jos_users a ORDER BY a.id; A bit more to do: PHP file So I needed to do a loop and rather than complicate things with stored procedures and cursors, it's likely...

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

Joes DNS Correction (JDC)https://www.joellipman.com/component/content/article/joes-dns-correction2.html?catid=40

25 November 2011 even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details. You should have received a copy of the GNU General Public License along with this program. If not, see . This software...

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

Getting the mysql where in delimited string to workhttps://www.joellipman.com/articles/database/mysql/getting-the-mysql-where-in-delimited-string-to-work.html

02 January 2012 delim, '')))/LENGTH(delim) + 1; -- get total number delimeters and add 1 -- add 1 since total separated values are 1 more than the number of delimiters -- start of while loop WHILE(ctr

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

Returning Oracle Stored Procedure Resultset in SSRShttps://www.joellipman.com/articles/microsoft/ssrs/returning-oracle-stored-procedure-resultset-in-ssrs.html

19 January 2012 resultset from an Oracle stored procedure and displaying this in SQL Server Reporting Services (SSRS). Well "non-productive" more than "fun" as most of the examples on the net are either half-complete or partially documented. So here goes... Using...

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

Connect to Joomla database in standalone scripthttps://www.joellipman.com/articles/cms/joomla/connect-to-joomla-database-in-standalone-script.html

17 August 2012 injection facility in this example is the "mysqli_real_escape_string" function applied to a number. You will need to be more vigilent. Variables are all cleared and redefined. To pass a value to this script you have to use the $_GET, $_POST or $_SESSION...

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

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

11 September 2012 position:relative; float:left; } The JS/Mootools Part Apologies for the mess as the solution I'm working on is far more complex and I need to keep extracting the basic mechanisms of this to demo here. Under Construction! window.addEvent('domready',...

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

Sync Outlook 2007 Shared Calendar with SharePoint 2007https://www.joellipman.com/articles/microsoft/sharepoint/sync-outlook-2007-shared-calendar-with-sharepoint-2007.html

09 November 2012 key dates and deadlines popup which a single user assigned as "calendar manager" may have missed. Not automated? No but far more manageable when using Outlook 2007 instead of the SharePoint 2007 web interface... Other Searches Import Outlook 2007...

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

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

19 December 2012 More for others than for myself, but this article is for those who do not have development/test environments of their Joomla website. I have been doing this for years and still come across clients who have the one version of their website. They...

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