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

  1. Creating a custom form field type for Joomla XML fieldsethttps://joellipman.com/articles/cms/joomla/creating-a-custom-form-field-type-for-joomla-xml-fieldset.html

    I'm writing a Joomla 2.5.x component for logging time and projects and need a dropdown to have selectable options restricted to the logged-in user. This is specified in the XML file of the custom Joomla component and needs some SQL dependent on some...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  2. Migrating from Joomla 2.5.x to 3.4.xhttps://joellipman.com/articles/cms/joomla/migrating-from-joomla-2-5-x-to-3-4-x.html

    `v34_db`.`v34_tablename` -- with the database name and table prefix of database you are WRITING to (eg. `myuser_joellipmancom_mysitedb`.`ejf1r_content`) How? Here's a brief outline of the whole process: Backups Install Users Categories -- unstable...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  3. Upgrading Joomla CMS version 3.x to Joomla CMS 5.xhttps://joellipman.com/articles/cms/joomla/upgrading-joomla-cms-version-3-x-to-joomla-cms-5-x.html

    PHP v7.x to PHP v8.x. I also get complaints (from my server not from humans) that my Joomla version needs updating... I'm writing this in case I ever have to upgrade other people's Joomla CMS and if it helps anyone else out there. How? There aren't too...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  4. Basic Android App using Google Maps and Current Locationhttps://joellipman.com/articles/else/app-dev/android-os/basic-android-app-using-google-maps-and-current-location.html

    to: Android Studio (Beta) 0.8.6 Google Android Maps API What? I am writing an app for a tablet running Android and wanted to include a Google Map. The following exercise focuses solely on creating an app which opens Google Maps at your current location....

    • Type: Article
    • Author: Joel Lipman
    • Category: AndroidOS
    • Language: *
  5. SSIS Script: convert UPPERCASE to Mixed-Case using TitleCasehttps://joellipman.com/component/content/article/ssis-script-convert-uppercase-to-mixed-case-using-titlecase.html?catid=74&Itemid=165

    came through asking if this could be restored to a normal case, a mixture of mostly lowercase and some UPPERCASE. Why? I'm writing this article because other solutions on the net were either incomplete, did not work for me or simply did not match the...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  6. Copy a table with structure and data into a temporary tablehttps://joellipman.com/articles/else/database/t-sql/copy-a-table-with-structure-and-data-into-a-temporary-table.html

    Hmm... I was writing a stored procedure that will scramble data given a table as a parameter. Because I only want to update a temporary table and not the original (source) table, I needed the following stored procedure (or part of). What? This will copy...

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

    The Why So I find myself writing increasingly complex SQL scripts and it's at the stage where we need to optimize the queries because some scripts are noticeably slow (as observed by the customer...) and then others not. The What I'm going to run these...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  8. Developer's Checklist: Taking over a projecthttps://joellipman.com/articles/cms/website-development/developers-checklist-taking-over-a-project.html

    more and more people have been asking if I can take over a project that has been abandoned by its developer. I've started writing this article because I find myself forgetting to ask something that could have saved an infinite number of man-hours (I...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
  9. Embed an FLV file into a web pagehttps://joellipman.com/articles/cms/website-development/html/embed-an-flv-file-into-a-web-page.html

    full url of your own FLV. Save the HTML page and publish The Code: Additional: Stop AutoPlay Thank you to Anna Moors for writing in and asking "how to stop the movie from playing automatically on page load?". Anna has since confirmed that the below code...

    • Type: Article
    • Author: Joel Lipman
    • Category: Hypertext Markup Language
    • Language: *
  10. Convert XML UTF-16 to JSON UTF-8 with PHP cURLhttps://joellipman.com/articles/cms/website-development/php/convert-xml-utf-16-to-json-utf-8-with-php-curl.html

    TRUE); Future Considerations The data still hasn't been properly decoded from UTF-16 and encoded to UTF-8 Test writing to a file, re-encoding the file then reading from it. Helpful Links XML parsing in PHP convert xml to json php curl utf16_decode PHP...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
  11. Zoho Deluge - MD5 functionhttps://joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-md5-function.html

    255 characters (it could be a multiline but this would defeat the objective of an Etag). How? Well I was going to document writing a Creator function but found a shortcut playing with the base64encode function: v_Etag =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: en-GB
  12. Zoho Deluge - Pad with leading Zeroshttps://joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-pad-with-leading-zeros.html

    own website, this is a doddle for me to find each time. Why? I have to do this so often that it deserves an article. Though writing a whole page for this is probably unwarranted so I may rename this article later to common things I need to do in Zoho...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: en-GB
  13. DBMS Random Referencehttps://joellipman.com/articles/else/database/oracle-pl-sql/dbms-random-reference.html

    How to use the randomization features of Oracle PL/SQL. Why? I've been tasked with writing a stored procedure that scrambles data for developers working with some of our databases containing sensitive data. How? SELECT DBMS_RANDOM.option1[(option2)]...

    • Type: Article
    • Author: Joel Lipman
    • Category: Oracle PL/SQL
    • Language: *
  14. First and Last Entry on a Page using Modulus Remainderhttps://joellipman.com/articles/cms/website-development/php/first-and-last-entry-on-a-page-using-modulus-remainder.html

    entry was first and which was last. This is incredibly useful for pagination. The Situation I want the script to start writing a DIV layer in the code at the start of the loop (and at every first entry of a page). I want the script to close the DIV...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: *
Results 21 - 34 of 34