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

  1. Zoho CRM: JS Widget: Generic Script to pass the Record ID to a CRM functionhttps://joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-js-widget-generic-script-to-pass-the-record-id-to-a-crm-function.html

    to documentation and using CoPilot or OpenAI ChatGPT for parsing the return value of the function (note that I have SCRIPT within the BODY tags and not in the HEAD): Loading... Please Wait... console.clear(); ZOHO.embeddedApp.on("PageLoad",...

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

  2. Zoho CRM Client Script: Map Quote to Invoicehttps://joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-client-script-map-quote-to-invoice.html

    then I'll just put the client script I used to map over all the applicable field values from the quote to the invoice within ZohoCRM. Set up the Client Script Login to ZohoCRM > Setup (cog icon next to profile photo) > Developer Hub > Client Script >...

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

  3. ZohoCRM & Xero: Function to pull most recent invoiceshttps://joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-xero-function-to-pull-most-recent-invoices.html

    = ifnull(r_TokenDetails.get("Tenant_ID"),""); // // get access token (does not need REST API url as we're calling it from within CRM) v_AccessToken = standalone.fn_API_GetXeroAccessToken(); // // do Xero stuff if(v_AccessToken != "" && v_TenantID != "")...

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

  4. Zoho Deluge - Multi-line Variable Assignments and Expressionshttps://joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-multi-line-statements-using-semi-colon-termination.html

    "TEST-1001" This pattern can be useful when building request payloads for API calls or preparing structured data for reuse within a script. 2) Multi-line list declaration and item access Lists can also be declared over multiple lines, which can help...

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

  5. How to redirect the visitor after the contact pagehttps://joellipman.com/articles/cms/joomla/how-to-redirect-the-visitor-after-the-contact-page.html

    as i have not tried it. Step One: First if you don't already have a page that you want to redirect to, you will create one within the Joomla 1.5 admin interface and make sure it is published. I have tried the method below with both an article and a...

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

  6. Invalid arguments passed in router.php on line 325https://joellipman.com/articles/cms/joomla/invalid-arguments-passed-in-routerphp-on-line-325.html

    on the front-end of my component is controlled and not customizable. I fixed this by removing the reference to router.php within the installation XML file. (router.php). I even deleted the router.php file from my installation zip file (I checked that...

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

  7. Basic Joomla 2.5 Mootools Formhttps://joellipman.com/articles/cms/joomla/basic-joomla-25-mootools-form.html

    mootools (uncompressed?). This is intended for absolute novices (like me) who just want to see an example of an AJAX form within Joomla 1.6.x - 2.5.x in it's most basic state. At time of print, I am using this with Joomla 2.5.6. Why? The examples of the...

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

  8. Things to Check if Joomla Password Reminder email not being senthttps://joellipman.com/articles/cms/joomla/things-to-check-if-joomla-password-reminder-email-not-being-sent.html

    A quick article on a frequent question I get asked. This refers to an issue within the Joomla CMS (version 2.5.x) where it fails to email users who reset their password. How? A few things to check: Check the email message even exists: Login to your...

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

  9. 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

    which can be enabled for debug purposes. // This could produce extensive logs so this event should normally be disabled within the package logging! public override void RegisterLogEntries() { this.LogEntryInfos.Add(DebugLogEventName,...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB

  10. Parameters not being used in report processinghttps://joellipman.com/component/content/article/parameters-not-being-used-in-report-processing.html?catid=75&Itemid=165

    In case you've been stuck for ages (as I have), I found out you cannot declare the parameters used by the software within the SQL script... So the above should look more like this: --...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB

  11. Alternate row background colour in Reporting Serviceshttps://joellipman.com/component/content/article/alternate-row-background-colour-in-reporting-services.html?catid=75&Itemid=165

    borders as well. I want a bigger border at the bottom of the overall report and a light one to divide each record. Staying within the properties pane, you can do the following: BorderColor: #efefef, , , White,...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: *

  12. SSRS AlphaNumeric Parameter Validationhttps://joellipman.com/component/content/article/ssrs-alphanumeric-validation.html?catid=75&Itemid=165

    on parameters submitted, we had to apply a similar IIF statement block to the Font color and the Action target as well within SSRS.

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB

  13. SSRS Zero Paddinghttps://joellipman.com/component/content/article/ssrs-zero-padding.html?catid=75&Itemid=165

    this at the database level, mainly because it meant modifying the SQL query. The zero padding would need to be applicable within an MDX query. The Situation We have a database using Oracle 10g, and a SQL Server Reporting Services v2008 R2 environment....

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: *

  14. Returning Oracle Stored Procedure Resultset in SSRShttps://joellipman.com/component/content/article/returning-oracle-stored-procedure-resultset-in-ssrs.html?catid=75&Itemid=165

    mentioned in the above OUT variables: DECLARE p_STUDENT_REF number(8); p_STUDENT_DETAILS varchar2(255); -- putting a begin within otherwise I get warning errors (with an end!) BEGIN -- initial query to get me the student ID based on the inputted...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB

  15. SSRS Stop Scrolling Behindhttps://joellipman.com/component/content/article/ssrs-stop-scrolling-behind.html?catid=75&Itemid=165

    nothing is kept visible while scrolling. This issue is specific to my template because the entire report is displayed within a tablix (contains row groups, no column groups). The headers do not stay fixed at the top of the page anymore but then this...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB

  16. Sync Outlook 2007 Shared Calendar with SharePoint 2007https://joellipman.com/component/content/article/sync-outlook-2007-shared-calendar-with-sharepoint-2007.html?catid=77&Itemid=165

    understand recurring events. My workaround 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...

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

  17. SQL Calendar in Business Intelligence Development Studiohttps://joellipman.com/articles/else/database/t-sql/sql-calendar-in-business-intelligence-development-studio.html

    I find myself searching the web for a way of producing an outlook-style calendar within Business Intelligence Development Studio (BIDS). Weekdays along the top and then dates inside. Additionally we would like this linked to events in a database. I'm...

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

  18. T-SQL DateTimestampshttps://joellipman.com/articles/else/database/t-sql/t-sql-datetimestamps.html

    a list from databases.aspfaq.com but the convert numbers didn't correspond to the output formats. This is my list created within my environment and setup (see above).

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

  19. DataScramble - Randomizing data rowshttps://joellipman.com/articles/else/database/t-sql/datascramble-randomizing-data-rows.html

    the view if it already exists IF OBJECT_ID ('vwRandom', 'V') IS NOT NULL DROP VIEW vwRandom ; GO -- Used to reference RAND within a function CREATE VIEW vwRandom AS SELECT RAND() as RandomValue; GO The Function -- Drop the function if it already exists...

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

  20. MySQL: Display Users and Duration in Matrix Timesheethttps://joellipman.com/articles/else/database/mysql/mysql-display-users-and-duration-in-matrix-timesheet.html

    starts on Monday 00:00 and ends on Sunday 23:59. Putting it together Your first query should loop through the users list, within the loop run the activities query and replace the string "STRING_TO_REPLACE_PER_ITERATION" with the User ID. Something like:...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
Results 61 - 80 of 102