Search - Joel Lipman .Com

1. Stored Procedure to List Distinct Values and Counts: / Transact-SQL /; What? Yes you could just run a SELECT DISTINCT query along with collation to make it case-sensitive and/or accent-sensitive but using this stored procedure means I only specify the table and then the ...; Created on 26 October 2012
2. Returning Oracle Stored Procedure Resultset in SSRS: / SQL Server Reporting Services /; What? So I've spent a fun time googling and binging but still haven't found a simple and complete example of getting a resultset from an Oracle stored procedure and displaying this in SQL Server Reporting ...; Created on 19 January 2012
3. Basic Oracle Stored Procedure Structure: / Oracle PL/SQL /; Previously For a basic Oracle function, visit my article Basic Oracle Function Structure. For a more advanced version which uses cursors to work with SSRS, see my article Oracle Stored Procedures in ...; Created on 16 January 2012
4. SSRS Retrieving Oracle Stored Procedure Success or ErrorLevel: / SQL Server Reporting Services /; ... that there appears a link that will run a stored procedure which Updates a timestamp in an existing table Inserts a row into an audit table I need the report to run the stored procedure, then ...; Created on 04 November 2011
5. SSRS Parameters in Oracle Stored Procedure: / SQL Server Reporting Services /; ... add parameters to a Stored Procedure of an Oracle database from within Microsoft SQL Server Reporting Services. The Error ORA-00911: invalid character ORA-06512: at "SYS.DBMS_UTILITY", line 114 ...; Created on 02 September 2011
6. Zoho Creator: Input Color Picker: / Zoho /; ... on blank form, if loading an existing record, the value stored will be used. v_DefaultColor = if(isBlank(input.Hexadecimal), "#000000", input.Hexadecimal); // // a color palette l_ColorPalette = List(); l_ColorPalette.add(); l_ColorPalette.add(); l_ColorPalette.add(); l_ColorPalette.add(); l_ColorPalette.add(); l_ColorPalette.add(); l_ColorPalette.add(); l_ColorPalette.add(); // // ...; Created on 14 October 2024
7. Zoho Analytics: Create a Monitoring System with Images: / Zoho /; ... Pre-amble Have all the images you want to use ready for uploading into the system stored on your device. A URL (as in an image hosted on another website) can be used so you might skip the first section ...; Created on 25 July 2024
8. Zoho Books: Generate Bank Text File for Download: / Zoho /; ... Why is this a challenge? The file contains bank details and should not be stored anywhere. Generating a text or CSV file and then having it emailed to anyone is an easy task but here we cannot have ...; Created on 02 October 2023
9. ZohoCRM Webhook: Create ZohoInventory Records from an eBay order: / Zoho /; What? This is a not-so-quick article that queries an eBay order and creates the relevant ZohoInventory item, contact, sales order, package slip, shipment order, invoice, payment records... Why? ...; Created on 27 April 2023
10. ZohoCRM: Integrate ChatGPT to ZohoZIA: / Zoho /; ... very seriously, and they have implemented several measures to protect the data and models that are used by their services. When you train a model with OpenAI's services, your data is encrypted and stored ...; Created on 06 March 2023
11. Zoho Desk: Re-enable Desktop Notifications after clicking on "Not Now: / Zoho /; ... on “Settings” Click on “Privacy and Security” Click on “Site Settings” If the ZohoDesk activity appears then click into this, if not then: Click on “View permissions and data stored across sites” ...; Created on 20 July 2022
12. Zoho Creator: Receive eBay Notification and Create Shopify Order: / Zoho /; What? This is an article documenting how to parse the notification from eBay and using it to create an order in Shopify. Why? Previously, we would receive an eBay notification and create an ...; Created on 21 January 2022
13. Zoho Creator: Public URL of an Image field / Upload to Shopify API: / Zoho /; ... is "My_Photo" [also note: instead of zoho.appuri, we are hardcoding the appowner and appname as this is used across Creator apps, ie. images are stored in a separate app]: l_CompatiblePhotoExtensions ...; Created on 17 October 2021
14. Zoho Creator: Prevent Endless Loops On User Input of a Field: / Zoho /; ... eTag v_eTag = zoho.encryption.md5(input.Title.trim()); // // now compare to stored eTag if(v_eTag != input.eTag_Title) { input.eTag_Title= v_eTag; input.Audit_Change = "Title: " + zoho.encryption.md5(input.Title); } ...; Created on 19 September 2021
15. Minimal Privileges for MySQL Database Backup Cron Job: / cPanel /; ... Method #1: The following command on a cron job: // not recommended: /usr/bin/mysqldump -u dbusername -p'dbpassword' dbname > /path_to/backup.sql // recommended: using credentials stored in external ...; Created on 20 March 2019
16. Google Drive API v3 - OAuth2 using Service Account in PHP/JWT: / Google /; ... It also contains the public key under the guise of a URL (x509 certificate) but we don't need it for this script. Note that the key should not be stored in a public folder that is accessible via the web ...; Created on 02 February 2019
17. Zoho CRM: APIv2 using PHP & cURL: / Zoho /; What? This is an article documenting how to access ZohoCRM with API v2 using PHP and cURL. The first few functions are to manage OAuth v2 and generate the refresh and access tokens. The second snippet ...; Created on 30 January 2019
18. Display a thumbnail of a Google Drive video: / Google /; ... you need for the below). The image link (src) will be as below but then this is a redirect to the actual thumbnail stored by Google Drive: https://drive.google.com/thumbnail?authuser=0&sz=w320&id= // ...; Created on 13 November 2018
19. Google Authentication - OAuth 2.0 using PHP/cURL: / Google /; ... file (in JSON). If token is not required, use access_token stored in file. It is assumed that you have already registered the app with the Google developers console along with the redirect URI ...; Created on 31 October 2018
20. Foreign Characters create symbols in PHP and MySQL: / Personal Home Page /; ... Conclusion: The final fix in my case was due to me not specifying some extra parameters on the htmlentities or htmlspecialchars PHP functions. My database stored the foreign characters as the ...; Created on 25 January 2016