Search - Joel Lipman .Com

21. Zoho Deluge - Hide Reset Button on Form: / Zoho /; What? So another quick note as I couldn't find a solution on the forums. This is to hide the reset button on a non-stateless form (state form?). I have posted this on the Zoho forums as well but here ...; Created on 15 November 2018
22. List of Font Awesome: / Web-Development /; ... [] 4.4  fa-fonticons [] 4.3  fa-forumbee [] ...; Created on 04 September 2015
23. Two icons created on Android: / AndroidOS /; What? If you're installing an app and it creates two icons: Why? I don't think I'll forget this one but I was stumped for a bit until I found it on the a forum: Stack Overflow: Android App Development. ...; Created on 20 October 2014
24. Batch Process to rename multiple files using Windows DOS: / MS-DOS /; ... the files). Type the followingDELETE rename.bat (removes it from the users computer) Exit the command prompt and we are Done Other Links: DOS - String Manipulation DosTips.com - Forums SS64.com ...; Created on 09 August 2014
25. mysqldump: Got error: 2049: Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure_auth' enabled) when trying to connec: / MySQL /; ... words, you don't have a boss): Method #1 (cowboy fix - not recommended): I would not recommend the following but I found this on the MySQL Forums. Someone solved their issue by resetting (or re-issuing) ...; Created on 28 July 2014
26. JComments 2.3.0 with ReCaptcha in Joomla 2.5.x: / Joomla /; ... Why? The kCaptcha used by the jComments extension is easily automated and no longer blocks spam comments. How? So the main bulk came from the JoomlaTune website but as it was a forum post ...; Created on 20 March 2014
27. ReCaptcha disappears from Joomla 2.5 Registration: / Joomla /; What? This is an extract from a forum which solved our problem for why the ReCaptcha part disappears from the user registration form. We have Joomla 2.5.16 installed and no new updates for a plugin ...; Created on 24 November 2013
28. Split a row into multiple rows based on a column value: / Transact-SQL /; ... do not account for days off (eg. Saturday / Sunday) How? Adapted from a forum topic: SQLTeam Forums First of all, we want the rows to multiply based on the value of the column: SELECT ...; Created on 23 August 2013
29. Reorder Columns in a Table: / Databases /; What? Just a quick note to myself on how to reorder columns as I was having difficulty using a phpMyAdmin interface to do this. How? Taken from the best forum for programming Qs&As: http://stackoverflow.com/questions/4095481/easy-way-to-re-order-columns ...; Created on 22 July 2013
30. Adding a selectable background to a Yootheme template: / Joomla /; ... > Save/Apply Done! Additional Note I do not work for Yootheme. I did not post this to Yootheme forums because you have to be a paying member to access these and I tend to piggyback on my ...; Created on 19 November 2012
31. Basic Joomla 2.5 Mootools Form: / Joomla /; ... Note: UPDATE 2012 It is important to refer to the correct mootools scripts in order for this to work. Unfortunately, clients who sign up to template providers who disallow access to their support forums ...; Created on 20 August 2012
32. Select unique values in Microsoft Excel column: / Excel /; Thought I'd put a quick note here, I tried a fair few solutions that didn't work and then found this hidden away in a forum: Quick Count =INT(SUMPRODUCT((A3:A1000"")/COUNTIF(A3:A1000,A3:A1000&""))) ...; Created on 03 July 2012
33. Getting the mysql where in delimited string to work: / MySQL /; ... this work is not mine and comes from a clever function by Chris Stubben in the MySQL Forums: BEGIN DECLARE i INT DEFAULT 0; -- total number of delimiters DECLARE ctr INT DEFAULT 0; -- counter for ...; Created on 02 January 2012
34. SSRS Zero Padding: / SQL Server Reporting Services /; ... "-201". As I wanted a link so that the user can just click on this link and it would take them to http://ora-00201.ora-code.com/. The Padding Found this in a forum so thought I'd better make a note: Right("00000" ...; Created on 10 November 2011
35. T-SQL Record Separator: / Transact-SQL /; I have googled, binged and asked but to no avail. Some self-proclaimed IT experts in forums said "why would you want to do that?". Unhelpful Bellends. It's a bit like asking me "Why can't I turn on my computer" ...; Created on 11 October 2011
36. Fun with DllCall in AutoHotkey: / AutoHotkey /; ... then this is for you. DllCall will usually run contained in the program and can be hidden from the end-user. The one to rule them all: This is a function I pulled from the Autohotkey forums submitted ...; Created on 27 September 2011
37. Functions to convert Hex 2 RGB and vice-versa: / AutoHotkey /; These are for autohotkey and in AHK code. Taken from Autohotkey forums topic 1878: From Hexadecimal to RGB From RGB to Hexadecimal Check for a valid hexadecimal value From Hexadecimal ...; Created on 27 September 2011
38. Format Numbers in AutoHotkey with Commas: / AutoHotkey /; ... break } } Return Result } Use as per usual: ValueWithCommas:=FormatAddCommas(NumberWithoutCommas) One taken from the AutoHotkey forums: AddCommas(val) { ...; Created on 20 September 2011
39. SSRS External Images don't displa: / SQL Server Reporting Services /; ... User Account" can see the photos. - This solved the problem for us Some forums suggested to put this user also in the "Browser" roles of the Reporting Manager Problem #2: Alternative image if file ...; Created on 19 September 2011
40. Oracle SQL - Convert given list (CSV) into Rows: / Oracle PL/SQL /; Just a quick note as to something that worked for me. Taken from the Oracle forums @ https://forums.oracle.com/forums/thread.jspa?messageID=6861756 Situation I have one column of values that I've ...; Created on 30 August 2011