Search - Joel Lipman .Com

1. mysqldump: Got error: 2049: Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure_auth' enabled) when trying to connec: / MySQL /; ... in order to make a change on a live system to a service user account... Especially one used by the scripts to access the database-driven website. How? I'm first going to highlight 2 methods which ...; Created on 28 July 2014
2. Parameters not being used in report processing: / SQL Server Reporting Services /; ... declare the parameters used by the software within the SQL script... So the above should look more like this: -- =============================================================================== -- ...; Created on 07 January 2011
3. Zoho CRM & Zoho Books: Get SalesPersons: / Zoho /; ... to assign the sales person. How? So after an hour or so trying to get the Zoho.books.getRecords() function to filter the sales persons, I gave up and used a for each loop instead. In the next ...; Created on 30 August 2021
4. Zoho CRM & Zoho Books: Custom Related Lists Deluge: / Zoho /; ... need to be adapted for your needs. Note that I have used 2 URL methods of linking to the Creator app and some data formatting that I tend to use regularly for my benefit later on when I simply copy & ...; Created on 30 July 2021
5. Zoho CRM REST API: Stop Workflow from Triggering: / Zoho /; ... equivalent Creator record). There was also a workflow that ran when the Creator record was updated to update its changes to CRM. It was actually causing a loop which used up all the API calls. How? ...; Created on 16 June 2021
6. Windows OS: Alt Codes / Symbols / Special Characters: / Windows OS /; .joellipman-alt-code-table{ width:100%; max-width:400px; margin:0 auto; border:1px; } .joellipman-alt-code-table td:first-child{ width:40px; } .joellipman-alt-code-table td:nth-child(2){ width:300px; } What? ...; Created on 03 June 2021
7. Zoho CRM: Update a custom field in line items / product details using REST API v2.1: / Zoho /; ... to update the field with label "Group Name" but API name "Grouping" in a list item column. The standard code you used to use even for REST API v2.0 would have been something like the following: // // ...; Created on 17 May 2021
8. Zoho Projects: Add a Time Log to an Issue using Deluge: / Zoho /; ... to when trying to enter a time against a project Task but this article is focused on getting this working against Project Issues. Also note, we will refer to Project Issues in this article, but in the ...; Created on 30 April 2021
9. Zoho People: Reject an Application for Leave in Deluge based on Criteria: / Zoho /; ... "message": "Field name 'ApprovalStatus' is invalid " }, "status": 1 } } [Warning: Another red herring ahead] We tried various other options such as adding a tickbox that would be used ...; Created on 10 December 2020
10. Zoho Creator: Set Up Custom Domain for Customer Portal: / Zoho /; ... usually have 3: .joellipman.com (used in verification), .joellipman.com and www..joellipman.com (for the subdomain). I have had this working with the 2 CNAME records though. Some providers say this ...; Created on 17 November 2020
11. Zoho Creator: info/alert/modal/popup notification for any user: / Zoho /; ... of a link on a page. Why? Because alert (alert task) can only be used on a load of a form, on a change of a field or on the validate process. And because info can only be displayed to an admin ...; Created on 06 November 2020
12. Zoho Creator: Create a Widget which uses JavaScript: / Zoho /; ... for my colleagues. The below instructions follow a fresh install as if this is the first time this computer has created a Zoho Creator Widget. Software used: Zoho Creator v5 (Plan Premium or greater ...; Created on 24 October 2020
13. Zoho Creator Page: Toggle On/Off Switch: Hide/Display a Div: / Zoho /; ... devices which you'll need to tweak to display in a way other than the previous preview images. You can change the shape, content and colors used for the on/off switch but try to keep the on/off css section ...; Created on 22 October 2020
14. Expecting ZC_SUBFORM_250 expression found COLLECTION: / Zoho /; ... the Creator Deluge syntax I was using to insert subform rows was wrong. Contrary to the documentation that says "This task can be used in the following events", effective as of today October 19, 2020, ...; Created on 19 October 2020
15. Zoho Deluge: Setup an API Connection for InvokeURL: / Zoho /; ... access/refresh tokens using OAuth2.0. Usually used with an invokeUrl: response = invokeUrl [ url: "https://books.zoho.com/api/v3/estimates?organization_id=12346789" type: GET connection: "joelconnector" ...; Created on 12 August 2020
16. Windows 10: Shortcut Apps to Settings: / Windows OS /; Applies To: Microsoft Windows 10 Pro v10.0.18362 What? This is a list of apps that if run via the run command, or used in a desktop shortcut, or that you want to include in automation software such ...; Created on 30 July 2020
17. AutoHotkey: App GUI Listview to Rename Files: / AutoHotkey /; ... simply reloads the app (used mostly for testing/development). Lastly, a listview that has 2 columns: the 1st lists the files in that directory, the 2nd displays the new filenames of the files. ; ; ...; Created on 08 July 2020
18. Zoho Deluge: Duplicate/Clone a Record: / Zoho /; ... in this example is the current date in format yyyy-MM-dd Due_Date in this example is at the end of the current month: so add 1 month, go to the start of that month, subtract 1 day. .toEndOfMonth() used ...; Created on 17 March 2020
19. MySQL: Count occurrences of words in a column: / MySQL /; What? This is an article to document how to output the most frequently used words in a MySQL database column. How? Note this only applies to MySQL. So the following query will return a count ...; Created on 12 March 2020
20. Zoho CRM/Creator - Common Errors & Gotchas: / Zoho /; ... Can happen when trying to setup an OAuth connection: ERROR_Invalid_Redirect_URI Solution: The redirect URI in your app does not match the redirect used in the authorization request. They need to ...; Created on 06 February 2020