Submit form as a server and not the client with cURLhttp://mail.joellipman.com/articles/automation/api-misc/submit-form-as-a-server-and-not-the-client-with-curl.html

20 February 2015 A quick article on how to create a middleware script which accepts the values from a submitted HTML form and sends it to a server on another domain for processing. This applies to Linux Apache MySQL and PHP (LAMP) setups. Why? A customer wanted to...

• Type: Article
• Author: Joel Lipman
• Category: API Miscellaneous
• Language: *

Zoho Deluge: Nested Catch Statementshttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-nested-catch-statements.html

04 February 2025 to PDF — as in we send it a bit of code in HTML and we want a PDF file returned. I have severaly instances of an API which accepts HTML and returns a PDF file. Nothing complex but issues with one of the servers being down, or inaccessible due to...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Developer's Checklist: Taking over a projecthttp://mail.joellipman.com/articles/web-development/developers-checklist-taking-over-a-project.html

01 March 2011 (formats, defaults and vulnerability) Technical Review Examine all functions: what goes in, what comes out? (accepts/returns, data types specifically, test by running each function separately) Examine databases (data types, constraints, primary/foreign...

• Type: Article
• Author: Joel Lipman
• Category: Web-Development
• Language: *

Joes FREE Website Thumbnailer (JWT)http://mail.joellipman.com/component/content/article/joes-free-website-thumbnailer.html?catid=40

28 June 2011 - Option to set seconds between when the webpage loads and the screenshot. - RELEASED FOR DOWNLOAD! v0.4 (01/07/2011) - Accepts a text file containing a list of websites and batch processes the list. - Enabled output thumbnail quality options: 100`%,...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

SSRS Parameters in Oracle Stored Procedurehttp://mail.joellipman.com/articles/microsoft/ssrs/ssrs-parameters-in-oracle-stored-procedure.html

02 September 2011 Rather than a returned dataset, our Stored Procedure updates a field in one of our Oracle tables and returns nothing. It accepts 3 parameters: The StudentID (reference) varchar2, Username (who's running the report) varchar2 and a JobID (request...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

Basic Oracle Function Structurehttp://mail.joellipman.com/articles/database/pl-sql/basic-oracle-function-structure.html

15 January 2012 | AS [declaration_section] BEGIN executable_section [EXCEPTION exception_section] END [function_name]; Example: My example accepts an Active Directory (AD) username and returns the student ID: CREATE OR REPLACE FUNCTION fn_get_sref_from_adname...

• Type: Article
• Author: Joel Lipman
• Category: Oracle PL/SQL
• Language: en-GB

SSIS Script: convert UPPERCASE to Mixed-Case using TitleCasehttp://mail.joellipman.com/articles/microsoft/ssis/ssis-script-convert-uppercase-to-mixed-case-using-titlecase.html

04 October 2013 string name, string description) { throw new Exception(string.Format("Outputs cannot be added. The component only accepts inputs", ComponentMetaData.Name), null); } // This method is called once at Run Time // It creates an array (inputBufferColumnIdx)...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Integration Services
• Language: en-GB

Convert Past Date to Time Ago in PHPhttp://mail.joellipman.com/articles/web-development/php/convert-past-date-to-time-ago-in-php.html

16 May 2019 out there that do this perhaps better but this one I understand and can customize to fit my needs. This PHP function accepts as parameter a SQL date (or date format that strtotime() can convert) and outputs the largest unit (for example "1 year" not "1...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB

Zoho Creator: Button on Report for Merging Multiple Selected Recordshttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-button-on-report-for-merging-multiple-selected-records.html

06 December 2020 but this is one that works for me. How? So here's an overview and then we'll go into more detail: Create a function that accepts a form of records Create a workflow that understands the function parameters Create a function Why are we doing this first?...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Creator: Public URL of an Image field / Upload to Shopify APIhttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-public-url-of-an-image-field-upload-to-shopify-api.html

17 October 2021 + v_DocFileName; The API Solution The following solution requires that your target API accepts base64encoded images or that you can send these in a cURL request (same thing really): string API.fn_ShopifyQuery_UploadPhoto(int p_Position, int p_ProductID)...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *