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

  1. Installing phpBB3 for Joomla with a RocketTheme templatehttps://www.joellipman.com/articles/cms/joomla/installing-phpbb3-for-joomla-with-a-rockettheme-template.html

    exactly the same way) Fatal error: Call to a member function acl_get() on a non-object in /includes/functions_display.php on line 135 sometimes line 82 or a blank page. We found this seems to be related to some Virtuemart modules we had installed (well...

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

    * ScriptMain is the entry point class of the script.*/ using System; using System.Data; using Microsoft.SqlServer.Dts.Pipeline.Wrapper; using Microsoft.SqlServer.Dts.Runtime.Wrapper; using System.Globalization; // for cultureinfo and textinfo using...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  3. SSRS Parameters in Oracle Stored Procedurehttps://www.joellipman.com/component/content/article/ssrs-parameters-in-oracle-stored-procedure.html?catid=75&Itemid=165

    within Microsoft SQL Server Reporting Services. The Error ORA-00911: invalid character ORA-06512: at "SYS.DBMS_UTILITY", line 114 ORA-06512: at line 1 (System.Data.OracleClient) The Situation I'm using Business Intelligence Development Studio 2008 to...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  4. 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

    AS MyCount FROM DMExtractEmployeeTable e2 LEFT JOIN DMExtractReferenceTable r2 ON e2.CodeType=r2.MapIn -- THIS IS THE LINE CAUSING THE PROBLEM!!! WHERE e2.ID=e1.ID GROUP BY e2.ID,r2.MapIn ) AS MatchingRecordsCount FROM DMExtractEmployeeTable1 e1 LEFT...

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

    -- Error I was getting ORA-20001: 1234567:$:ORA-01403: no data found ORA-06512: at "BASETABLEOWNER.MY_STUPID_PROCEDURE", line 56 ORA-01403: no data found ORA-06512: at line 1" error Failing part of the stored procedure: -- the version of the first query...

    • Type: Article
    • Author: Joel Lipman
    • Category: Oracle PL/SQL
    • Language: en-GB
  6. Stop Excel Row Height Self-Adjust on Refreshhttps://www.joellipman.com/component/content/article/stop-excel-row-height-self-adjust-on-refresh.html?catid=110&Itemid=165

    the data in the Excel spreadsheet, all the rows get re-adjusted to fit the data and lose that consistency. A Workaround: New line inserted before and after So this is where I am at the moment without VBCode and other suggestions. Instead I add a newline...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  7. Joel's Reference to MidJourney v4 Promptshttps://www.joellipman.com/component/content/article/joel-s-guide-to-midjourney-prompts.html?catid=115&Itemid=165

    Pop Art Post-Impressionism Psychedelic Punk Rainbow Realism Sketch Steampunk Sticker Surreal Synthwave Unreal Engine Vector Line Watercolor Painting Whimsical Yellowist Zombie Lighting Ambient Light Artificial Lighting Back Light Blacklight Broad...

    • Type: Article
    • Author: Joel Lipman
    • Category: Graphic Design
    • Language: *
  8. A for loop within a for loop in MS-DOShttps://www.joellipman.com/component/content/article/a-for-loop-within-a-for-loop-in-ms-dos.html?catid=51&Itemid=165

    technology belonging to the 90s - MS-DOS v6.22). The example wants to loop through a directory and then loop through the line it finds. Why? I use another technology for automation but sometimes the simpler solution is the one I make for other people to...

    • Type: Article
    • Author: Joel Lipman
    • Category: MS-DOS
    • Language: en-GB
  9. Zoho Deluge - MD5 functionhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-md5-function.html

    field can't be done via the documented methods (base64, urlencode or AES) as this exceeds 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...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: en-GB
  10. Warning call_user_func: First argument is expected to be a valid callbackhttps://www.joellipman.com/articles/cms/joomla/warning-call-user-func-first-argument-is-expected-to-be-a-valid-callback.html

    First argument is expected to be a valid callback in /home/.../templates/rt_affinity/rt_sectionrows.php on line 311 How? Copy & backup the file /public_html/.../templates/rt_affinity/rt_sectionrows.php Find the following piece of code around line 311:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  11. AutoHotkey Ternary Operatorhttps://www.joellipman.com/component/content/article/autohotkey-ternary-operator.html?catid=48&Itemid=165

    those who are unfamiliar with this is an "If...Then...Else..." statement written in a small amount of code, usually on one line, and exists in most programming languages. For Example, the statement: If (ThisCondition = true) ThisVar:=1 Else ThisVar:=2...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: en-GB
  12. Batch Process to rename multiple files using Windows DOShttps://www.joellipman.com/component/content/article/batch-process-to-rename-multiple-files-using-windows-dos.html?catid=51&Itemid=165

    following (the string to replace here is " (Copy)" without the quotes) - this is a READ-ONLY process if you leave the last line commented/remarked @ECHO OFF SETLOCAL ENABLEDELAYEDEXPANSION FOR /f "tokens=*" %%a IN ('dir /b *" (Copy).jpg"') DO ( SET...

    • Type: Article
    • Author: Joel Lipman
    • Category: MS-DOS
    • Language: en-GB
  13. Joe's CSV Chart Generator (JCG)https://www.joellipman.com/component/content/article/joellipmans-csv-chart-generator.html?catid=53&Itemid=165

    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 you want to remove the copyright...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  14. Joes Quicklist Weblinks (JQW)https://www.joellipman.com/component/content/article/joes-quicklist-weblinks-jqw.html?catid=53&Itemid=165

    [function.in-array]: Wrong datatype for second argument in /public_html/modules/mod_quicklistweblinks/helper.php on line 214 This is because you have not selected a thumbnail "service group" authorized to generate new thumbnails in the module...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  15. Zoho Deluge - Some Useful Regular Expressionshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-some-useful-regular-expressions.html

    = v_MyString.replaceAll(("([&'\"])"),"\\$1",false); // yields Joe\'s \"Amazing\" Skill \& \ Grunt Replace new lines in returned JSON (invalid in Zoho): v_MyString = "{"MyKey":"MyValue "}"; // the long way (and cos the regex for this isn't working)...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  16. Zoho Deluge - InvokeConnector and useful snippetshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-invokeconnector-and-useful-snippets.html

    + " :: " + r_Org.get("id"); } } } Get Module MetaData m_Module = Map(); m_Module.put("module","Leads"); // omit this line to get metadata for all modules r_Module = zoho.crm.invokeConnector("crm.modulemetadata", m_Module);...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  17. Zoho Creator: Expecting ZC_SUBFORM_250 expression found COLLECTIONhttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-expecting-zc-subform-250-expression-found-collection.html

    to copy all the data from one app to another. The specific form was for "Leads" which contained a subform with a product line item list. If I run this code, I would get the error: Expecting ZC_SUBFORM_250 expression found COLLECTION expression Another...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  18. Zoho Creator: Create a Widget which uses JavaScripthttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-create-a-widget-which-uses-javascript.html

    ensure that you have permission to install the above, then re-install. Install the Zoho Extension Toolkit (ZET) via command line interface (CLI) In the terminal, type: npm install –g zoho-extension-toolkit If you get errors like “Missing write access...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  19. Zoho People: Reject an Application for Leave in Deluge based on Criteriahttps://www.joellipman.com/articles/crm/zoho/zoho-people/zoho-people-reject-an-application-for-leave-in-deluge.html

    because on application, the record doesn't properly exist in the system yet and the delay causes errors further down the line. Just add these parameters as per my above instructions for a more robust solution. [See below for full code] Enter the code to...

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

    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 you want to remove the copyright...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
Results 61 - 80 of 130