Search - Joel Lipman .Com

1. Zoho Deluge - Store and repopulate a multi lookup list in Creator: / Zoho /; What? A quick reminder on how I got a working snippet of code to store the entries in the lookup already selected, check against another table/form for valid options, repopulate the list with the selected ...; Created on 28 June 2019
2. Restore MSSQL Error: Database is in use: / Databases /; What? This is an article on how to do a restore from backup on a database but when you get the error: "... database is in use". -- SQL Server 2005 EXEC SP_WHO // details on who is logged ...; Created on 08 March 2013
3. 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
4. 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
5. 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
6. 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
7. 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
8. Setting up your store to use SSL: / eCommerce Systems /; To setup your store to use SSL (Secure Socket Layer) you will first need an SSL certificate. Many hosting companies will either provide (or can offer) "Shared SSL" or the option to buy a "Dedicated SSL" ...; Created on 11 September 2009
9. 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
10. 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
11. Zoho Webhooks & Shopify API: Keep Disappearing: / Zoho /; What? This is an article to show how to setup a scheduled function that checks and restores a missing webhook as well as the snippets when receiving the webhooks and storing them. Why? We found ...; Created on 22 April 2024
12. ZohoCreator: Basic Widget with Zoho Data: / Zoho /; ... { // store the search results into an array var recordArr = response.data; // quick loop to find the preferred name ...; Created on 14 March 2024
13. Zoho Creator: Get Images in Report to be Exported to PDF: / Zoho /; ... store this after the record is created/updated (was getting error if included in record creation - if in same row). // c_ImageRow.File_field = f_DownloadFile; // // let's get the local ...; Created on 26 January 2024
14. 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
15. Zoho Deluge: Get the Week Number if Week starts on a Monday: / Zoho /; ... // returns 2020 You should also pad single digit week numbers if we're going to store a year week value: v_ThisCurrentWeekNumber = if(zoho.currentdate.toString("u").toLong() == 7,zoho.currentdate.subDay(1),zoho.currentdate).toString("w"); v_ThisCurrentWeekNumberPadde ...; Created on 06 July 2023
16. ZohoCRM Webhook: Create ZohoInventory Records from an eBay order: / Zoho /; ... API for the eBay store /* Function: fn_eBay_GetOrderInfoCreateUpdateZohoSO(string p_eBayOrderRef) Purpose: Queries eBay for information about an order and then creates item/contact/sales ...; Created on 27 April 2023
17. Zoho Deluge: Get All Orders from eBay: / Zoho /; ... each index v_Increment in l_AddPages { l_Pages.add(v_Increment + 1); } v_TotalNumberOfPages = l_Pages.size(); // // declare variables to store order details in a JSON or ZohoDeluge Map format m_Response ...; Created on 29 March 2023
18. ZohoBooks: Stripe Terminal Integration: / Zoho /; ... = invokeurl [ url :v_CaptureIntentEndpoint type :POST parameters:m_CaptureParams headers:m_Headers ]; // // get card details (we need to store last 4 digits) v_StripeReference = ""; v_Last4Digit ...; Created on 16 March 2023
19. ZohoCRM: Integrate ChatGPT to ZohoZIA: / Zoho /; ... ) == "assistant") { // // add the answer text to the response map v_Response = m_Choice.get("message").get("content"); } } } } else { // store in response text v_Respon ...; Created on 06 March 2023
20. ZohoCRM: Get All eBay Active Listings: / Zoho /; ... level or stock check of all the products that are currently listed in a client's eBay store; we want to get the stock level and then use this data to synchronize with data held in Zoho Inventory... How? ...; Created on 01 March 2023