Search - Joel Lipman .Com

1. Android: Replace return key with done, go, send...: / AndroidOS /; What? A quick article on how to replace the return key on a soft keyboard (software based) on a touch-device. Why? I have an editText where a user can enter any text value but if they typed a ...; Created on 03 November 2014
2. Include a carriage return in a column heading: / SQL Server /; Applies To: MS SQL Server 2008 R2 MS Windows 7 Enterprise (Client) MS Excel 2010 What? A really quick note on how to insert a carriage return or new line into the column name/alias (the header). ...; Created on 07 July 2014
3. No rows returned in Oracle causes SP to fail: / Oracle PL/SQL /; Why? We have a stored procedure which contains two select queries. The first query will retrieve a student ID number where the input parameter is the student's username. The second query will return ...; Created on 24 January 2012
4. Returning Oracle Stored Procedure Resultset in SSRS: / SQL Server Reporting Services /; ... 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 be returned in SSRS ...; Created on 19 January 2012
5. Returned a data type that is not valid: / Transact-SQL /; ... local report processing. An error has occurred during report processing. The Group expression used in grouping 'table1_month' returned a data type that is not valid. My DataSet Query was as follows: SELECT CONCAT(MONTHNAME(t1.Date), ...; Created on 06 January 2011
6. Clicking on a weblink returns a 404 error: / Joomla /; If you are in the administration panel and you are editing your weblinks and you come across this error: "404 - An error has occurred. Joomla! was unable to locate the stated resource." ...; Created on 06 November 2009
7. $_SERVER['http_referer'] returns blank in Internet Explore: / Microsoft /; Thought I'd put a note about this as I spent ages rewriting an entire system. The HTTP_REFERER environment variable can be changed by the user anyway but I was using it as an additional validation check. ...; Created on 19 October 2009
8. Zoho Projects: Add a Time Log to an Issue using Deluge: / Zoho /; What? This is an article to demonstrate how to log a time event under a Zoho Projects Issue using code (Zoho Deluge) rather than the graphical user interface (GUI). Note this would probably be similar ...; Created on 30 April 2021
9. Zoho Creator: Download File from ZohoCRM field type "File Upload" (not attachments: / Zoho /; ... key it returns you. eg. https://creatorapp.zohopublic.eu + zoho.appuri + report-perma/Download_File_Report/abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKL ...; Created on 02 February 2021
10. Zoho People: Reject an Application for Leave in Deluge based on Criteria: / Zoho /; ... very quick percentage calculation snippet of code to work this out: // calculate percentage v_Percentage = (v_TotalClashes / v_TotalDeptEmployees * 100).round(0); Return an error if overbooked, ...; Created on 10 December 2020
11. Zoho Creator: Button on Report for Merging Multiple Selected Records: / Zoho /; ... Workflow > Functions > New Function: give the function a name select "Deluge" as the language give it a Namespace (for this example I will leave this on "Default") and set the return type (again in ...; Created on 06 December 2020
12. Zoho Creator: Create a Widget which uses JavaScript: / Zoho /; ... should get prompted for the Mac/Admin password which you type in the terminal (will not display, just type away and press the Return key). The response will be something like “added 98 packages from 60 ...; Created on 24 October 2020
13. Zoho Deluge: Search Records with Special Characters (COQL): / Zoho /; ... = ifnull(r_Coql.get("data").get(0).get("id"),0); } Note that for the above, if there are no matching records, r_Coql will simply return an empty string. Hence the check for isNull on the keys info and ...; Created on 28 August 2020
14. Zoho Deluge: Setup an API Connection for InvokeURL: / Zoho /; ... Setting up the Oauth Connector So return to your Zoho Books instance (or Subscriptions, Inventory, app you were making the connection): From within books (or inventory, subscriptions as ...; Created on 12 August 2020
15. AutoHotkey: Get Media Information and Display: / AutoHotkey /; ... xDetails := "" Return } fex := {}, _FileExt := "" Loop, Files, % RTrim(sfile,"\*/."), DF { If not FileExist( sFile:=A_LoopFileLongPath ) { ...; Created on 07 August 2020
16. AutoHotkey: App GUI Listview to Rename Files: / AutoHotkey /; ... s7, Verdana Gui, Add, StatusBar,, Ready. Gui, Show, w%Width% h%Height% x10 y10 Return ; -------------------------------------------------------------------------------------- ; Function: CountExistingInColumn2: ...; Created on 08 July 2020
17. Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Books: / Zoho /; ... window/tab Right-click on one of the file upload/attachments and copy the link Return to your code and customize the permalink so it looks the same but appends the file name See the following as ...; Created on 15 May 2020
18. Zoho Deluge: Duplicate/Clone a Record: / Zoho /; ... for "Invoices": /* Function: fn_Button_CloneInvoice Purpose: This function duplicates a CRM invoice Parameters: p_InvoiceID (CRM ID of the invoice) Returns: Nothing Author: Joel Lipman Date Created: ...; Created on 17 March 2020
19. JComments errors in PHP 7: plgContentJComments and JCommentsACL: / Joomla /; What? During a site upgrade, the commenting extension for Joomla called JComments would return errors when using PHP version 7. This is a quick article to document what needed doing to fix the errors. ...; Created on 13 March 2020
20. 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