Advanced Search

Here are a few examples of how you can use the search feature:

Entering this and that into the search form will return results containing both "this" and "that".

Entering this not that into the search form will return results containing "this" and not "that".

Entering this or that into the search form will return results containing either "this" or "that".

Search results can also be filtered using a variety of criteria. Select one or more filters below to get started.

Assuming their is required, the following 133 results were found.

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

    migrators out there and they all seem to have this problem. I'm really keen not to ask all my users to have to change their passwords but that is what the commercial applications are doing. The script to transfer users This is a free solution to at...

    • Type: Article
    • Author: Joel Lipman
    • Category: Wordpress
    • Language: en-GB
  2. Mediawiki Extension for Camtasia Studio SWF videoshttps://www.joellipman.com/articles/cms/mediawiki/mediawiki-extension-for-camtasia-studio-swf-videos.html

    video unless it was an AVI file that we converted to FLV. The quality was horrible. Then we 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...

    • Type: Article
    • Author: Joel Lipman
    • Category: MediaWiki
    • Language: en-GB
  3. Change the login link in MediaWikihttps://www.joellipman.com/articles/cms/mediawiki/change-the-login-link-in-mediawiki.html

    staff and different localgroups. When users click on the 'Login' link, we want the system to automatically prompt them for their username/password. (Kerberos authenticated, as opposed to NTLM authenticated). Note: This article is displaying how to...

    • Type: Article
    • Author: Joel Lipman
    • Category: MediaWiki
    • Language: en-GB
  4. Android: Keytool and Google Maps displaying greyhttps://www.joellipman.com/articles/else/app-dev/android-os/android-keytool-and-google-maps-displaying-grey.html

    console). [Optional] To use the keytool: If you know the command prompt, you know that you have to refer to each tool using their full path unless you add it to the PATH environment variable: This allows you to use keytool from any folder: Open a...

    • Type: Article
    • Author: Joel Lipman
    • Category: AndroidOS
    • Language: *
  5. SSIS Multiple Lookups in onehttps://www.joellipman.com/component/content/article/ssis-multiple-lookups-in-one.html?catid=74&Itemid=165

    to multiple lookups in SSIS. For any SSIS developer trying to create packages that need to decode a number of values into their full name/description (eg. "M" to "Male", "Prof" to "Professor"). Why? Our extract phase in the SSIS package takes data from...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  6. SSRS Parameters in Oracle Stored Procedurehttps://www.joellipman.com/component/content/article/ssrs-parameters-in-oracle-stored-procedure.html?catid=75&Itemid=165

    that got me nowhere Well not entirely true, there were solutions and tidbits but everyone had a different setup to us and their solutions were complex coding solutions and ultimately the wrong route as we worked out our own solution. ssrs run oracle...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  7. SSRS Dropdown parameter cannot be blank!https://www.joellipman.com/component/content/article/ssrs-dropdown-to-allow-blank-values.html?catid=75&Itemid=165

    I have created an SSRS report which can compare 4 reports side by side and brings up their latest execution times to the nearest millisecond. The report has 4 parameters. Each parameter is a dropdown populated by a list of all available reports. Why? I...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  8. Sync Outlook 2007 Shared Calendar with SharePoint 2007https://www.joellipman.com/component/content/article/sync-outlook-2007-shared-calendar-with-sharepoint-2007.html?catid=77&Itemid=165

    to open the event and specify the recurrence rate. Sharing is Caring Now my colleagues have set up the calendar in their instances of Outlook, they can also add to the calendar quite easily as we used to use an Outlook Shared Calendar before. We see...

    • Type: Article
    • Author: Joel Lipman
    • Category: SharePoint
    • Language: *
  9. Windows 7: System Clock is constantly going out of synchttps://www.joellipman.com/component/content/article/windows-7-system-clock-is-constantly-going-out-of-sync.html?catid=80&Itemid=165

    The Issue People have reported that although they have manually set the date/time on their computer, this gets changed by the windows time server (time.windows.com) when connected to the Internet and for some reason it doesn't display the right...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  10. Windows OS: Alt Codes / Symbols / Special Charactershttps://www.joellipman.com/component/content/article/windows-os-alt-codes-symbols-special-characters.html?catid=80&Itemid=165

    are enabled. Which numbers you might ask? Well every character is built of a collection of digits that are to be entered in their specific order. Search for "Alt Codes" or "Symbol Codes" in a search engine for a full list. Meanwhile, here's some that...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  11. Error during processing - Converting Date/Timehttps://www.joellipman.com/articles/else/database/t-sql/error-during-processing-converting-datetime.html

    error and STFW'd for ages following complex T-SQL Timestamp conversions but to no avail. Not saying that you shouldn't try their solutions but just check you haven't done this silly mistake. I'm only guessing the same error would happen in Report...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: *
  12. Returned a data type that is not validhttps://www.joellipman.com/articles/else/database/t-sql/returned-a-data-type-that-is-not-valid.html

    I have been told that data types are a nightmare in SQL Server Reporting Services and that all data types should be kept in their original state and then queried in the same state.

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: *
  13. DataJumble - Shuffling characters in a data valuehttps://www.joellipman.com/articles/else/database/t-sql/data-shuffling-function.html

    but it depends on what you mean by "scrambling". This is a function which merely uses the same characters but switches their order randomly, so I've renamed it DataJumble as opposed to my article on Data-Scrambling. Why? We want to scramble sensitive...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: *
  14. Compare two databases using T-SQLhttps://www.joellipman.com/articles/else/database/t-sql/compare-two-databases-using-t-sql.html

    site that is StackOverflow: SELECT * FROM INFORMATION_SCHEMA.COLUMNS Run this command against both databases and you have their full schemas. Use a comparison tool to compare the outputs. Method #2 Enhancing the above which does a little more of the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
  15. MySQL: Find records in one table that are not in another.https://www.joellipman.com/articles/else/database/mysql/mysql-find-records-in-one-table-that-are-not-in-another.html

    like. I like queries against this database because it involves linking a lot of tables and outputting... just articles and their titles. I have another table holding the audit trail of content approvers on the system. Approvers can e-sign an article...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  16. Inserting incremental weeks in MySQLhttps://www.joellipman.com/articles/else/database/mysql/inserting-incremental-weeks-in-mysql.html

    Situation: I have a silly database table (not mine) storing CMIS Facility week numbers and their starting dates. For those of you unfamiliar with this system, the reason week numbers are different to normal people's week numbers is because these are...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  17. Error 1065: Query was Emptyhttps://www.joellipman.com/articles/else/database/mysql/error-1065-query-was-empty.html

    when newline, carriage returns and tab characters are entered in the data. Those who are security-conscious will also make their system escape apostrophes (') and double-quotes ("). But who can honestly build a system that thinks of everything from day...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: *
  18. Project Plan for Freelance Websitehttps://www.joellipman.com/articles/cms/website-development/project-plan-for-freelance-website.html

    (or text) to JoelLipman.Com (can be uploaded using the project management system). Content Review List all pages (and their web address) published on the website Spelling, grammar checks Comments, changes, suggestions, additions, exclusions...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
  19. Webdeveloper-Speakhttps://www.joellipman.com/articles/cms/website-development/webdeveloper-speak.html

    based in Wellington, New Zealand providing consultation, website design, development and usability evaluation services." Their website has initiated a Web Definition Glossary (there are others but this one's got that "kiwi" approach) A few terms I...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
  20. 301 Redirect using htaccess filehttps://www.joellipman.com/articles/cms/website-development/301-redirect-using-htaccess-file.html

    me the good part of an hour just to find out, I'm posting it here so I never have to look for it again. A client changed their website domain address and wanted any person visiting the old domain to be redirected to the new domain. Why? I warned that a...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
Results 101 - 120 of 133