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

  1. Migrate Joomla! 1.5.x to 2.5.x+https://www.joellipman.com/articles/cms/joomla/migrating-from-joomla-15-to-16.html

    version 1.6.x or greater. -- -- You should have both sites up and running alongside each other. -- -- The instructions below uses 2 databases: LIVE and UPGRADE -- -- Do not run this if you only have 1 database available! -- -- References to J15 indicate...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  2. Connect to Joomla database in standalone scripthttps://www.joellipman.com/articles/cms/joomla/connect-to-joomla-database-in-standalone-script.html

    For obvious reasons, these cannot be hardcoded. What? Any developer installing my component will do so on a website which uses different login details for their Joomla database. The example below demonstrates how to get these details and extract data...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  3. Adding a selectable background to a Yootheme templatehttps://www.joellipman.com/articles/cms/joomla/adding-a-selectable-background-to-a-yootheme-template.html

    off/on using the Joomla Admin Panel. How? For demo purposes, I'm going to add the background "Ambient Turquoise". Yootheme uses CSS files to do this so we'll need to modify the XML file and add some files that this will select. Modify...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  4. Things to Check if Joomla Password Reminder email not being senthttps://www.joellipman.com/articles/cms/joomla/things-to-check-if-joomla-password-reminder-email-not-being-sent.html

    you just made. Send a test message. Test your email server can message: Send an email using the server that the “Site Email” uses. If this is web-based, then ensure you are using a separate instance of the browser to your Joomla one. Check that your...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  5. Migrate Joomla Users to WordPresshttps://www.joellipman.com/articles/cms/wordpress/migrate-joomla-users-to-wordpress.html

    to Wordpress 3.2.x sites. I started with a Joomla 1.5 as the move from Joomla 1.6 or greater is a lot easier since it uses nested categories like Wordpress. There are lots of commercial migrators out there and they all seem to have this problem. I'm...

    • Type: Article
    • Author: Joel Lipman
    • Category: Wordpress
    • Language: en-GB
  6. MacOs: Transcribe Training Video using OpenAI Whisperhttps://www.joellipman.com/component/content/article/macos-transcribe-training-video-using-openai-whisper.html?catid=60&Itemid=165

    > ~/.zshrc RuntimeError: Numpy is not available: Which Python Whisper Uses head -n 1 $(which whisper) Note the result for the next command, eg. #!/Library/Developer/CommandLineTools/usr/bin/python3 Install NumPy for That Exact Python...

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

    was called a Data-Scrambling Function 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....

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: *
  8. Basic Oracle Stored Procedure Structurehttps://www.joellipman.com/articles/else/database/oracle-pl-sql/basic-oracle-stored-procedure-structure.html

    For a basic Oracle function, visit my article Basic Oracle Function Structure. For a more advanced version which uses cursors to work with SSRS, see my article Oracle Stored Procedures in SSRS. What? I asked someone for a simple, easy and basic Oracle...

    • Type: Article
    • Author: Joel Lipman
    • Category: Oracle PL/SQL
    • Language: en-GB
  9. No rows returned in Oracle causes SP to failhttps://www.joellipman.com/articles/else/database/oracle-pl-sql/no-rows-returned-in-oracle-causes-sp-to-fail.html

    (SSRS) environment and don't want to return any rows if there are no matches (not a blank row either) as one of my reports uses a row counter to display a "No data found" message when no rows are returned. This does not affect the above problem as the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Oracle PL/SQL
    • Language: en-GB
  10. Generate a Timesheet in MySQL https://www.joellipman.com/articles/else/database/mysql/generate-a-timesheet-in-mysql.html

    the week that date occurs in. How? The example below shows how to do this when your weeks being/commence on Monday. It also uses the current date in the form of NOW() but this example has to work with any given date. First of all: Get this week's dates...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: *
  11. CSS Center an iFrame Horizontally and Verticallyhttps://www.joellipman.com/articles/cms/website-development/css/css-center-an-iframe-horizontally-and-vertically.html

    This CSS centers it by its center point rather than the top/bottom/left/right outline. Why? On a mobile, a client's site uses an external page embedded by iframe. When the app within the iframe has an alert message, it popups a div at the centre of its...

    • Type: Article
    • Author: Joel Lipman
    • Category: Cascading Stylesheets
    • Language: en-GB
  12. Parse a HTML Table into a ListViewhttps://www.joellipman.com/articles/cms/website-development/html/parse-a-html-table-into-a-listview.html

    StringSplit,ReturnedHTMLTableCols,ReturnedHTMLTableColString,| } LV_ModifyCol() Method #2 This method only uses two columns with the label being a concatenation of the value of the first column and the column heading....

    • Type: Article
    • Author: Joel Lipman
    • Category: Hypertext Markup Language
    • Language: en-GB
  13. Preg_Replace all strings between two tagshttps://www.joellipman.com/articles/cms/website-development/php/preg-replace-all-strings-between-two-tags.html

    For those of you who use Preg_Replace. Preg_replace is a function that uses regular expressions to search and replace a string. Why? Because my understanding with regular expressions is shady and varies from language to language, I've written this...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: *
  14. A quick run through of setting up an export process in SITShttps://www.joellipman.com/articles/cms/website-development/xml/a-quick-run-through-of-setting-up-an-export-process-in-sits.html

    the same as the the XET and EOR codes) Specify the Message Group that the monitors will run. In our demo, the link value uses all three primary keys of the CAP entity. They can be separated by double hashes/pound signs or a single tilda with the keys...

    • Type: Article
    • Author: Joel Lipman
    • Category: Extensible Markup Language
    • Language: *
  15. Import Excel CSV file as JavaScript arrayhttps://www.joellipman.com/component/content/article/import-excel-csv-file-as-javascript-array.html?catid=110&Itemid=165

    strings containing double-quotes (and commas to ignore) Sort the resulting object array How? The function with comments: - Uses deprecated XMLHttpRequest to get file contents - Loops through each row and splits by commas (not within quotes) - Sorts the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  16. CSV Chart Generatorhttps://www.joellipman.com/component/content/article/csv-chart-generator.html?catid=53&Itemid=165

    chart which you can zoom in and out of, includes almost every type of chart you can think of (though this program only uses chart types: Area, Bar, Column, Line and Pie). Note that AMCharts.com is free as long as you leave the copyright information. If...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  17. SSRS Subscriptions cannot be createdhttps://www.joellipman.com/component/content/article/ssrs-subscriptions-cannot-be-created.html?catid=75&Itemid=165

    our Windows Credentials. For the SSRS server holding our report, we do NOT have an unattended service account. The report uses a shared data source which stores the credentials, ie. A sql authenticated user with read-only privileges. The report has 4...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  18. Sir James Dyson explains his bladeless fanhttps://www.joellipman.com/component/content/article/sir-james-dyson-explains-his-bladeless-fan.html?catid=96&Itemid=165

    that replace conventional methods and thought processes. In this video, Sir J. Dyson demonstrates a new type of fan which uses a fraction of the energy of normal fans. In the UK, we may not need air conditioning as much as other countries but this is...

    • Type: Article
    • Author: Joel Lipman
    • Category: Hobbies
    • Language: *
Results 41 - 58 of 58