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

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

    what this ID is by finding out what -- user_id is the first user created in the upgrade site. This is the ID -- used when installing Joomla CMS. It is important that the script below -- accounts for the fact that you may have a user with the same ID in...

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

  2. SQL Queries for Statisticshttps://joellipman.com/articles/database/mysql/sql-queries-for-statistics.html

    1, 0)) Student, SUM(IF(t2.VisitorType='Anonymous', 1, 0)) Guests FROM ( SELECT b.user_name User, CASE WHEN INSTR(b.user_name, '@staff') THEN 'Staff' WHEN INSTR(b.user_name, '@bournemouth') THEN 'Student' WHEN t1.ID=0 THEN 'Anonymous' END VisitorType,...

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

  3. T-SQL Record Separatorhttps://joellipman.com/articles/database/t-sql/t-sql-record-separator.html

    Thursday Thursday Friday Friday The Official Gist Okay so the below article with the 3 stages can be a little confusing. When I wrote the support documentation which makes use of this little trick for my managers, I explained it as displayed in the...

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

  4. Compare two databases using T-SQLhttps://joellipman.com/articles/database/t-sql/compare-two-databases-using-t-sql.html

    table and column names, lists diffences if any SELECT t1.TABLE_CATALOG AS [DB1_Name], t2.TABLE_CATALOG AS [DB2_Name], CASE WHEN t1.TABLE_NAME IS NULL AND t2.TABLE_NAME IS NOT NULL THEN t2.TABLE_NAME + ' (new)' WHEN t1.TABLE_NAME IS NOT NULL AND...

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

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

    A very quick note in case I forget this one. If you are trying to join two tables and receiving the error "Conversion failed when converting the varchar value 'B110' to data type int" then read on. How? So where does the 'B110' string come from, well...

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

  6. Zoho Books/Inventory: Trigger a workflow when an invoice has been paidhttps://joellipman.com/articles/crm/zoho/zoho-books-inventory-trigger-a-workflow-when-an-invoice-has-been-paid.html

    An article on something that has taken me several days to get working: Get Zoho Books or Zoho Inventory that when an invoice is marked as paid, update 2 custom fields with the Payment Method, and the Payment Date. Why? This was requested by a customer...

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

  7. Zoho Creator: Prevent Endless Loops On User Input of a Fieldhttps://joellipman.com/articles/crm/zoho/zoho-creator-prevent-endless-loops-on-user-input-of-a-field.html

    field has triggered an automation/workflow but it keeps spinning and doesn't stop. The app page will ultimately timeout and when reloading the form it simply displays a blank page. Their only workaround is wait about 30 seconds or more for the loop to...

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

  8. Returned a data type that is not validhttps://joellipman.com/articles/database/t-sql/returned-a-data-type-that-is-not-valid.html

    SUM(IF(t1.VisitorBrowser='Other', 1, 0)) 'Other', COUNT(t1.VisitorBrowser) 'Total' FROM (SELECT a.DateTimeStamp Date, CASE WHEN INSTR(a.VisitorUAgent, 'MSIE ') THEN 'MSIE' WHEN INSTR(a.VisitorUAgent, 'Firefox') THEN 'Firefox' WHEN INSTR(a.VisitorUAgent,...

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

  9. Zoho CRM: Update a custom field in line items / product details using REST API v2.1https://joellipman.com/articles/crm/zoho/zoho-crm-update-a-custom-field-in-line-items-product-details.html

    in the CRM Quote module as per the following screenshot: How? Again at the time of this article, this is only modifiable when using REST API v2.1. We are going to update the field with label "Group Name" but API name "Grouping" in a list item column....

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

  10. Blank columns issue when exporting to Excel (Data Only) from Crystal Reportshttps://joellipman.com/articles/microsoft/excel/blank-columns-issue-when-exporting-to-excel-data-only-from-crystal-reports.html

    it was copied from http://hosteddocs.ittoolbox.com/ST030504.pdf. A "Crystal Decisions" documentation. Blank columns appear when exporting to Excel. There are four main causes for extra blank columns to appear in a worksheet. Cause 1: Fields in the same...

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

  11. mysqldump: Got error: 2049: Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure_auth' enabled) when trying to connecthttps://joellipman.com/articles/database/mysql/mysqldump-got-error-2049-connection-using-old-pre-4-1-1-authentication-protocol-refused-client-option-secure-auth-enabled-when-trying-to-connect.html

    v6.0.8.11354 build 833 What? This is a quick article on how to get around the problem of backing up your MySQL database when attempting to "Data Export" using MySQL Workbench. This is not regarding the connection issue as I can connect to my database...

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

  12. Formatting a date in an MDX queryhttps://joellipman.com/articles/database/t-sql/formatting-a-date-in-an-mdx-query.html

    letters used are on the MSDN website at http://msdn.microsoft.com/en-us/library/ms146084.aspx NOW() vs TODAY() Noticed this when setting date as the parameter and trying to specify default date as today's in the format DD/MM/YYYY. Googled this but...

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

  13. Zoho Webhooks & Shopify API: Keep Disappearinghttps://joellipman.com/articles/crm/zoho/zoho-webhooks-shopify-api-automatically-restore.html

    is an article to show how to setup a scheduled function that checks and restores a missing webhook as well as the snippets when receiving the webhooks and storing them. Why? We found that Shopify would intermittently remove our webhooks. This would make...

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

  14. ZohoCRM: Daily Follow Up and Remind Record Owner to Convert Leadhttps://joellipman.com/articles/crm/zoho/zohocrm-follow-up-and-remind-record-owner-to-convert-lead.html

    An article to ensure I never spend this long on such a request again. The brief is: "Follow up when a lead is created and not converted within 1 day send an email and notification to sales person everyday for 3 days then escalate to a specified user"....

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

  15. Zoho Creator: Input Color Pickerhttps://joellipman.com/articles/crm/zoho/zoho-creator-input-color-picker.html

    What would be nice-to-have is if they could be presented with a bunch of colors and they click on one to select it. When are colors used? Well in this use-case, we are using it to color events in a calendar associated with specific staff. Probably not...

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

  16. Joes FREE Website Thumbnailer (JWT)https://joellipman.com/component/content/article/joes-free-website-thumbnailer.html?catid=40

    website visitor can generate 1000 hits, so thereafter I have to pay every time someone sees that picture through my site; when I could just go to each website and press the print screen key and save this as an image for FREE. I don't get it. So I wrote...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *

  17. MySQL parameters in Excel 2007 PivotTableshttps://joellipman.com/articles/database/mysql/mysql-parameters-in-excel-2007-pivottables.html

    ' ') AS ActivityID, t.TeamName AS Team, CONCAT(u.Firstname, ' ', u.Lastname) AS StaffName, CASE WEEKDAY(s.DateTimeCreated) WHEN 0 THEN 'Monday' WHEN 1 THEN 'Tuesday' WHEN 2 THEN 'Wednesday' WHEN 3 THEN 'Thursday' WHEN 4 THEN 'Friday' WHEN 5 THEN...

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

  18. JDatabase: using the Joomla database with exampleshttps://joellipman.com/articles/cms/joomla/jdatabase-using-the-joomla-database.html

    ->where($db->quoteName('user_id') . '=42') ->order('date_modified ASC'); Single Value Result This type of query is for when you want just one value from one column and one particular row. $db = JFactory::getDbo(); $query = $db->getQuery(true);...

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

  19. Zoho Creator: Change Radio into Tabshttps://joellipman.com/articles/crm/zoho/zoho-creator-change-radio-into-tabs.html

    Workflows > Select your form Click on New Workflow Choose form (the one your radio tabs group exists on) (Record Event) Run when a record is Created or Edited (Form Event) When to trigger workflow Load of the form Name the workflow, I'm calling mine...

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

  20. ZohoCRM to ZohoBooks API: Rounding the cents or pennies when creating an invoicehttps://joellipman.com/articles/crm/zoho/zohocrm-to-zohobooks-api-half-a-cent-or-penny-off-when-creating-an-invoice.html

    make cent/penny errors into 100s of dollar/pound errors. Zoho CRM has a fun way of rounding which differs to Zoho Books so when pushing an invoice, there's a strong chance of being a cent/penny off. Let's take the following example of an item with a...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
Results 1 - 20 of 290

Joes Word Cloud

Please publish modules in offcanvas position.