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

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

    (Operations > Copy to... > untick "Create Database") Done! and you have all the necessary backups for a restore point. Additional Notes Don't forget the .htaccess file for Search-Engine Friendly (SEF) website addresses as a lot of web-based file...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  2. Joomla Component: Set default params on installationhttps://joellipman.com/articles/cms/joomla/joomla-component-set-default-params-on-installation.html

    $query->where($db->quoteName('name') . ' = ' . $db->quote('com_XXX')); $db->setQuery($query); $db->query(); } } } Additional: ACL during install My component is editable by registered users only. This meant that everytime someone installs the component,...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  3. ReCaptcha disappears from Joomla 2.5 Registrationhttps://joellipman.com/articles/cms/joomla/recaptcha-disappears-from-joomla-2-5-registration.html

    // Replace YOUR_KEY with your public key return ' window.onload = function() { Recaptcha.focus_response_field(); } '; } Additional This applies to a case where the code WAS working and without any changes to the server (no updates), and the recaptcha...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  4. Upload file to Google Drive with PHP/cURL and API REST v3 (without Client Library)https://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

    { "kind": "drive#file", "id": "1srXLU-lotsofalphanumericcharacters_", "name": "my_video.mp4", "mimeType": "video/mp4" } Additional: Why not? Let's add a description and some security where we disable download, sharing, etc. to the viewers (except the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Google
    • Language: en-GB
  5. MessageBox or AlertDialog in Android Javahttps://joellipman.com/articles/else/app-dev/android-os/messagebox-or-alertdialog-in-android-java.html

    { public void onClick(DialogInterface arg0, int arg1) { // Some stuff to do when cancel got clicked } }) .show(); Additional: Pre-populating default value and returning input Lots of confusing answers out there on the web but here's an all-in-one where...

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

    I'm not saying it won't fix a problem for you, just that downloading from the Play store was unrelated to the above. Additional: If you forget your key (like I did) and which keystore file you used, then you'll have probably tried this: Upload the APK...

    • Type: Article
    • Author: Joel Lipman
    • Category: AndroidOS
    • Language: *
  7. Android: Function to let user take photo or choose existinghttps://joellipman.com/articles/else/app-dev/android-os/android-function-to-let-user-take-photo-or-choose-existing.html

    } } Just in case The ImageView I have (minus the width, height, margins, etc): Additional To check if the user has a camera beforehand, apparently if(hasSystemFeature(PackageManager.FEATURE_CAMERA)) is a way to go. I haven't tested yet as I need a...

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

    (,) and therefore the parsing (to extract year for example) will fail and stop the task (based on default settings). Additional -- Take a "dd/mm/yyyy" string and convert to date (when (DT_DATE)ThisDate by itself doesn't work)...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  9. SSIS Skip Rows in Excel Source filehttps://joellipman.com/component/content/article/ssis-skip-rows-in-excel-source-file.html?catid=74&Itemid=165

    column headings, F1 is the first column of the data range and NOT the first column of the data sheet (eg. F1 = B11) !!! Additional We add a conditional split task to the data flow which only passes through rows from the Excel sheet which are not...

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

    Task: Format keycolumn as per your requirements and use substring on trimmed DataColumn to retrieve each data column. Additional The TRIM in SSIS does not appear to get rid of new line and carriage return symbols!!! Use the Replace(String, "\r", "") and...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  11. Alternate row background colour in Reporting Serviceshttps://joellipman.com/component/content/article/alternate-row-background-colour-in-reporting-services.html?catid=75&Itemid=165

    item. It will alternate between the two for the rest of the report. [The second example is what I use most frequently]. Additional: Suppose you have lots of columns, you don't want to have to click on each cell to specify this so just do it to the first...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: *
  12. SSRS External Images don't displayhttps://joellipman.com/component/content/article/ssrs-external-images-dont-display.html?catid=75&Itemid=165

    "PhotoDetails") & IIF(Code.ImageExists(First(Fields!PhotoURL.Value, "PhotoDetails")), " exists!", " does NOT exist.") Additional Error (if you get this) We didn't get this error as the problem was down to not having a "unattended user account" who could...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: *
  13. SSRS Retrieving Oracle Stored Procedure Success or ErrorLevelhttps://joellipman.com/component/content/article/ssrs-retrieving-oracle-stored-procedure-success-or-errorlevel.html?catid=75&Itemid=165

    2008 R2 (SSRS) reading from an Oracle 10g database which works great and lists all the details on a specific student. An additional request is that there appears a link that will run a stored procedure which Updates a timestamp in an existing table...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  14. SSRS AlphaNumeric Parameter Validationhttps://joellipman.com/component/content/article/ssrs-alphanumeric-validation.html?catid=75&Itemid=165

    change 0 to 1. */ =IIF( Parameters!ParameterToCheck.Value"" AND Fields!NOTALPHANUMERIC.Value=0, "Valid", "Not Valid" ) Additional If like us, you've made a report containing a link dependent on parameters submitted, we had to apply a similar IIF...

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

    AS ItemID FROM ExecutionLogStorage ) AS d1 ORDER BY d1.Name ASC Additional Modifications: For all Parameters: » General - Untick "allow blank value" and "allow null value" (so these checkboxes are empty). » Available Values - "Get values from a query" =...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  16. Include a carriage return in a column headinghttps://joellipman.com/component/content/article/include-a-carriage-return-in-a-column-heading.html?catid=78&Itemid=165

    difference the above does, is that when you refresh the data, it will retain the carriage return in the column headings. Additional: Only appears obvious in SQL Server Management Studio resultset. Remember to format the cells (column headings) in the...

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

    the system registry setting as per the below. If you have never used the system registry before, ask someone who has. Additional (intended for Vista users) The following is an excerpt from...

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

    (including the double-quotes) TEST: Open an instance of Windows Explorer, Right-click on a folder and select the action. Additional Notes: This outputs the contents to a text file called "directory_printout.txt". This file will be stored in the folder...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  19. Set up Desktop SlideShow in Windows 7https://joellipman.com/component/content/article/set-up-desktop-slideshow-in-windows-7.html?catid=80&Itemid=165

    at the bottom) Check the Picture location is using your image folder and click on “Select All” Click on “Save Changes” Additional: Further group policies can completely disable this feature so there is a chance that this won't work for you.

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: en-GB
  20. Administrator Program Shortcut without Prompthttps://joellipman.com/component/content/article/administrator-program-shortcut-without-prompt.html?catid=80&Itemid=165

    click on Next Give the shortcut a name to display as (eg. "Visual Studio 2010") Click on OK to complete your shortcut. Additional: You can change the icon for the shortcut using the shortcut properties and browsing to the program it was created to run....

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
Results 81 - 100 of 128