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

  1. A quick run through of setting up an export process in SITShttps://www.joellipman.com/articles/cms/website-development/xml/a-quick-run-through-of-setting-up-an-export-process-in-sits.html

    DOT for records that will be output. Check that DRE contains the rules for the DOR code you are using. Check that an ERE exists relating to the EOR code you are using.

    • Type: Article
    • Author: Joel Lipman
    • Category: Extensible Markup Language
    • Language: *
  2. Joes Word Cloud (JWC) Downloadhttps://www.joellipman.com/component/content/article/joes-word-cloud-jwc-downloads.html?catid=105&Itemid=165

    into sliding panels. - Added Joomla! Admin Option: Specify border color for link. - Now checks if mb_strtolower function exists (regresses to strtolower). - Additional parameters (eg. Word Background) do not load if not enabled. - Added Joomla! Admin...

    • Type: Article
    • Author: Joel Lipman
    • Category: Downloads
    • Language: *
  3. Zoho CRM: Update Opportunity Type as New or Existing Businesshttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-update-opportunity-type-as-new-or-existing-business.html

    module entry" is ticked Click "Authorize" You will be advised of what this connection has permission to do > Authorize (If exists, then click on "Re-Use") You will return to the connection panel > Next Give it an action name, I'm calling mine: "Sales...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  4. Free Translator API using Googlehttps://www.joellipman.com/component/content/article/free-translator-api-using-google.html?catid=61&Itemid=165

    services but in the small print, you will find they too charge the same price. How? The Google Translate API still actually exists. Just don't try to exceed your free quota: Visit http://translate.google.com/manager/website Sign in using your Google...

    • Type: Article
    • Author: Joel Lipman
    • Category: Google
    • Language: en-GB
  5. SSRS Use T-SQL Like with a Parameterhttps://www.joellipman.com/component/content/article/ssrs-use-t-sql-like-with-a-parameter.html?catid=75&Itemid=165

    AND rb.[ContactName] LIKE '%'+@GivenName+'%' --WORKS! Enclose percent signs as strings. For anyone that thinks there exists stupid questions, here's a silly answer which I hope helps!

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  6. SSRS Change Background Color of Imagehttps://www.joellipman.com/component/content/article/ssrs-change-background-color-of-image.html?catid=75&Itemid=165

    on the status result. If I simply insert an image, the report would use the background color of the report. How? The issue exists if your image has transparent areas but displays the report background color instead: Right-click on the cell you want to...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  7. MySQL Oracle equivalentshttps://www.joellipman.com/articles/else/database/mysql-oracle-equivalents.html

    this is just a quick list of some regular commands in MySQL that I need in Oracle: Objective MySQL Oracle - See if a table exists SHOW TABLES Select table_name from sys.dba_tables - Return a specific number of rows SELECT * FROM table1 LIMIT 0, 10...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: en-GB
  8. Strip HTML in MySQLhttps://www.joellipman.com/articles/else/database/mysql/strip-html-in-mysql.html

    the delimiter, create the function by running the following: SET GLOBAL log_bin_trust_function_creators=1; DROP FUNCTION IF EXISTS fnStripTags; DELIMITER | CREATE FUNCTION fnStripTags( Dirty varchar(4000) ) RETURNS varchar(4000) DETERMINISTIC BEGIN...

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