Installing phpBB3 for Joomla with a RocketTheme templatehttps://www.joellipman.com/articles/cms/joomla/installing-phpbb3-for-joomla-with-a-rockettheme-template.html

28 September 2009 Select the "Styles" tab. You should see a row with "Affinity" at the bottom. Click on "Install", set as default and that's it.... Well at least if everything went well for you it is.... Install RokBB3 for the first time (fresh install) Upload all the...

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

This file contains HTML or script code that may be erroneously interpreted by a web browserhttps://www.joellipman.com/articles/web-development/html/this-file-contains-html-or-script-code-that-may-be-erroneously-interpreted-by-a-web-browser.html

08 October 2009 MediaWiki LocalSettings.php file, we can fix this. For demo purposes, I'm going to make our system recognize SWF files (by default these are disallowed): Firstly: Add the following line to somewhere in the LocalSettings.php file in the web root folder...

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

Mediawiki Extension for Camtasia Studio SWF videoshttps://www.joellipman.com/articles/cms/mediawiki/mediawiki-extension-for-camtasia-studio-swf-videos.html

08 October 2009 moved to Camtasia Studio where their videos were displaying in good quality but as SWF files. This extension includes the default settings for "ExpressShow" in Camtasia Studio. My Setup MediaWiki v1.14.0 PHP v5.1.6 MySQL v5.0.45 Camtasia Studio v5.0 For...

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

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

13 April 2010 the pen. BTW I don't use the "remove device safely" rubbish as my old pen never did and it was fine for over a year. The default setup in windows XP is that it doesn't need it. Bulletproof, waterproof, fireproof, shockproof BUT NOT joe-proof!... I'm...

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

Add "Command prompt from here" to right-click context menuhttps://www.joellipman.com/articles/microsoft/windows-os/add-command-prompt-from-here-to-right-click-context-menu.html

27 January 2010 (this will be different on winnt, browse if unsure to your cmd.exe program) Click on OK > OK > Close Notes: Added by default since Microsoft Windows 7

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: *

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

27 April 2010 Under the visual effects tab you should see that the option “ Let windows choose what’s best for my computer “ is by default checked. Below it you should see a list of visual effects, some of which will be unchecked if you are not experiencing the full...

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

UTF8 Unicode PHP MySQL for International Charactershttps://www.joellipman.com/articles/web-development/php/utf8-unicode-php-mysql-for-international-characters.html

22 October 2010 Chinese, Hebrew, Russian, and Slovak. Fingers crossed this should work for all characters that Joomla! can handle by default anyway. Cause: Q. Why does this work for Joomla! articles and not for this module? A. Think this is because that module is...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB

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

05 January 2011 ever use TCP/IP Server is the server name (without the DNS suffix) or the IP address of the server Port should be 3306 by default User is the mysql username Database is your selection and should auto-populate if the connection is successful TEST > OK...

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

Formatting a date in an MDX queryhttps://www.joellipman.com/articles/database/t-sql/formatting-a-date-in-an-mdx-query.html

11 January 2011 NOW() vs TODAY() Noticed this when setting date as the parameter and trying to specify default date as today's in the format DD/MM/YYYY. Googled this but couldn't find an answer, then I just replaced "=NOW()" [yields: 01/01/2011 01:00:00] with...

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

Room Availability Calendar in Business Intelligence Development Studiohttps://www.joellipman.com/articles/microsoft/ssrs/room-availability-calendar-in-business-intelligence-development-studio.html

23 March 2011 big and then didn't allow cell to increase/decrease height). This way when it's printed out (backgrounds won't print by default) the occupied blocks will show up. =Switch(Fields!Status.Value="", "#ffffff", Fields!Status.Value="2", "firebrick",...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: *

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

29 March 2011 the textbox or the tablix has to be applied to both the textbox and tablix (as tablix doesn't show if resultset is empty by default anyway but still occupies a blank space which moves your textbox down...) Searches that got me nowhere ssrs display...

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

Joes FREE Website Thumbnailer (JWT)https://www.joellipman.com/component/content/article/joes-free-website-thumbnailer.html?catid=40

28 June 2011 containing all the images it just created. Take a picture Go to Tools > then select "Take a picture". Wait a few seconds (default is 15) for the program to do it's business and a dialog should alert you when it's done. To see the image it created, go to...

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

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

03 July 2011 Also note, this module will NOT generate thumbnails if you select "Public" as the authorized service group. I know it's the default option but you need to select an user group with higher privileges like "Super User". Installation: Install this module...

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

Run commands for Windowshttps://www.joellipman.com/articles/microsoft/windows-os/run-commands-for-windows.html

05 July 2011 System File Checker Utility (Scan On Every Boot) sfc /scanboot System File Checker Utility (Return Scan Setting To Default) sfc /revert System File Checker Utility (Purge File Cache) sfc /purgecache System File Checker Utility (Sets Cache Size to size...

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

SSRS Querying on either of 2 Parametershttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-querying-on-either-of-2-parameters.html

19 July 2011 should work: Apparently not because "fields cannot be used in report parameter expressions". I tried this with "Default values" and got the same problems. Note: before you try, "Variable values cannot be used in report parameter expressions" either. I'm...

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

Performance Report - Background colors based on dataset valueshttps://www.joellipman.com/articles/microsoft/ssrs/green-red-background-colors-based-on-dataset-values.html

02 December 2011 compare up to 4 reports and will compare the time taken for each one. The breakdown or what I was able to measure with the default installation are the times taken for "data retrieval", "processing", "rendering", and then the totals of these. I haven't...

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

DataJumble - Shuffling characters in a data valuehttps://www.joellipman.com/articles/database/t-sql/data-shuffling-function.html

01 August 2012 int; -- Format given value (prevents CHAR datatype issue) SET @OrigVal = LTRIM(RTRIM(@OrigVal)); -- Set variable default values SET @NewVal = ''; SET @OrigLen = DATALENGTH(@OrigVal); SET @CurrLen = @OrigLen; SET @LoopCt = 1; SET @DateVal = ''; --...

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

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

03 August 2012 @TableName varchar(50); DECLARE @TableDeclaration nvarchar(4000); DECLARE @SqlToExecute nvarchar(4000); -- Set variable default values SET @TableName = SUBSTRING(@SchemaTableName, CHARINDEX('.', @SchemaTableName)+1, LEN(@SchemaTableName)); SET...

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

Basic Joomla 2.5 Mootools Formhttps://www.joellipman.com/articles/cms/joomla/basic-joomla-25-mootools-form.html

20 August 2012 to get this to work: window.addEvent('domready', function() { $('myForm').addEvent('submit', function(e) { // Prevents the default submit event from loading a new page. e.stop(); // Set the options of the form's Request handler. // ("this" refers to the...

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

DataScramble - Randomizing data rowshttps://www.joellipman.com/articles/database/t-sql/datascramble-randomizing-data-rows.html

07 December 2012 varchar(max); -- Format given value (prevents CHAR datatype issue) SET @OrigVal = LTRIM(RTRIM(@OrigVal)); -- Set variable default values SET @NewVal = ''; SET @OrigLen = LEN(CAST(@OrigVal AS VARCHAR(max))); SET @CurrLen = @OrigLen; SET @LoopCt = 1; SET...

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