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

  1. 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

    Give it an API version (eg. "2022-01" - or whichever is the latest stable version) Location ID if you know it, otherwise leave blank (eg. "123456789") Location Code if you know it (eg. "GB") Get access to the Shopify Admin Interface: Request access to...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  2. ZohoCRM: Import Attachmentshttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-import-attachments.html

    v_ProcessID v_FileName_Success := "Success_" v_ProcessID v_FileName_Prep := "Prep_" v_ProcessID ; to be set on setup (leave blank) v_TotalHours := 0 v_YourProfile := "" v_YourEmail := "" v_YourBrowser := "" v_YourName := "" v_Message := "" v_YourDate :=...

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

    Add key button Give it a description, assign a user that it will run as (preferably of the admin or account that will never leave the business), and permissions can be "Read". Click on the "Generate API Key" button Note the consumer_key and...

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

    system go out of whack and some records would slip through the net while every day, the process to tidy these all up would leave the data more and more unreliable. So Shopify want your webhooks to respond within 1 second. This is about enough time to...

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

    Drive") Click on Next have a quick glance of the preview and then click on Next First row contains column names = Yes, leave everything else as plain text except for Description which you should change to a Multi Line Text. Click on Create. You should...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho People
    • Language: *
  6. How to redirect the visitor after the contact pagehttps://www.joellipman.com/articles/cms/joomla/how-to-redirect-the-visitor-after-the-contact-page.html

    you copy the URL you may un-publish your menu item that links to the redirect page in the admin interface, but make sure you leave the redirect page published. Step Three: To finish and make it all work requires editing of a single file in the Joomla...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  7. Registered Users Cannot Login - Super Users Canhttps://www.joellipman.com/articles/cms/joomla/registered-users-cannot-login-super-users-can.html

    see more than one record with a value of 0, then change it to 1. If it's name is "root..." and title is "Root Asset" then leave this as having a parent_id of 0. The fix is immediate after the change is committed to the database. NTS: Possible Related...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  8. Export Joomla Users scripthttps://www.joellipman.com/articles/cms/joomla/export-joomla-users-script.html

    get all your users listed... For security reasons, delete the file after you have used it. IT IS A SERIOUSLY BAD IDEA TO LEAVE THIS FILE ON YOUR WEBSITE FOR ANYONE TO ACCESS!!! DELETE IT AFTER USE.

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  9. Transferring Apps (purchases) from iPhone 4s to 5s on a Windows PChttps://www.joellipman.com/articles/else/app-dev/ios/transferring-apps-purchases-from-iphone-4s-to-5s-on-a-windows-pc.html

    (can take as long as the restore/backup) Done Unplug your new phone and test. Ta daa! If this article helped you, please leave a comment below, it's FREE and can be anonymous.

    • Type: Article
    • Author: Joel Lipman
    • Category: iOS
    • Language: *
  10. SSRS Querying on either of 2 Parametershttps://www.joellipman.com/component/content/article/ssrs-querying-on-either-of-2-parameters.html?catid=75&Itemid=165

    complain, do what Microsoft suggests and throw more memory at the SQL Server. The remaining issue is what if the user leaves both fields blank? This would return all users who don't have an AD account. Using the revisited solution below -> Just leave...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  11. SSRS Dropdown parameter cannot be blank!https://www.joellipman.com/component/content/article/ssrs-dropdown-to-allow-blank-values.html?catid=75&Itemid=165

    by a list of all available reports. Why? I want the report to be run with the 3rd and 4th parameter as OPTIONAL. When I leave the 3rd and 4th parameter untouched (=""), the report complains saying "Report #3 parameter cannot be blank!". Before you ask,...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  12. Windows 7: System Clock is constantly going out of synchttps://www.joellipman.com/component/content/article/windows-7-system-clock-is-constantly-going-out-of-sync.html?catid=80&Itemid=165

    prevent it finding the wrong time (again) Check the clock has updated in your taskbar and close the window by clicking on OK Leave your computer for a few hours and see if it keeps the time... If the problem persists, try changing the system registry...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  13. Search a database for a string (MySQL, T-SQL)https://www.joellipman.com/articles/else/database/search-a-database-for-a-string-mysql-t-sql.html

    THEN # Inserting required results from search to table INSERT INTO temp_details VALUES(db,tbl,clmn); END IF; IF done=1 THEN LEAVE table_loop; END IF; END LOOP; CLOSE table_cur; #Finally Show Results SELECT concat("SELECT * FROM ",t_table, " WHERE ",...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: en-GB
  14. Delete related records from multiple tableshttps://www.joellipman.com/articles/else/database/mysql/delete-related-records-from-multiple-tables.html

    here's the query to only delete records in Session and SessionStudent represented by aliases s and sst respectively and to leave SessionStaff table unchanged: DELETE s, sst FROM `Session` s LEFT OUTER JOIN `SessionStaff` ssf ON ssf.sessionId=s.sessionId...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: *
  15. FTP on Mac: Failed to retrieve directory listinghttps://www.joellipman.com/articles/cms/website-development/ftp/ftp-on-mac-failed-to-retrieve-directory-listing.html

    > Security & Privacy > Firewall Click the lock to make changes Firewall Options Untick "Block all incoming connections" Leave the boxes ticked EXCEPT for "Enable Stealth Mode" Settings Security and Privacy Firewall Firewall Options Note: the filezilla...

    • Type: Article
    • Author: Joel Lipman
    • Category: File Transfer Protocol
    • Language: *
  16. Inline Labels in Form Fields using Javascripthttps://www.joellipman.com/articles/cms/website-development/js/inline-labels-in-form-fields-using-javascript.html

    case, check if the field is empty, if it is, change the value back to "Name:" and the color back to grey. If it isn't, then leave as is and ensure the color is still black. Additional Note that instead of just saying if this value equals "Name:" I've...

    • Type: Article
    • Author: Joel Lipman
    • Category: JavaScript
    • Language: en-GB
  17. Preg_Replace all strings between two tagshttps://www.joellipman.com/articles/cms/website-development/php/preg-replace-all-strings-between-two-tags.html

    ( World ) » Hello ( World ) $string_formatted = preg_replace( '/[a-z_ -]+\ \(/i','$0', $string_original); Anymore? Please leave a comment if I've missed some useful ones out.

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: *
  18. How To Make Chocolate Chip Cookieshttps://www.joellipman.com/component/content/article/how-to-make-chocolate-chip-cookies.html?catid=96&Itemid=165

    it. That's your dough. Step 3: Drop Drop globs of dough, by rounded tablespoons, onto an parchment paper-lined cookie sheet. Leave about 2 inches between cookies - they'll spread out when they bake. Step 4: Bake Bake your cookies about 8-10 minutes,...

    • Type: Article
    • Author: Joel Lipman
    • Category: Hobbies
    • Language: *
  19. Excel PivotTable Filter List Orderinghttps://www.joellipman.com/component/content/article/excel-pivottable-filter-list-ordering.html?catid=110&Itemid=165

    A". You may find that the field needs to be unlinked and relinked each time further dates get added which is why you should leave it in ascending order if you don't want this overhead.

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  20. 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

    later. At this point, the bank/building society will take the full cheque amount back out of your account. This would then leave you out of pocket for the amount on the cheque and the amount you passed on as the difference. Fake escrow sites. A...

    • Type: Article
    • Author: Joel Lipman
    • Category: IT Support
    • Language: *
Results 21 - 40 of 49