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

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

    this by title in ascending order without installing any 3rd-party extension as well as by any of the database values used by each link. Joomla 1.5.x I found the page to edit after going through the Joomla forums for a bit. Their solution only...

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

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

    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 server.I'm going to refer to the files to create as being in this...

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

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

    this also helps as all you are usually changing is a folder name in order to quickly point to LIVE or TEST. Confirm with each person aware of this setup and involved in the development, that they understand the risk of "accidental" changes and the...

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

  4. Migrating from Joomla 2.5.x to 3.4.xhttps://www.joellipman.com/articles/cms/joomla/migrating-from-joomla-2-5-x-to-3-4-x.html

    component: JComments: This will be a copy of two systems running JComments version 3.x The MySQL scripts will copy over each table in turn Configure and Brand your new Joomla site Activate Users Post-Notes: Activating users should be done as the last...

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

  5. Upgrading Joomla CMS version 3.x to Joomla CMS 5.xhttps://www.joellipman.com/articles/cms/joomla/upgrading-joomla-cms-version-3-x-to-joomla-cms-5-x.html

    > Clear Filter Options > Show All > Tick to select all > Rebuild [does not work] Using the administrator panel, go into each category and hit save and close starting with the parent categories first Copying article heading images from SP Page Builder to...

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

  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

    Google Drive REST API v3 Google OAuth 2.0 v4 Google Cloud Platform IAM Google Suite PHP v5.6.35 How? I'm going to go through each section of the code to go through the logic and highlight any changes you may need to make. 1. First: the variables are in...

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

  7. Basic Android App using Google Maps and Current Locationhttps://www.joellipman.com/articles/else/app-dev/android-os/basic-android-app-using-google-maps-and-current-location.html

    go red like in the following screenshot: Focus the cursor on the word and hold down the key and press Enter, then import each class: Your code will now include the imported classes near the beginning, so TEST it! Addtional: Problems animating the camera...

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

  8. Android: Keytool and Google Maps displaying greyhttps://www.joellipman.com/articles/else/app-dev/android-os/android-keytool-and-google-maps-displaying-grey.html

    both to the 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:...

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

  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

    blank. Derived Column 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...

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

  10. SSRS Hide results table if emptyhttps://www.joellipman.com/component/content/article/ssrs-hide-results-table-if-empty.html?catid=75&Itemid=165

    tables or little subroutines which just overcomplicates basic simple select queries... However set a counter to 1 for each and then get BIDS to do the sum of this using an MDX expression. T-SQL Expression: Consider the following expression as the one we...

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

  11. How to Display Report Execution Time in SSRS (milliseconds)https://www.joellipman.com/component/content/article/how-to-display-report-execution-time-in-ssrs.html?catid=75&Itemid=165

    same thing for us as SSRS performance is always rubbish anyway. Here's a breakdown of the MDX expressions and how I tweaked each one to return the final result: -- to get just the time value =( CDate(Last(Fields!REPORTENDTIME.Value, "Dataset2")) -...

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

  12. SSRS Dropdown parameter cannot be blank!https://www.joellipman.com/component/content/article/ssrs-dropdown-to-allow-blank-values.html?catid=75&Itemid=165

    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 want the report to be run with the 3rd and 4th...

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

  13. 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

    Note: As simple as this sounds, this is not a five-minute job. Even with all your SQL scripts with backups of your datasets, each of these will need tweaking. Create your stored procedure in Oracle (and grant execute for your SSRS user) Add a data...

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

  14. Problem creating SSRS report subscriptionshttps://www.joellipman.com/component/content/article/problem-creating-ssrs-report-subscriptions.html?catid=75&Itemid=165

    (just to be sure). Ensure unattended system account scheduled to run and email the report can access the datasources for each parameter-driven connection (ask a DBA if you're unsure).

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

  15. SSRS Stop Scrolling Behindhttps://www.joellipman.com/component/content/article/ssrs-stop-scrolling-behind.html?catid=75&Itemid=165

    work out: Open the Report in Design mode. Check that advanced mode is switched on as per the following image: Cycle through each static object and set FixedData to False (ensure all items are set to false or it will error): Save and test on the...

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

  16. Include a carriage return in a column headinghttps://www.joellipman.com/component/content/article/include-a-carriage-return-in-a-column-heading.html?catid=78&Itemid=165

    (column headings) in the Excel spreadsheet for it to wrap text and save the file. Hereafter, you will NOT need to do this on each data refresh. Ensure that there is a trailing space after the label and before the carriage return otherwise the column...

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

  17. Hide a Drive per User in Windows 7https://www.joellipman.com/component/content/article/hide-a-drive-per-user-in-windows-7.html?catid=80&Itemid=165

    All users can access the drive using the command prompt. To hide from specific users, you need to repeat the above for each user. If your disk drive uses the NTFS file system: Modify the Security settings for the drive to restrict access via the Command...

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

  18. SQL Calendar in Business Intelligence Development Studiohttps://www.joellipman.com/articles/else/database/t-sql/sql-calendar-in-business-intelligence-development-studio.html

    along the top), "Order" in rows (order is which week in the month), and the Date and Note in the details (will appear in each cell per day). Grouping by weeks: Now we finish with the report wizard and returned to the designer. Right-click on the...

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

  19. T-SQL Conversion failed when converting the varchar to data type inthttps://www.joellipman.com/articles/else/database/t-sql/t-sql-conversion-failed-when-converting-the-varchar-to-data-type-int.html

    a string together; then remembers it's a Microsoft by-product and realises it can't. Solved by checking the datatypes for each field in the concatenation string: LTRIM(RTRIM(rm.Name + ', ' + rm.[Zone] + ', ' + CONVERT(VARCHAR(4), rm.[Capacity]) + ', ' +...

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

  20. Convert to Proper Case in T-SQLhttps://www.joellipman.com/articles/else/database/t-sql/convert-to-proper-case-in-t-sql.html

    reset SELECT @Reset = 1, @i=1, @Ret = ''; IF (UPPER(@Text)=@Text Collate Latin1_General_CS_AI) BEGIN -- cycle through each character, -- if non-alpha, uppercase next alpha character. -- if alpha then lowercase subsequent alphas. -- NON-ALPHA EXCEPTIONS...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
Results 161 - 180 of 209