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

  1. Zoho Books: System Values Mapshttps://joellipman.com/articles/crm/zoho/zoho-books/zoho-books-system-values-maps.html

    article (2024-05-21) due to the API domain name change from https://books.zoho.com to https://www.zohoapis.com/books and changed the Top Level Domain (or Zoho DataCenter) from EU to COM as I was using this for a client on the US datacenter. I have a...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  2. ZCRM Client Script: Correct Decimal Fields OnLoadhttps://joellipman.com/articles/crm/zoho/zoho-crm/zcrm-client-script-correct-decimal-fields-onload.html

    tries to save the record, they will get a validation error on the decimal field even if that's not the field that is being changed: Decimal places for the Unit Price field should be less than or equal to 6 . How? The workaround for staff is to round...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  3. Zoho Webhooks & Shopify API: Keep Disappearinghttps://joellipman.com/articles/else/e-commerce/shopify/zoho-webhooks-shopify-api-automatically-restore.html

    of it. This will need to be triggered whenever there is an update to the order (especially when tracking details are changed on the order). /* ******************************************************************************* Function:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Shopify
    • Language: *
  4. Zoho People: Get Performance Records over APIhttps://joellipman.com/articles/crm/zoho/zoho-people/zoho-people-get-performance-records-over-api.html

    is not proper(Has not been sent or is less than required count)"}} Crazy! sometimes the invokeUrl wants its parameters changed using .toString()... sometimes it doesn't, as it did in this case. EXTRA_KEY_FOUND_IN_JSON...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho People
    • Language: *
  5. Change default order of weblinkshttps://joellipman.com/articles/cms/joomla/change-default-order-of-weblinks.html

    for those of us brave enough to use the upgraded CMS, I have looked into this and it would appear that Joomla! CMS have not changed this. I'd imagine it quite low priority. This is easier to tweak in the upgrade. The following will again maintain the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  6. K2 Items disappearhttps://joellipman.com/articles/cms/joomla/k2-items-disappear.html

    following query: REPAIR TABLE jos_k2_items Note that I say "jos_k2_items" because by default that's what it is... If you changed the table prefix when you installed Joomla! on your site (default is "jos_") then you'll need to change this repair table...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  7. Upgrading a Joomla 1.5 module to Joomla 2.5https://joellipman.com/articles/cms/joomla/upgrade-a-joomla-1-5-module-to-joomla-1-6.html

    extensions designed for Joomla 1.5.x and make these compatible with Joomla 2.5.x websites. In the past, I have only ever changed the words to but for more stability, there are a few more tweaks to do. How? For demo purposes we will be referring to a...

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

    Method #2 If method #1 didn't work for you then if the following code works, it's because Google have changed where they're storing the API (again). This overrides the Core Joomla code for ReCaptcha: 1. Open the file:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  9. 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

    admins (optional) I also noted the previous admin's ID and returned their super admin status. Sorted by group_id desc and changed 8 to 2. SELECT m.`user_id`, m.`group_id`, u.`username`, u.`email` FROM `#_user_usergroup_map` m JOIN `#_users` u ON u.id =...

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

    AlertDialog.Builder b = new AlertDialog.Builder(this); // set the view of the AlertDialog along with changes (eg. changed "hint") b.setView(v); // set OK button action b.setPositiveButton(R.string.button_ok, new DialogInterface.OnClickListener() {...

    • Type: Article
    • Author: Joel Lipman
    • Category: AndroidOS
    • Language: *
  11. SSIS: How to loop through multiple flat files as data sourceshttps://joellipman.com/component/content/article/ssis-how-to-loop-through-multiple-flat-files-as-data-sources.html?catid=74&Itemid=165

    was for a Personnel/HR 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...

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

    can be a major part of your charts if this is a normal part of your database. In my example, the team members could have changed and that a person doing most of the jobs suddenly left or moved to another team. To exclude the rest and only show "Series1"...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  13. Performance Report - Background colors based on dataset valueshttps://joellipman.com/component/content/article/green-red-background-colors-based-on-dataset-values.html?catid=75&Itemid=165

    MDX expression below. The MDX Expression This is to be applied to the "Fill" expression of the textbox with the field name changed for each cell you apply this to; note that in the following example, "Data_Retrieval" is the field to compare (of all...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  14. 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 Issue People have reported that although they have manually set the date/time on their computer, this gets changed by the windows time server (time.windows.com) when connected to the Internet and for some reason it doesn't display the right...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  15. Running Internet Explorer 6, 7, 8 as standaloneshttps://joellipman.com/component/content/article/running-internet-explorer-6-7-8-as-standalones.html?catid=80&Itemid=165

    I know there are a lot of articles on the WWW detailing this process but none of them really worked for me. I recently changed job and no longer have all my test machines at work. Instead I only have the one workstation :eek Still I've been asked to...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  16. T-SQL Record Separatorhttps://joellipman.com/articles/else/database/t-sql/t-sql-record-separator.html

    08:00 17:00 NULL NULL NULL NULL NULL NULL */ Note that my data is inaccurate as the last row of each grouped data has been changed to NULL. Also note how the actual select query is pulling data from my CTE in its post-formatted form. I perform all the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
  17. T-SQL Conversion failed when converting the varchar to data type inthttps://joellipman.com/articles/else/database/t-sql/t-sql-conversion-failed-when-converting-the-varchar-to-data-type-int.html

    non-numeric values to map to... Well the system thinks I might so it fails. I realised then the equals sign ("=") could be changed to a "LIKE" which will mean both values are expected to be a string. So with this in mind: SELECT r1.MapIn ( SELECT...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
  18. Data Randomization Function in Oracle PL/SQLhttps://joellipman.com/articles/else/database/oracle-pl-sql/data-randomization-function-in-oracle-plsql.html

    the datatype automatically but as you may know, Oracle has a funny way of working with dates which made this need to be changed. The following function now requires a second parameter where you specify the data type: CREATE OR REPLACE FUNCTION...

    • Type: Article
    • Author: Joel Lipman
    • Category: Oracle PL/SQL
    • Language: en-GB
  19. 301 Redirect using htaccess filehttps://joellipman.com/articles/cms/website-development/301-redirect-using-htaccess-file.html

    this took me the good part of an hour just to find out, I'm posting it here so I never have to look for it again. A client changed their website domain address and wanted any person visiting the old domain to be redirected to the new domain. Why? I...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
  20. This file contains HTML or script code that may be erroneously interpreted by a web browserhttps://joellipman.com/articles/cms/website-development/html/this-file-contains-html-or-script-code-that-may-be-erroneously-interpreted-by-a-web-browser.html

    that you are allowing all SWF files to be uploaded. You will be restricted in how big the SWF files are by your server. We changed ours to 20Mb to accommodate for 5 minute SWF videos... If the screen just goes blank when you've uploaded a file, then...

    • Type: Article
    • Author: Joel Lipman
    • Category: Hypertext Markup Language
    • Language: en-GB
Results 21 - 40 of 44