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

  1. Zoho Deluge: Proper Case for Nameshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-proper-case-for-names.html

    + v_LastName); info v_FullName; // // yields: Billie-Jo McDonald-O'Leary II of Cambridge-Worcester-Oxford Caveat(s): This solution does not cater for the Mac prefix; because "Mackayla", "Macie", "Maci", "Macala", "Mack", "Macoy", "Macey", "Macedonia"......

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  2. Zoho Creator: Error Code 2945: EXTRA KEY FOUND IN JSONhttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-error-code-2945-extra_key_found_in_json.html

    if you do a getRecordById and it works then the connection string is fine. What I was doing?: I'm not saying this is the solution to whenever you get the above error; I'm just saying this what I was doing and this is what fixed it when I ran into this...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  3. ZohoCreator: Basic Widget with Zoho Datahttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zohocreator-basic-widget-with-zoho-data.html

    back from 2020 with a few adjustments now in 2024. This widget will only work within Zoho Creator. If you want a solution which sits on an external website and which talks to Zoho, then setup an externally hosted web app with the usual JavaScript...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  4. Zoho Analytics & Zoho People: Monitor DataSource Sync https://www.joellipman.com/articles/crm/zoho/zoho-analytics/zoho-analytics-zoho-people-monitor-datasource-sync.html

    can be adapted to any data source for Zoho Analytics. Why? We're assisting a client implement Zoho People as their new HR solution. Zoho Analytics is used to generate specific spreadsheets for a feed into their third-party payroll system. If the data is...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Analytics
    • Language: *
  5. ZohoAnalytics & ZohoBooks: Custom Related List from Analyticshttps://www.joellipman.com/articles/crm/zoho/zoho-books/zohoanalytics-zohobooks-custom-related-list-from-analytics.html

    Why? My use-case here is that we have a client who uses their purchase orders and sales orders as part of a logistics solution where items are purchased from a supplier, sent to another supplier for grading, and then sent on to the end user/customer. A...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  6. ZohoCRM GetRelatedRecords INVALID_DATAhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-getrelatedrecords-invalid_data.html

    "details":{ "api_name":"data" }, "message":"invalid data", "status":"error" } How? I recall covering this solution before but it boils simply down to the zoho.crm.getRelatedRecords() not retrieving related records which are clearly visible when using...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  7. Anti-Spam override for all submitted datahttps://www.joellipman.com/articles/cms/joomla/anti-spam-override-for-all-submitted-data.html

    include('index.php'); There is some more text but it's in /* lines */ which means these are comments. The quick solution is: $_REQUEST['tmpl'] = 'component'; $offensive_words=array("viagra","cialis","[url=","porn","pfizer"); if (is_array($_GET))...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  8. Zoho Finance Suite Schedule: PATTERN NOT MATCHEDhttps://www.joellipman.com/articles/crm/zoho/zoho-books/zoho-finance-suite-schedule-pattern-not-matched.html

    is remove any spaces from the name of the schedule. The longer answer is demonstrated in the following screenshots: Error: Solution

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  9. Joomla banners not rotatinghttps://www.joellipman.com/articles/cms/joomla/joomla-banners-not-rotating.html

    The issue here is that you have added all your banners, divided between clients and categories and you're looking for a solution which doesn't involve installing a 3rd party applicatoin. Unfortunately the Joomla banner module only supports alternating...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  10. Invalid arguments passed in router.php on line 325https://www.joellipman.com/articles/cms/joomla/invalid-arguments-passed-in-routerphp-on-line-325.html

    firstly I don't want to have to create an account on someone else's forum just to post my answer and secondly because my solution is a "cowboy fix" rather than the other intelligent solutions on the web. The issue was that I was building my first Joomla...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  11. Connect to Joomla database in standalone scripthttps://www.joellipman.com/articles/cms/joomla/connect-to-joomla-database-in-standalone-script.html

    at the bottom of this page to ask a question. Additional I'm pretty sure you don't need all the require files and my solution may be crude, but this script works perfectly for what I had in mind. Important! There are a few concealed features of this...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  12. Call to a member function mark() on a non-object in Joomla CMShttps://www.joellipman.com/articles/cms/joomla/call-to-a-member-function-mark-on-a-non-object.html

    in a Joomla CMS environment. Call to a member function mark() on a non-object in /public_html/index.php How? Not really a solution here because this is indicating that the system can't find the core framework files. Yes the bad news is you have lost...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  13. Migrate Joomla Users to WordPresshttps://www.joellipman.com/articles/cms/wordpress/migrate-joomla-users-to-wordpress.html

    change their passwords but that is what the commercial applications are doing. The script to transfer users This is a free solution to at least get your user accounts all migrated. How you deal with the passwords can then be up to you. To use the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Wordpress
    • Language: en-GB
  14. List all cron jobs for all usershttps://www.joellipman.com/component/content/article/list-all-cron-jobs-for-all-users.html?catid=63&Itemid=165

    little script I found on Stack Overflow. Wasn't really my solution as after 2 hours, realised that the customer had been looking at the wrong server. But this script showed me where the cron job we intended was located. #!/bin/bash # System-wide crontab...

    • Type: Article
    • Author: Joel Lipman
    • Category: Linux
    • Language: *
  15. Room Availability Calendar in Business Intelligence Development Studiohttps://www.joellipman.com/component/content/article/room-availability-calendar-in-business-intelligence-development-studio.html?catid=75&Itemid=165

    I tried and I spent a few hours searching the net for a solution which displays the hours in the top columns, and undefined number of rooms in the rows. No all I was looking for was a calendar showing 1 day with the hours on the top. Working hours only...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: *
  16. SSRS Hide results table if emptyhttps://www.joellipman.com/component/content/article/ssrs-hide-results-table-if-empty.html?catid=75&Itemid=165

    Bring up the "Tablix Properties" of the dataset Look for the section "No Rows" Put in a value for "NoRowsMessage". This solution hides the entire Tablix which kinda defeats the purpose of having anything there. I want my end-users to have faith in my...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  17. Before and After, Highs and Lowshttps://www.joellipman.com/component/content/article/before-and-after-highs-and-lows.html?catid=75&Itemid=165

    the count of yesterday, yesterweek, yestermonth, yesteryear and do the layout in PHP. Now let's say I have one RDL or SSRS Solution. I could do a dataset per SQL query but it doesn't seem that ideal. In Theory: SELECT ItemName, DATEPART(dayofyear,...

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

    was successful" or "No sorry you're going to have to go back to the beginning and try that again."... This isn't a solution that sounded good enough for our customers. The Workaround we actually went with Our Stored Procedure would check if the unique...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  19. $_SERVER['http_referer'] returns blank in Internet Explorerhttps://www.joellipman.com/component/content/article/serverhttpreferer-returns-blank-in-internet-explorer.html?catid=62&Itemid=165

    environment variable can be changed by the user anyway but I was using it as an additional validation check. The only solution is to not use it for verification purposes as it will only work in every other browser except Internet Explorer (more...

    • Type: Article
    • Author: Joel Lipman
    • Category: Microsoft
    • Language: en-GB
  20. SSRS AlphaNumeric Parameter Validationhttps://www.joellipman.com/component/content/article/ssrs-alphanumeric-validation.html?catid=75&Itemid=165

    MDX Check /* For Expression Value. Remember to apply to both ACTION and if you use color change FONT. Note for MySQL solution change 0 to 1. */ =IIF( Parameters!ParameterToCheck.Value"" AND Fields!NOTALPHANUMERIC.Value=0, "Valid", "Not Valid" )...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
Results 81 - 100 of 139