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

  1. ZohoRecruit: Create Linking Table for Candidates and Associated Job Openingshttps://www.joellipman.com/articles/crm/zoho/zoho-recruit/zohorecruit-create-linking-table-for-candidates-and-associated-job-openings.html

    + v_CandidateZohoID + r_Data.get("id") + ")"; l_CheckExists = invokeurl [ url :v_SearchEndpoint type :GET connection:"my_connection" ]; v_CountExists = 0; if(!isnull(l_CheckExists.get("data"))) { for each r_Check in l_CheckExists.get("data") {...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Recruit
    • Language: *
  2. Zoho Deluge: Shopify API: Get all active products with GraphQL and Paginationhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-shopify-api-get-all-active-products-with-graphql-and-pagination.html

    :v_Subject message :v_Message Attachments :file:v_CSVFile ] } Error(s): {"errors":[{"message":"Field 'endCursor' doesn't exist on type...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  3. ZohoCRM Webhook: Create ZohoInventory Records from an eBay orderhttps://www.joellipman.com/articles/crm/zoho/zoho-inventory/zohocrm-webhook-create-zohoinventory-records-from-an-ebay-order.html

    Purpose: Queries eBay for information about an order and then creates item/contact/sales order/package slip/invoice (if not exist) Date Created: 2022-05-05 (Joel Lipman) - Initial release Date Modified: 2023-01-23 (Joel Lipman) - Revamp of code - Only...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Inventory
    • Language: *
  4. ZohoBooks: Error Code 15: Ensure Billing Address has less than 100 charactershttps://www.joellipman.com/articles/crm/zoho/zoho-books/zohobooks-code-15-ensure-billing-address-has-less-than-100-characters.html

    connection:"zcrm" ]; // should be checking here that data contains any rows but I'm going on the basis that this quote exists in CRM and at least 1 line item is mandatory l_CrmProductLineItems =...

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

    m_UserSignature.put("signature",v_ThisSig); l_UserUpdates.add(m_UserSignature); //} } // // if updates exist then update the users module with these new signatures if(l_UserUpdates.size() > 0) { m_Params = Map(); m_Params.put("users",l_UserUpdates);...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  6. Installing phpBB3 for Joomla with a RocketTheme templatehttps://www.joellipman.com/articles/cms/joomla/installing-phpbb3-for-joomla-with-a-rockettheme-template.html

    any other link returned an error something along the lines of "template tpl load file styles prosilver login body does not exist empty". I backed up my local copy of the prosilver folder as well as my local copy of the Affinity for phpBB3 template. I...

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

    the last step of this migration. Rename admin ID in the UPGRADE database We want to make sure that the new user ID doesn't exist in our upgraded system because we may have a user with that ID in the old system who might inherit privileges they shouldn't...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  8. Upgrading Joomla CMS version 3.x to Joomla CMS 5.xhttps://www.joellipman.com/articles/cms/joomla/upgrading-joomla-cms-version-3-x-to-joomla-cms-5-x.html

    `user_id`333; Akeeba Backup Install: Warning JInstaller: :Install: Error SQL Table 'newdb.#_akeebabackup_profiles' doesn't exist Extension installation stopped. Package Install: There was an error installing an extension: com_akeebabackup-core.zip...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  9. SSIS: How to loop through multiple flat files as data sourceshttps://www.joellipman.com/component/content/article/ssis-how-to-loop-through-multiple-flat-files-as-data-sources.html?catid=74&Itemid=165

    type @[User::SourceExtractFile] OK to save it Add the ForEach Loop Container to your "Control Flow" (NB: This did not exist in my data flow ssis toolbox - if you do not see it when you are under the "Control Flow" design tab, then select Tools > Choose...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  10. Problem creating SSRS report subscriptionshttps://www.joellipman.com/component/content/article/problem-creating-ssrs-report-subscriptions.html?catid=75&Itemid=165

    in the dropdown menu Select "Data Sources" in the left menu Specify a "shared data source" and browse to it to ensure it exists. Ensure unattended system account scheduled to run and email the report can access the datasource (ask a DBA if you're...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  11. Hide a Drive per User in Windows 7https://www.joellipman.com/component/content/article/hide-a-drive-per-user-in-windows-7.html?catid=80&Itemid=165

    the key. We'll call it Foo. Go to HKEY_USERS\Foo\Software\Microsoft\Windows\CurrentVersion\Policies If it does not already exist, create a key called Explorer Create a new 32-bit DWORD value inside the Explorer key/folder and name it NoDrives (or...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  12. T-SQL concatenate an incremental row numberhttps://www.joellipman.com/articles/else/database/t-sql/t-sql-concatenate-an-incremental-row-number.html

    quick article on how to use a counter added to the end of a field column of data. Eh. What? Assume the following two tables exist: TABLE: Employee -------------------------------------------------- ID FirstName Surname 1 Joel Lipman 2 Another Joe TABLE:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
  13. Fix Oracle Tnsping 3511 without Windows Registryhttps://www.joellipman.com/articles/else/database/oracle-pl-sql/fix-oracle-tnsping-3511-without-windows-registry.html

    Variables" Under "System Variables" modify the variable "ORACLE_HOME" (without the quotes). Or create NEW if it doesn't exist. Give it the value C:\ORACLE\product\11.2.0\client_1 OK all dialogs to close and save. Additional The affecting TNSNAMES.ORA...

    • Type: Article
    • Author: Joel Lipman
    • Category: Oracle PL/SQL
    • Language: en-GB
  14. Merge the content of two similar tables in MySQLhttps://www.joellipman.com/articles/else/database/mysql/merge-the-content-of-two-similar-tables-in-mysql.html

    of any valid articles from BOTH tables and return one table with everything I want. Consider the following two tables exist: Joomla Articles (table name: jos_content): id title introtext...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  15. Project Plan for Freelance Websitehttps://www.joellipman.com/articles/cms/website-development/project-plan-for-freelance-website.html

    system. Create test space with same access details. Database Setup For JoelLipman.Com to do: Backup original database if exists already Assign unique database name Assign unique database username/password Add the user to the database Create test...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
  16. 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

    feature just isn't available to you. Note: The temporary file gets deleted when the script finishes. So the file shouldn't exist if you check after the script has completed. Do the following step to keep the file in a specified folder. 5. Form...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
  17. Is it a scam? Gumtree.com's warning signshttps://www.joellipman.com/component/content/article/is-it-a-scam-gumtreecoms-warning-signs.html?catid=116&Itemid=165

    as English Bulldogs, Yorkshire Terriers and Chihuahuas. These ads are usually accompanied by staged pictures. The pets don't exist and the fraudsters are simply trying to get you to pay money upfront. Remember, be wary of overseas sellers. Source:...

    • Type: Article
    • Author: Joel Lipman
    • Category: IT Support
    • Language: *
  18. Passwords: Did-you-knowhttps://www.joellipman.com/component/content/article/passwords-did-you-know.html?catid=116&Itemid=165

    Guess It, Brute Force (=try every combination), Dictionary Attack (=try every combination starting with words that exist). (source: Lockdown: Choosing a good password) And some more which have become more popular in recent years: There are loads of...

    • Type: Article
    • Author: Joel Lipman
    • Category: IT Support
    • Language: *
  19. 404: Page Not Foundhttps://www.joellipman.com/component/content/article/404.html?catid=50&Itemid=165

    that was on the old site is still to be found on our new website at www.joellipman.com. The Page you are looking for doesn't exist or an other error occurred. Go back, or head over to Joel Lipman .Com to choose a new direction.

    • Type: Article
    • Author: Joel Lipman
    • Category: Static Items
    • Language: *
  20. Joomla Development: Possible XML Filtershttps://www.joellipman.com/articles/cms/joomla/joomla-development-possible-xml-filters.html

    the value to be a base64 encoded the string. Note it does not encode the string, it simply strips characters that may not exist in a base 64 encoded string. STRING Removes HTML HTML Allows basic HTML ARRAY Forces value to be an array PATH Forces value...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
Results 21 - 40 of 41