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

  1. Zoho CRM: Updating a CRM record Custom Line Items using API v7https://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-updating-a-crm-record-using-api-v7.html

    m_Data = Map(); m_Data.put("data",l_RecordsToSend); // // this is REST API so by default all triggers run. Use an list to specify any triggers on update. Use an empty list to stop any. m_Data.put("trigger",{"workflow","approval"}); v_Endpoint =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  2. Zoho Deluge: Connect to Shopifyhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-connect-to-shopify.html

    = "https://" + v_ClientID + ":" + v_ClientSecret + "@" + v_ShopID + ".myshopify.com"; // // per endpoint request to specify which API version (eg. 2025-07) v_ShopifyApiVersion = r_ShopifyAPI.API_Version; // // url with client id and client secret (now...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  3. Zoho Survey & Zoho Analytics: Query to generate individual responses and grouped pageshttps://www.joellipman.com/articles/crm/zoho/zoho-analytics/zoho-survey-zoho-analytics-query-to-generate-individual-responses-and-grouped-pages.html

    != "") { v_ImageURL = v_ZohoApisDomain + "/crm/v8/__attachment_preview/" + v_PreviewID; info v_ImageURL; // // specify template id of mail merge document (browse to it and check the URL) v_Template3 = "aaaa1111bbbb2222cccc3333dddd4444eeee5"; // // embed...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Analytics
    • Language: *
  4. Installing phpBB3 for Joomla with a RocketTheme templatehttps://www.joellipman.com/articles/cms/joomla/installing-phpbb3-for-joomla-with-a-rockettheme-template.html

    to it in your main menu (or whatever menu) Return the RokBridge component in Joomla Admin Panel (Components > RokBridge) Specify the name of the Bridge Path (eg. forum) [THIS IS CASE-SENSITIVE (the name as displayed on your menu item)] Set the phpBB...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  5. Migrate Joomla! 1.5.x to 2.5.x+https://www.joellipman.com/articles/cms/joomla/migrating-from-joomla-15-to-16.html

    This script is for my own use. Joomla! are in no way liable for this script. You can copy this script as long as you specify a link to its source. You can use this script as long as you don't hold me responsible for the results. If you don't understand...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  6. Migrate JComments from Joomla 1.5.x to Joomla 2.5.xhttps://www.joellipman.com/articles/cms/joomla/migrate-jcomments-from-joomla-15x-to-joomla-25x.html

    Post-Installation Go to JComments Settings and specify the same "Choose categories for JComments to work in" as you have for your 1.5 website. The above script ignores your previous settings and leaves the factory settings that come with the JComments...

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

    the Admin ID to a number that hasn't been taken yet or to use the current one and is specified as a local variable. -- Specify v2.5.x admin ID and v3.4.x admin ID SET @v25_admin_id=42; -- Set this to the ID number of the user in your Joomla 2.5.x SET...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  8. Mediawiki Extension for Camtasia Studio SWF videoshttps://www.joellipman.com/articles/cms/mediawiki/mediawiki-extension-for-camtasia-studio-swf-videos.html

    optional settings) > Next Video Info (complete optional settings) > Make sure "Embed Video into HTML" is checked > Next Specify production name and click on 'FINISH' This will produce a HTML, SWF, XML and JS file in the output directory. We only want...

    • Type: Article
    • Author: Joel Lipman
    • Category: MediaWiki
    • Language: en-GB
  9. Sort order a dropdown list in MS InfoPath without programminghttps://www.joellipman.com/component/content/article/sort-order-a-dropdown-list-in-ms-infopath-without-programming.html?catid=73&Itemid=165

    to have (I included the IDs for functional purposes) Further down the "Create View" page, there should be a Sort section, specify the column to sort by. Save the view by clicking the OK button. You'll be returned to your datasheet and it's possible it...

    • Type: Article
    • Author: Joel Lipman
    • Category: Infopath
    • Language: *
  10. 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

    append the next letter in UPPERCASE and then append the remainder. // NOTE: This will work with "MacDonalds" as well (specify "Mac") but bear in mind "Mack" exceptionArray_this = new string[] { "Mc", "O'", "D'", "I'" }; foreach (string myValue in...

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

    (F8) Right-click on your dataset (in my case: DataSet1) Select 'Dataset Properties' Add a condition to the WHERE clause Specify that the field name in the series fields is not blank So I've added the AND line to the above statement yielding: SELECT...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  12. Alternate row background colour in Reporting Serviceshttps://www.joellipman.com/component/content/article/alternate-row-background-colour-in-reporting-services.html?catid=75&Itemid=165

    what I use most frequently]. Additional: Suppose you have lots of columns, you don't want to have to click on each cell to specify this so just do it to the first column then bring up the properties pane and scroll down to the "Fill > BackgroundColor"...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: *
  13. SSRS Querying on either of 2 Parametershttps://www.joellipman.com/component/content/article/ssrs-querying-on-either-of-2-parameters.html?catid=75&Itemid=165

    "forward dependencies". This is obviously going to error, so continuing on their solution, setting the "Available Values – Specify values" to =IIF(LTrim(Parameters!StudentADAccount.Value)="", Parameters!StudentReference.Value,...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  14. SSRS Redirect after a report is runhttps://www.joellipman.com/component/content/article/ssrs-redirect-after-a-report-is-run.html?catid=75&Itemid=165

    on trying to find a solution was not considered to be warranted. My reports use a parameter for the connection string to specify which server and database to connect to and the follow on link was enough as a solution. My seniors advised that if we had...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  15. SSRS Retrieving Oracle Stored Procedure Success or ErrorLevelhttps://www.joellipman.com/component/content/article/ssrs-retrieving-oracle-stored-procedure-success-or-errorlevel.html?catid=75&Itemid=165

    we use an account specifically created to run the stored procedure. This requires using 2 data sources in SSRS. A user will specify the student reference in the parameters of the first report (the one with all the main details), as well as a job...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  16. Returning Oracle Stored Procedure Resultset in SSRShttps://www.joellipman.com/component/content/article/returning-oracle-stored-procedure-resultset-in-ssrs.html?catid=75&Itemid=165

    and NOT ODBC or OLEDB. Unicode=true and my user is a specific read-only user. 3. Add an SSRS parameter Idem as in just specify a parameter as you would for any usual SSRS report. (Ignore my 2nd and 3rd SSRS parameters in my example as I didn't end up...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  17. Sync Outlook 2007 Shared Calendar with SharePoint 2007https://www.joellipman.com/component/content/article/sync-outlook-2007-shared-calendar-with-sharepoint-2007.html?catid=77&Itemid=165

    for this was to copy the recurring event to the SharePoint calendar, then from within SharePoint to open the event and specify the recurrence rate. Sharing is Caring Now my colleagues have set up the calendar in their instances of Outlook, they can also...

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

    Select the Operating System (eg. Windows XP) > Next Use the recommended RAM > Next Select "A new virtual hard disk" > Next Specify a virtual hard disk size (eg. 10000 MB which is about 10Gb) > Next Check your attributes and click on "Finish" The Virtual...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  19. Restore MSSQL Error: Database is in usehttps://www.joellipman.com/articles/else/database/restore-mssql-error-database-is-in-use.html

    close all other connections, click Yes. Restoring in SSMS, Right-click on the database Select Tasks > Restore... > Database Specify the "to a point in time" if you don't want to restore from the most recent backup and double-check the "Start/Finish...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: en-GB
  20. Returned a data type that is not validhttps://www.joellipman.com/articles/else/database/t-sql/returned-a-data-type-that-is-not-valid.html

    AS Month This will return the SQL date but using your report builder or business intelligence development studio, you can specify in the report designer how to format the returned value to a more user-friendly date format (such as Month name then year -...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: *
Results 61 - 80 of 100