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

  1. Using MetaMod to hide buttons from logged in usershttps://www.joellipman.com/articles/cms/joomla/using-metamod-to-hide-buttons-from-logged-in-users.html

    any mistakes and I'll be sure to fix asap. To hide buttons on your site for users that are logged in do the following: First thing.. Install this --> http://www.brandonitconsulting.co.uk/mod_metamod/ **In this example I'm using Joomla 1.5.10 and the...

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

    over Categories: It is recommended to do this via the GUI and then associate the IDs to your content, weblinks, etc. The thing to watch out for is associating the categories with respect to the assets table. To do this via DB commands, refer to how the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  3. Win32 Constantshttps://www.joellipman.com/component/content/article/win32-constants.html?catid=48&Itemid=165

    file system folder Const SFGAO_FOLDER = $20000000 ;// It's a folder. Const SFGAO_FILESYSTEM = $40000000 ;// is a file system thing (file/folder/root) Const SFGAO_HASSUBFOLDER = $80000000 ;// Expandable in the map pane Const SFGAO_CONTENTSMASK =...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: *
  4. Zoho Creator: info/alert/modal/popup notification for any userhttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-info-alert-modal-popup-notification-for-any-user.html

    open the same popup link in the parent window. The solution however is to remove the base URL and only keep the URL as something like #Page:Notify. Do NOT add the base URL such as https://creatorapp.zoho.com/myowner/myapp/#Page:Notify. CSS styling...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  5. Zoho Deluge: Post a multi-dimensional or nested array to a 3rd-party APIhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-post-a-multi-dimensional-or-nested-array-to-a-3rd-party-api.html

    arrays. In the example below, we are posting to a PHP script for testing but I have since sent something similar to an API expecting nested arrays (not sure if they were PHP) and it works. Why? This took me several days and in the end only going through...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  6. Zoho Creator: Prevent Endless Loops On User Input of a Fieldhttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-prevent-endless-loops-on-user-input-of-a-field.html

    instance, we don't want large amounts of code to be copied and pasted for each field, especially if they're doing the same thing for example displaying a preview in a notes field. We would rather only have to update the code for 1 workflow rather than...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  7. Zoho Creator: Public URL of an Image field / Upload to Shopify APIhttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-public-url-of-an-image-field-upload-to-shopify-api.html

    solution requires that your target API accepts base64encoded images or that you can send these in a cURL request (same thing really): string API.fn_ShopifyQuery_UploadPhoto(int p_Position, int p_ProductID) { v_Output = ""; m_Header = Map();...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  8. ZohoCRM: Template: not being able to edit a text boxhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-template-not-being-able-to-edit-a-text-box.html

    they weren't using the header section) but then they changed address and couldn't change the template. So they had something like: ${Organization.Organization Name} ${Organization.Street} ${Organization.City} ${Organization.Country}...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  9. Zoho Deluge: Regex Rounding and/or Removing Trailing Zeroshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-regex-rounding-and-or-removing-trailing-zeros.html

    don't breach a statement execution limit in the Zoho app function. How? If we're not going to use loops, then the next best thing I'm aware of is a regular expression. So the first expression I came up with worked to a certain point but didn't round up...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  10. Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL)https://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-shopify-api-integration-oauth-2-0-update-2022.html

    (Multi Line) Refresh Token Expiry (Date-Time) AuthToken (Multi Line) AuthToken Expiry (Date-Time) You should end up with something like this screenshot: * Some of these fields are unnecessary for this example but are used to accommodate other API...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  11. Zoho: Email Deliverability / SPF / DKIM / DMARC / Toolkithttps://www.joellipman.com/articles/crm/zoho/zoho-other/zoho-email-deliverability-spf-dkim-dmarc-toolkit.html

    How? So first I'll outline the steps to set this up in ZohoCRM and then how to troubleshoot issues with this. One important thing to note is that the setup needs to be done by whoever manages the domain for the client. Who owns the domain (eg....

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Other
    • Language: *
  12. Zoho Deluge: Get the Week Number if Week starts on a Mondayhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-get-the-week-number-if-week-starts-on-a-monday.html

    1 27 // yields: 27 // // Sunday, 09-Jul-2023 7 28 // yields: 27 Originally, I had this formula which seemed to do the same thing but unnecessarily moved the pointer to the start of the week. It could also error eventually if Zoho made it possible to...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  13. Zoho Deluge and Wordpress/WooCommerce API: Get All Productshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-and-wordpress-woocommerce-api-get-all-products.html

    the available pages, so including the above plus some calculation to work out how many times to loop should retrieve every thing: // // initialize l_AllProducts = List(); v_TotalCategories = 0; v_TotalProducts = 0; v_Page = 1; // do not set this to...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  14. Zoho Webhooks & Shopify API: Keep Disappearinghttps://www.joellipman.com/articles/else/e-commerce/shopify/zoho-webhooks-shopify-api-automatically-restore.html

    Note that this one is not the "Inventory Item Update" as I get the two muddled up very often and they don't do the same thing. We want this triggered whenever the stock level of a product changes. /*...

    • Type: Article
    • Author: Joel Lipman
    • Category: Shopify
    • Language: *
  15. How to Display Report Execution Time in SSRS (milliseconds)https://www.joellipman.com/component/content/article/how-to-display-report-execution-time-in-ssrs.html?catid=75&Itemid=165

    AS ReportEndTime FROM DUAL This may be just the time recorded that it took for the query which is somewhat the same thing for us as SSRS performance is always rubbish anyway. Here's a breakdown of the MDX expressions and how I tweaked each one to return...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  16. SSRS: Performance Improvements: SELECT TOPhttps://www.joellipman.com/component/content/article/ssrs-performance-improvements-select-top.html?catid=75&Itemid=165

    viable solution for your case, but this did what we were asking and is a serious improvement to the user experience. For one thing, the accidental search for "Jane" and pressing the Enter key, no longer goes off into the interminable loop that is...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  17. Split a row into multiple rows based on a column valuehttps://www.joellipman.com/articles/else/database/t-sql/split-a-row-into-multiple-rows-based-on-a-column-value.html

    001 1.00 1997-11-17 002 1.00 2000-02-18 002 1.00 2000-02-19 002 1.00 2000-02-20 003 1.00 1999-02-25 003 1.00 1999-02-26 Some thing(s) to consider: User running the SQL query needs permission to read the master database. If run by a service account, ask...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: *
  18. Accessing a MySQL Database with Business Intelligence Development Studiohttps://www.joellipman.com/articles/else/database/mysql/accessing-a-mysql-database-with-business-intelligence-development-studio.html

    the Report Type (for just a table with a heading row at the top, select "Tabular") > Next Click on "Details" until everything is added. > Next I'm boring and old-school so my table style will be "Generic". > Next FINISH That's all folks! Hopefully this...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  19. What's the problem? Amusing computer issueshttps://www.joellipman.com/articles/cms/website-development/whats-the-problem-amusing-computer-reports.html

    you log back on in the morning?" "No it takes so long in the morning, this is quicker". Explained how logoff is not the same thing as restart and reminded on both IT and environmental policies. Tech Notes: For PCs: Run a command prompt and type...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
  20. Using a HTML form and PHP to upload a filehttps://www.joellipman.com/articles/cms/website-development/php/using-a-html-form-and-php-to-upload-a-file.html

    a PHP file to process this. This example applies to a Linux Apache MySQL PHP (LAMP) environment. The Solution 1. The first thing to do is check that your HTML form is setup to do this:...... The form above will post to itself but more importantly is...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
Results 1 - 20 of 24