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

  1. Returning Oracle Stored Procedure Resultset in SSRShttps://www.joellipman.com/component/content/article/returning-oracle-stored-procedure-resultset-in-ssrs.html?catid=75&Itemid=165

    source=oracle sp field name) 1. Create a stored procedure using a cursor for SSRS CREATE OR REPLACE PROCEDURE sp_get_studentdetails_from_ad ( p_STUDENT_ADNAME IN varchar2, l_CURSOR OUT sys_refcursor ) IS BEGIN -- going to declare variables that are to...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  2. No rows returned in Oracle causes SP to failhttps://www.joellipman.com/articles/else/database/oracle-pl-sql/no-rows-returned-in-oracle-causes-sp-to-fail.html

    FROM student_accounts WHERE student_accounts.studentUsername = trim(:p_myinparameter); SELECT NVL(student_details.studentFirstname, 'John') "FORENAMES", NVL(student_details.studentSurname, 'Smith') "SURNAME" FROM student_details WHERE...

    • Type: Article
    • Author: Joel Lipman
    • Category: Oracle PL/SQL
    • Language: en-GB
  3. 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

    demonstration purposes, I'm going to create a table update process (TUP) based around a change in the course application details. Some of the screenshots are censored for confidentiality but nothing relating to the instructions will be hidden. We will...

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

    alarm bells and shouldn’t be followed. An email allegedly from «CompanyName» (or another company) asking for your personal details - logins/passwords/credit card details. You get an email that claims to be from «CompanyName» or another company and...

    • Type: Article
    • Author: Joel Lipman
    • Category: IT Support
    • Language: *
  5. Zoho Creator / Shopify: Get all Active Productshttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-shopify-get-all-active-products.html

    { m_Header = Map(); m_Header.put("Content-Type","application/json"); // // your shopify details v_ClientID = ""; v_ClientSecret = ""; v_ShopID = "example.myshopify.com"; v_ShopifyURL = "https://" + v_ClientID + ":" + v_ClientSecret + "@" + v_ShopID;...

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

    int p_ProductID) { v_Output = ""; m_Header = Map(); m_Header.put("Content-Type","application/json"); // // your shopify details v_ClientID = ""; v_ClientSecret = ""; v_ShopID = "example.myshopify.com"; v_ShopifyURL = "https://" + v_ClientID + ":" +...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  7. Zoho CRM: Schedule a Call using Delugehttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-schedule-a-call-with-deluge.html

    into over an hour of figuring this out. So here's a working snippet of code: // test to get the JSON response format r_CallDetails = zoho.crm.getRecordById("Calls",123456789012345678); info r_CallDetails; // // system/application is set to EST...

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

    use-case scenario here is that we have a Zoho Creator app which comprises of a custom quote builder that staff use to store details about a product, and then to push that product out to their Shopify store with a pre-built description, tags and...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  9. Zoho Creator: Disable/Hide the add and delete subform row buttonshttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-disable-hide-the-add-and-delete-subform-row-options.html

    to brush up a little on your CSS with regard to referring to elements by ID, so for example, if my subform is called "Item Details", then I would adjust the code to something like the following: // // CSS overrides v_CssNotes = ""; v_CssNotes =...

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

    lot of code or long URLs such as a base64 source URL for an image. The Plan Get company phone and website from Organization Details in ZohoCRM. Upload and get publicly-accessible image URL to/from ZohoWriter. Loop through active users in ZohoCRM. Merge...

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

    REST API endpoint of it. This will need to be triggered whenever there is an update to the order (especially when tracking details are changed on the order). /* ******************************************************************************* Function:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Shopify
    • Language: *
  12. SSRS Retrieving Oracle Stored Procedure Success or ErrorLevelhttps://www.joellipman.com/component/content/article/ssrs-retrieving-oracle-stored-procedure-success-or-errorlevel.html?catid=75&Itemid=165

    in SQL Server Reporting Services 2008 R2 (SSRS) reading from an Oracle 10g database which works great and lists all the details on a specific student. An additional request is that there appears a link that will run a stored procedure which Updates a...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  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

    FOR NOT FOUND SET done=1; #Truncating table for refill the data for new search. PREPARE trunc_cmd FROM "TRUNCATE TABLE temp_details;"; EXECUTE trunc_cmd ; OPEN table_cur; table_loop:LOOP FETCH table_cur INTO search_string,db,tbl,clmn; #Executing the...

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

    (for client to do so they retain overall control of the company) Who will be working on this project? (supply contact details) Rates (usually £9/hour for non-e-commerce sites or £15/hour for e-commerce) Similar looking websites where layouts/colour...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
  15. Developer's Checklist: Taking over a projecthttps://www.joellipman.com/articles/cms/website-development/developers-checklist-taking-over-a-project.html

    to ask the developer The original client's brief for the project? (project mandate/charter/initiation document - the spec) Details on the Development Environment (is there a TEST system and deployment procedure in place?) Known Issues/Bugs (is there an...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
  16. Joel's Reference to MidJourney v4 Promptshttps://www.joellipman.com/component/content/article/joel-s-guide-to-midjourney-prompts.html?catid=115&Itemid=165

    Summer during Twilight Victorian Vintage Winter during World War Level of Detail 8k resolution Hyper-realistic Intrinsic Details Photo-realistic Precise Details Cameras...captured using a... Canon EOS R Camera Nikon D850 Type of Filter/Lens...with...

    • Type: Article
    • Author: Joel Lipman
    • Category: Graphic Design
    • Language: *
  17. Joe's Unduplicater (JUD)https://www.joellipman.com/component/content/article/joes-unduplicater.html?catid=53&Itemid=165

    Added subtext to inform user at each stage of the process. - Added resize capabilities to the program. - Added more column details in the review list. v1.0 (17/05/2010) - Program to cycle through a folder of files to KEEP and check they already exist in...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  18. Joes DNS Correction (JDC)https://www.joellipman.com/component/content/article/joes-dns-correction2.html?catid=53&Itemid=165

    Display flushdns errorlevel - Display registerdns errorlevel - Change color to green if successful, red if failed. License Details: This program is free software: you can redistribute it and/or modify it under the terms of the GNU General Public License...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  19. Zoho People: Reject an Application for Leave in Deluge based on Criteriahttps://www.joellipman.com/articles/crm/zoho/zoho-people/zoho-people-reject-an-application-for-leave-in-deluge.html

    screenshot: Click on "Save" to accept this Note: It is important to add these parameters rather than trying to retrieve the details with a zoho.people.getRecordByID("P_ApplyLeave",v_RequestId) in the function because on application, the record doesn't...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho People
    • Language: *
  20. Zoho CRM: Upload a Product Photo using Delugehttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-upload-a-product-photo-using-deluge.html

    // specify your Creator record ID holding the image v_CreatorQuoteID = 9876543210987654321; // // get the full details of the Creator record r_GetFullRecord =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
Results 21 - 40 of 117