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

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

    before nor were the instructions for applying the template and integrating it into Joomla that straightforward. It doesn't seem to matter what order you do the below in because I went through rocketheme's instructions once and it didn't work. I then...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  2. Zoho People: Get Performance Records over APIhttps://joellipman.com/articles/crm/zoho/zoho-people-get-performance-records-over-api.html

    on getting the records from the performance module in Zoho People API. Why? Cos it took us a while. The online forums seem to go back over a decade and the documentation seems to have gaps; or simply modules are so custom/bespoke the documentation has...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  3. ZohoCRM: ZDK Client Script to retrieve Contact Emailhttps://joellipman.com/articles/crm/zoho/zohocrm-zdk-client-script-to-retrieve-contact-email.html

    The only other event you can use this in inline editing mode in is the Canvas mode. Error(s) Encountered Contacts doesn't seem to appear in Client Script IDE. Didn't for me but then it isn't too hard to guess what the module name is.

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  4. SQL Calendar in Business Intelligence Development Studiohttps://joellipman.com/articles/database/t-sql/sql-calendar-in-business-intelligence-development-studio.html

    this is because I will format it via the text-box properties instead of getting the expression to return it exactly (there seem to be issues with this - error textbox1[0]...). You will need this expression to set the font color of days that are in the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
  5. PHP & MySQL Search Enginehttps://joellipman.com/articles/web-development/php/php-a-mysql-search-engine.html

    as $term){ $out[] = '\b'.preg_quote($term, '/').'\b'; } return $out; } # function to sort results by rank. # NOTE: does not seem to be working properly function search_sort_results($a, $b){ $ax = $a["Score"]; $bx = $b["Score"]; if ($ax == $bx){ return...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
  6. SSRS Hide results table if emptyhttps://joellipman.com/articles/microsoft/ssrs/ssrs-hide-results-table-if-empty.html

    [ROOMEQUIPMENT] re INNER JOIN [EQUIPMENT] eq ON eq.EquipId=re.EquipId WHERE re.RoomId=@GivenRoom AND re.SetId=@setId This seems to have problems because when there are no matching rows (so zero results), BIDS doesn't seem to know what to do with this....

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  7. Before and After, Highs and Lowshttps://joellipman.com/articles/microsoft/ssrs/before-and-after-highs-and-lows.html

    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, ItemDate) as DayOfYear, DATEPART(year, ItemYear) AS YearRun,...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: *
  8. Migrate Joomla Users to WordPresshttps://joellipman.com/articles/cms/wordpress/migrate-joomla-users-to-wordpress.html

    a lot easier since it uses nested categories like Wordpress. There are lots of commercial migrators out there and they all seem to have this problem. I'm really keen not to ask all my users to have to change their passwords but that is what the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Wordpress
    • Language: en-GB
  9. No rows returned in Oracle causes SP to failhttps://joellipman.com/articles/database/pl-sql/no-rows-returned-in-oracle-causes-sp-to-fail.html

    first query was erroring despite the stored procedure compiling successfully. An empty dataset is still an error it would seem. -- Error I was getting ORA-20001: 1234567:$:ORA-01403: no data found ORA-06512: at "BASETABLEOWNER.MY_STUPID_PROCEDURE", line...

    • Type: Article
    • Author: Joel Lipman
    • Category: Oracle PL/SQL
    • Language: en-GB
  10. Set up Desktop SlideShow in Windows 7https://joellipman.com/articles/microsoft/windows-os/set-up-desktop-slideshow-in-windows-7.html

    Background", "browsing to the Picture Location". The problem happens when browsing to the picture location and it doesn't seem to remember which folder you selected. At home, this would be a breeze, but that's because I don't implement group policies at...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: en-GB
  11. Split a row into multiple rows based on a column valuehttps://joellipman.com/articles/database/t-sql/split-a-row-into-multiple-rows-based-on-a-column-value.html

    ask a DBA to emulate the user for testing. the Items column may vary from 1 and 10+. Not sure on why this is but it doesn't seem to affect the functionality of the above and you could always hardcode a 1.00 if its confusing. In theory, if you know the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: *
  12. Include a carriage return in a column headinghttps://joellipman.com/articles/microsoft/sql-server/include-a-carriage-return-in-a-column-heading.html

    What? A really quick note on how to insert a carriage return or new line into the column name/alias (the header). It might seem trivial but these little aesthetic changes done at the database level can save some time. Why? I have an Excel report which...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server
    • Language: *
  13. Zoho Deluge - Compare time and currenttime with timezonehttps://joellipman.com/articles/crm/zoho/zoho-deluge-compare-time-and-currenttime-with-timezone.html

    particular case, we will switch the current time to Europe/London (You can use an abbreviation such as GMT but this doesn't seem to check if daylight savings is in effect): Example of taking a CRM date-time value (expiryTime) and appending toTime()...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  14. Zoho CRM/Creator - Common Errors & Gotchashttps://joellipman.com/articles/crm/zoho/zoho-crm-creator-common-errors-gotchas.html

    Following a post similar to the above example by InvokeURL and then getting a JSON response back, the response does not seem to be read as a map: r_Response = invokeurl [ url :v_DataEndpoint type :POST parameters:m_CreateRecord headers:m_Header ]; info...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  15. Zoho Deluge: Setup an API Connection for InvokeURLhttps://joellipman.com/articles/crm/zoho/zoho-deluge-setup-an-api-connection-for-invokeurl.html

    by checking the scope(s) you have allowed it to have.... However in those times of debugging/testing when you can't seem to access that bit of information Zoho is reluctantly letting you have (such as comment information for estimates/sales...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  16. Zoho CRM: Mapping a Multi-User or Multi-Lookup field using Delugehttps://joellipman.com/articles/crm/zoho/zoho-crm-mapping-a-multi-user-or-multi-lookup-field-using-deluge.html

    r_Delete = zoho.crm.invokeConnector("crm.delete", m_Delete); } } Update 2025 Having to do this again in 2025 and things seem to have changed. I've added a multi-user lookup on the quotes record called "Requires_Approval_Users". A quick setup method is...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  17. Amazon Kindle: Send PDFs to your Kindlehttps://joellipman.com/amazon/kindle/amazon-kindle-send-pdfs-to-your-kindle.html

    straightforward. All you need to do is send the PDF file to your Kindle email id. It is here that things might begin to seem a bit complicated in that not many might be aware Amazon allots an email address to every Kindle owner, and that it is unique...

    • Type: Article
    • Author: Joel Lipman
    • Category: Kindle
    • Language: *
  18. Zoho Books: System Values Mapshttps://joellipman.com/articles/crm/zoho/zoho-books-system-values-maps.html

    A collection of code snippets I seem to be regularly using to generate a dynamic map of system values held in a ZohoBooks instance. Why? Rather than hard-coding and having a ton of if..then statements, I can feed these maps a textual value and it...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  19. ZohoCRM & ZohoWriter: Generate Rich-Text / HTML Email Signatures in CRMhttps://joellipman.com/articles/crm/zoho/zohocrm-zohowriter-generate-rich-email-signatures-in-crm.html

    have other solutions, such as hosting the images on a web-server, or converting to a base64 or an SVG. ZohoCRM signatures seem to be unable to handle a lot of code or long URLs such as a base64 source URL for an image. The Plan Get company phone and...

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

    = recordArr[index].Nick_Name; break; } // if not blank then let's display it if(v_GreetingName != "") { // can't seem to do jQuery references within this SDK document.getElementById('greeting-name').innerHTML = v_GreetingName; } }); } catch(e) {...

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

Donate & Support

If you like my content, and would like to support this sharing site, feel free to donate using a method below:

Paypal:
Donate to Joel Lipman via PayPal

Bitcoin:
Donate to Joel Lipman with Bitcoin bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4

Ethereum:
Donate to Joel Lipman with Ethereum 0xb038962F3809b425D661EF5D22294Cf45E02FebF

Please publish modules in offcanvas position.