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

  1. Forum Ruleshttps://joellipman.com/static-items/forum-rules.html

    cause. The following rules are also important: No Advertising - You are not permitted to make money using TEU. You are not allowed to use the member list to obtain Instant Messenging screennames to harrass people to purchase a product from you. No...

    • Type: Article
    • Author: Joel Lipman
    • Category: Static Items
    • Language: *
  2. XML Schema Referencehttps://joellipman.com/articles/web-development/xml/xml-schema-reference.html

    Description enumeration Defines a list of acceptable values fractionDigits Specifies the maximum number of decimal places allowed. Must be equal to or greater than zero length Specifies the exact number of characters or list items allowed. Must be equal...

    • Type: Article
    • Author: Joel Lipman
    • Category: Extensible Markup Language
    • Language: en-GB
  3. ZCRM Client Script: Correct Decimal Fields OnLoadhttps://joellipman.com/articles/crm/zoho/zcrm-client-script-correct-decimal-fields-onload.html

    value.toString().split(".")[1].length || 0; return 0; } // get the value from the field "Weight (kg)" (decimal field only allowed 2 decimals) var v_ProductWeight = ZDK.Page.getField('Weight_kg').getValue(); // count if more than 2 decimals, then round...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  4. T-SQL Record Separatorhttps://joellipman.com/articles/database/t-sql/t-sql-record-separator.html

    t0 WHERE [pretendField]='elephantastic' -- end your original SQL query here (note no "order by" allowed -- refer to 6th line of this query for order by) ) AS t1 ) -- Query that will display extracted data SELECT t2.*, CASE WHEN t2.Day=t3.Day THEN NULL...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
  5. Licence GNU/GPLhttps://joellipman.com/static-items/licence-gnugpl.html

    Inc. Everyone is permitted to copy and distribute verbatim copies of this license document, but changing it is not allowed. Preamble The GNU General Public License is a free, copyleft license for software and other kinds of works. The licenses for most...

    • Type: Article
    • Author: Joel Lipman
    • Category: Static Items
    • Language: *
  6. MySQL Data Type Reference Tablehttps://joellipman.com/articles/database/mysql/mysql-data-type-reference-table.html

    (4GB of text) Length of string + 4 bytes String Enum ('value','value2',...) String object that can have only one set of allowed values 1 or 2 bytes String Set ('value','value2',...) String object that can have one or many values of a set of allowed...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  7. Zoho CRM: Using a function for validation rules (or restricting specific picklist options by user profile)https://joellipman.com/articles/crm/zoho/zoho-crm-using-a-function-for-validation-rules.html

    status "New Lead". The client wanted that if the status had changed to something else, the first-line agent would not be allowed to set it back to "New Lead". Automations and workflows could however (run as Administrators). Mapping a dependency field...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  8. Zoho Workdrive: Getting Team Folder IDhttps://joellipman.com/articles/crm/zoho/zoho-workdrive-getting-team-folder-id.html

    email sendmail [ from :zoho.adminuserid to :l_RecipientsEmails subject :v_Subject message :v_Message ] Additional Note(s): Allowed role IDs for files: 34 - View 5 - Edit 4 - Share 6 - View and comment 33 - View and fill Allowed role IDs for folders: 6 -...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  9. Migrate Joomla! 1.5.x to 2.5.x+https://joellipman.com/articles/cms/joomla/migrating-from-joomla-15-to-16.html

    3.0.x. 2012-07-25: Fixed bug in older versions of MySQL reserved word "name". 2012-07-24: Fixed bug of new admin not being allowed into admin panel. 2012-03-25: Changed instructions regarding changing table prefixes. 2012-03-21: Added "Update 2012" to...

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

    and not a row of NULL/blank/empty values. Sounds confusing? That's just me, the answer was using two NVL functions which allowed the stored procedure to return no rows without erroring (ie. where rownum/rowcount = 0). Consider the following: SELECT...

    • Type: Article
    • Author: Joel Lipman
    • Category: Oracle PL/SQL
    • Language: en-GB
  11. AwStats Data Parser (ADP)https://joellipman.com/component/content/article/awstats-data-parser-adp.html?catid=40

    from an Advanced Web Statistics [AwStats] v7.0 (build 1.971) report. The data file is used by my infographic script which allowed quicker reports then scanning entire website visitor logs. No installation and USB portable. Currently runs using either...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  12. Regular Expression Basic Usage Exampleshttps://joellipman.com/articles/web-development/regular-expression-basic-usage-examples.html

    lets you use a multicharacter collating sequence in your regular expression where only one character would otherwise be allowed. For example, you can use this operator to ensure that the collating sequence 'ch', when defined in a locale such as Spanish,...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
  13. Android: Keytool and Google Maps displaying greyhttps://joellipman.com/articles/google/androidos/android-keytool-and-google-maps-displaying-grey.html

    me a while to figure out so hopefully this will help others. How? The gist is that I was using the Test SHA1 when adding allowed Android Keys to the Google APIs console (there's so many) when I should be using the App SHA1 (I have now added both to the...

    • Type: Article
    • Author: Joel Lipman
    • Category: AndroidOS
    • Language: *
  14. Zoho Deluge - Get Refresh/Access Token API v2https://joellipman.com/articles/crm/zoho/zoho-deluge-get-refresh-access-token.html

    v_Url , "new window"); This will open a page for you with a Zoho Consent form where you confirm whether your app is allowed to access the data within the specified scope(s). If you run this as a standalone, then this will simply tell you what the link...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: en-GB
  15. CSS Center an iFrame Horizontally and Verticallyhttps://joellipman.com/articles/web-development/css/css-center-an-iframe-horizontally-and-vertically.html

    a quick article to demo how to center an iframe horizontally and vertically in a screen/viewport in pure CSS (no JavaScript allowed). This CSS centers it by its center point rather than the top/bottom/left/right outline. Why? On a mobile, a client's...

    • Type: Article
    • Author: Joel Lipman
    • Category: Cascading Stylesheets
    • Language: en-GB
  16. Zoho Creator: Retrieve record with case-insensitive queryhttps://joellipman.com/articles/crm/zoho/zoho-creator-retrieve-record-with-case-insensitive.html

    l_ProductDetails = Product[Product_Name.toLowerCase() = v_Name.toLowerCase()];... Returns the error: "Expression is not allowed in left side of a Criteria". There used to be an old solution for doing this and can still be found in the community forums...

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

    or to be safe ZohoCRM.modules.ALL ZohoCRM.settings.READ ZohoCRM.users.READ Problem: Code 37: The HTTP method PUT is not allowed for the requested resource This was an issue where I was trying to push a Zoho Creator record into Zoho Inventory via an...

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

    "joelconnector" ]; Additional I'd always recommend locking down your app privileges 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...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  19. Zoho Creator: Create a Widget which uses JavaScripthttps://joellipman.com/articles/crm/zoho/zoho-creator-create-a-widget-which-uses-javascript.html

    time of print (2020-10-24), Zoho Creator does not allow you to use JavaScript anywhere in its app. HTML and CSS are mostly allowed but JavaScript automatically gets removed from any of your code. How? As someone who's been using Zoho services and...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  20. Zoho Creator: Set Up Custom Domain for Customer Portalhttps://joellipman.com/articles/crm/zoho/zoho-creator-set-up-custom-domain-for-customer-portal.html

    CNAME record with the following: name as .myparentdomain.com ("code" is 6-character code obtained in step 1c above) If allowed set the TTL (time to live) to 300 Set the CNAME value to creator.cs.zohohost.com or creator.cs.zohohost.eu (depending on if...

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

Please publish modules in offcanvas position.