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

08 October 2009 These were awkward to configure a full screen button on the controls and do basic customization. Our screen recorder was also not displaying the captions of the video unless it was an AVI file that we converted to FLV. The quality was horrible. Then we...

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

Change default order of weblinkshttps://www.joellipman.com/articles/cms/joomla/change-default-order-of-weblinks.html

15 November 2009 of your links have http and some don't description - not recommended! date - the one I use for most recent created - this is also a date formatted field modified - and this is a date formatted field hits - number of times that weblink has been visited...

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

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

25 February 2010 to be finalised (this is content that will exist on project closure) Instructions for modifying content (textual mostly but also image uploads) Create custom documentation for front-end use Create custom documentation for back-end (admin panel) use....

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

Webdeveloper-Speakhttps://www.joellipman.com/articles/web-development/webdeveloper-speak.html

13 July 2010 potential customer to self-select the services they wish to subscribe to, and how any information they provide may be used. Also referred to as permission-based marketing. Section 508 Section 508 is an amendment to the United States Workforce...

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

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 is a note to myself but also to anyone out there who's spent as long as I did looking for a solution to this. Maybe it's just me but this is the scenario: Joomla works fine with international characters A Module Extension I wrote for Joomla! displayed...

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

Create Read-Only Database User in SQL Serverhttps://www.joellipman.com/articles/database/create-read-only-database-user-in-sql-server.html

09 November 2010 of the db_owner fixed database role can perform all configuration and maintenance activities on the database, and can also drop the database. db_securityadmin Members of the db_securityadmin fixed database role can modify role membership and manage...

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

Merge the content of two similar tables in MySQLhttps://www.joellipman.com/articles/database/mysql/merge-the-content-of-two-similar-tables-in-mysql.html

11 January 2011 and its design is property of SomeoneElse.com Obviously the two above tables are very similar with different column names. I also don't want the data to produce double the number of columns. My Solution SELECT title, intro FROM ( SELECT `title`,...

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

PHP & MySQL Search Enginehttps://www.joellipman.com/articles/web-development/php/php-a-mysql-search-engine.html

09 March 2011 $display_excerpt=search_highlight($result_Content, $terms_rx)."..."; I like to include a "Did-you-mean" section which I also use for any AJAX suggestion feature (be flexible with us as some customers have asked how does it get that word and why is it...

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

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

15 April 2011 The developer felt that as long as you adjust the script each year you could make the system last another year. Shame he also forgot the academic year ends halfway in a normal people's calendar, so you actually have to adjust this twice a year....

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

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

01 March 2011 receives/returns) Anything to add? I welcome any suggestions/improvements to the above. Just add a comment to this page. Also if you want to share your nightmare project takeovers, they're always fun to hear about.

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

CSS Background Without Causing Scrollbarshttps://www.joellipman.com/articles/web-development/css/css-background-without-causing-scrollbars.html

23 April 2011 horizontal scrollbar which is a bit annoying because you scroll to the right and theres nothing but some background image. Also the footer was at 100% so it got cut off if you scrolled horizontally. Aim / Objective To have a background of sky and grass...

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

Creating a Profile Plugin for Joomla 1.6https://www.joellipman.com/articles/cms/joomla/creating-a-profile-plugin-for-joomla-16.html

27 April 2011 subfolder called "profiles". So I should end up with the following file/directory structure: ./profile5 ./profile5/profiles Also copy one of those handy blank "index.html" files into each of these folders in case "directory listing" gets enabled on your...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• 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 guarantees a happy customer. "So this is all I could fix in the time I have, all your issues have been dealt with and I also did this..." "So this is what I've quickly put together for demo purposes."

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

What's the problem? Amusing computer issueshttps://www.joellipman.com/articles/web-development/whats-the-problem-amusing-computer-reports.html

28 April 2011 in a partner institution: "By the way my printer has stopped working, in fact it hasn't been working for ages, could you also look at that". "Is there a power light on when you switch it on?". "Yes it's definitely plugged in if that's what you're...

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

SSRS External Images don't displayhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-external-images-dont-display.html

19 September 2011 the "Unattended User Account" can see the photos. - This solved the problem for us Some forums suggested to put this user also in the "Browser" roles of the Reporting Manager Problem #2: Alternative image if file does not exist We don't have photos for...

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

T-SQL Record Separatorhttps://www.joellipman.com/articles/database/t-sql/t-sql-record-separator.html

11 October 2011 NULL NULL NULL NULL NULL */ Note that my data is inaccurate as the last row of each grouped data has been changed to NULL. Also note how the actual select query is pulling data from my CTE in its post-formatted form. I perform all the formatting within...

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

SSRS Zero Paddinghttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-zero-padding.html

10 November 2011 error usually returns in the format of -12345. If we want to look them up the error is ORA-12345. Unfortunately Oracle also returns errors of less than 10000 so ORA-00201 would actually be returned as "-201". As I wanted a link so that the user can just...

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

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 is the "Value", just in case you didn't pick up on this. If no type is specified (type=2) then datasources and folders will also show. The Side-by-Side Table As you know, most datasets will return the rows as... rows. My pic above shows my 4 reports...

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

SSRS Dropdown parameter cannot be blank!https://www.joellipman.com/articles/microsoft/ssrs/ssrs-dropdown-to-allow-blank-values.html

14 December 2011 that Microsoft are so very fond of. You will need to use your own head to match the datatypes for including a dummy row. Also note that because I don't have any options matching the ID above ("000000-0000-..."), this worked perfectly for me as my report...

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

Migrate JComments from Joomla 1.5.x to Joomla 2.5.xhttps://www.joellipman.com/articles/cms/joomla/migrate-jcomments-from-joomla-15x-to-joomla-25x.html

07 June 2012 all JComments settings are what you want using the Joomla Admin interface. If the article IDs match then the comments will also match. If however your article IDs don't match in both versions of your site, consider using the following update script,...

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