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 below is required, the following 165 results were found.

  1. Change the default Joomla Error templatehttps://www.joellipman.com/articles/cms/joomla/change-the-default-joomla-error-template.html

    1.7.x, 2.5.x How? Backup the file \templates\system\error.php Create a replacement file called error.php including the below code Change the message "The Page you are looking for..." to what you want. Change the link "www.joellipman.com" to the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  2. ReCaptcha alternative: Integrate PlayThru in JComments 2.3 for Joomla 2.5https://www.joellipman.com/articles/cms/joomla/recaptcha-alternative-integrate-playthru-in-jcomments-for-joomla.html

    ReCaptcha. Note: There is a Joomla plugin for AYAH and this works for the user registration form. I installed it but the below details how to integrate the AYAH library with jComments. I will look at a solution using the installed plugin later. STEP #1:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  3. ReCaptcha alternative: Integrate PlayThru in JComments 3.0 for Joomla 3.2https://www.joellipman.com/articles/cms/joomla/recaptcha-alternative-integrate-playthru-in-jcomments-3-0-for-joomla-3-2.html

    ReCaptcha. Note: There is a Joomla plugin for AYAH and this works for the user registration form. I installed it but the below details how to integrate the AYAH library with jComments. I will look at a solution using the installed plugin later. STEP #1:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  4. Keyboard and mouse shortcuts in Google Chromehttps://www.joellipman.com/component/content/article/keyboard-and-mouse-shortcuts-in-google-chrome.html?catid=61&Itemid=165

    strokes and mouse clicks that you can use to perform specific actions. Knowing some of the Google Chrome shortcuts listed below can help save you time. Window and tab shortcuts Ctrl+N Opens a new window. Ctrl+T Opens a new tab. Ctrl+Shift+N Opens a new...

    • Type: Article
    • Author: Joel Lipman
    • Category: Google
    • Language: en-GB
  5. Upload file to Google Drive with PHP/cURL and API REST v3 (without Client Library)https://www.joellipman.com/component/content/article/upload-file-to-google-drive-with-php-curl-and-api-rest-v3-without-library-install.html?catid=61&Itemid=165

    https://www.googleapis.com/auth/userinfo.email https://www.googleapis.com/auth/userinfo.profile How? I've listed below 3 methods, the first follows the manual (or the logic thereof as I don't use the client library) and is a function sending two...

    • Type: Article
    • Author: Joel Lipman
    • Category: Google
    • Language: en-GB
  6. Google Drive API v3 - OAuth2 using Service Account in PHP/JWThttps://www.joellipman.com/component/content/article/google-drive-oauth-using-service-account-in-php.html?catid=61&Itemid=165

    > 5 Close off this if else statement (if time remaining > 5 minutes) here if you are not using the full script below. 8. Done That's it! You have an access token, your service account can connect directly with its Google Drive. To get a file listing,...

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

    To: Microsoft Windows 7 Pro Android Studio v0.8.6 beta Java Development Kit v1.8.0_20 What? The article below serves as a checklist to ensure I don't release an app that only displays maps to myself (again). Why? This took me a while to figure out so...

    • Type: Article
    • Author: Joel Lipman
    • Category: AndroidOS
    • Language: *
  8. SSIS Convert a string into a datehttps://www.joellipman.com/component/content/article/ssis-convert-a-string-into-a-date.html?catid=74&Itemid=165

    a quick article on how I got time conversion working in an SSIS package which read from a text file. Note that the example below converts a string in European Date Format (ie. "ddmmyyyy" to "dd/mm/yyyy"). Also, my data flow imports two dates one which...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  9. SSIS Skip Blank Rows in Flat File Sourcehttps://www.joellipman.com/component/content/article/ssis-skip-blank-rows-in-flat-file-source.html?catid=74&Itemid=165

    they programmed in. Apparently this problem also happens when you have a Data File of varying column numbers. My solution below will also fix this. How? My data file had some empty rows amongst the data. The easy fix is by dealing with any empty rows....

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  10. SSIS: How to loop through multiple flat files as data sourceshttps://www.joellipman.com/component/content/article/ssis-how-to-loop-through-multiple-flat-files-as-data-sources.html?catid=74&Itemid=165

    project, and data confidentiality is somewhat important, some of the images will be censored or data changed in the example below. Add a variable (preferably to the scope of the package) called "SourceExtractFile" and give it the data type "String". Set...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  11. Report Builder 2.0 - Hide Series1https://www.joellipman.com/component/content/article/report-builder-20-hide-series1.html?catid=75&Itemid=165

    report. I am guessing that Series1 is the data series from an outer join where the joining index value is null. The chart below has 3 series or data fields: Count the total number of incidents logged (Y-axis - data fields) Invidividual the incident(s)...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  12. SSRS / MDX Date Querieshttps://www.joellipman.com/component/content/article/ssrs-mdx-date-queries.html?catid=75&Itemid=165

    I find myself using date ranges endlessly as I've been working in SSRS. The below is derived from a collection of various sources across the web as well as some of my own. These are what worked in my environment: WinXP, BIDS (vs2008), TFS (vs2010), SSRS...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  13. SSRS Redirect after a report is runhttps://www.joellipman.com/component/content/article/ssrs-redirect-after-a-report-is-run.html?catid=75&Itemid=165

    #1 Create one report with all selectable reports as subreports - toggle visibilty based on parameter. Method #2 Add a button below "View Report" linked to some script code (requires change to ASP pages on the ReportingServer, ie. affects all reports on...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  14. Returning Oracle Stored Procedure Resultset in SSRShttps://www.joellipman.com/component/content/article/returning-oracle-stored-procedure-resultset-in-ssrs.html?catid=75&Itemid=165

    surrounded the input parameter between square parameters, example: [@StudentReference]. Fixing this resolved all 3 issues below!!! Encountered Issues ORA-01403 no data found & ORA-06512 something else - Fixed by specifying the query parameter properly...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  15. SSRS: Performance Improvements: SELECT TOPhttps://www.joellipman.com/component/content/article/ssrs-performance-improvements-select-top.html?catid=75&Itemid=165

    = '') AND (@GivenRef'' OR @GivenForenames'' OR @GivenSurname'' OR @GivenDOB'') For usability, we put a message just below the header which was an expression detailing what the report was displaying, so for example: -- If setting the limit to 100 records...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  16. 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

    leave). full access to a SharePoint 2007 site (team portal). Steps: Open your Outlook 2007 Using MS Internet Explorer (demo below is version 8), bring up your SharePoint Calendar Click on Actions Select Connect to Outlook Allow the website to open a...

    • Type: Article
    • Author: Joel Lipman
    • Category: SharePoint
    • Language: *
  17. Print Directory Contents to a Filehttps://www.joellipman.com/component/content/article/print-directory-contents-to-a-file.html?catid=80&Itemid=165

    to Windows 7). I added this option for him in Windows 7 Ultimate using the system registry (see "How: for Windows 7" below). -- yield a_subfolder_in_this_folder a_file_in_this_folder.txt another_file_in_this_folder.doc How? For Windows XP: Open an...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  18. Windows Live Mail Error ID: 0x8DE00005https://www.joellipman.com/component/content/article/windows-live-mail-error-id-0x8de00005.html?catid=80&Itemid=165

    sign. Add your account and tick 'Manually configure server settings'. Configure server settings complete as per the image below (changing the log-on username to your own): The downloading of all your folders will take a while so don't panic if you find...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: en-GB
  19. Search a database for a string (MySQL, T-SQL)https://www.joellipman.com/articles/else/database/search-a-database-for-a-string-mysql-t-sql.html

    my environment, to put them in one place on a website I've bookmarked (my personal site :c) My own with Typos Note that the below only prints out the SQL query to copy and paste into your SQL administration software. You can put a distinct on it (not...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: en-GB
  20. Search a database with SOUNDEXhttps://www.joellipman.com/articles/else/database/search-a-database-with-soundex.html

    Server 2008 R2 by 4000 characters in a variable (so I couldn't store it in a local variable). So the idea here is to run the below example which outputs a huge SQL query which you then copy & paste and run against your database. Step 1 of 2 The...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: en-GB
Results 121 - 140 of 165