Search - Joel Lipman .Com

21. Windows 10: Shortcut Apps to Settings: / Windows OS /; ... Light Settings ms-settings:nightlight Phone ms-settings:phone-defaultapps Projecting to this PC ms-settings:project Shared Experiences ms-settings:crossdevice Tablet Mode ms-settings:tabletmode ...; Created on 30 July 2020
22. Zoho Deluge - Compare time and currenttime with timezone: / Zoho /; ... switch the current time to Europe/London (You can use an abbreviation such as GMT but this doesn't seem to check if daylight savings is in effect): Example of taking a CRM date-time value (expiryTime) ...; Created on 13 January 2020
23. Excel - Check a column for values found in another column: / Excel /; ... purposes, I'm using a new Excel file with two worksheets called "Sheet1" and "Sheet2" respectively. Sheet1 contains the following: A B --------------- --------------- seize spell fence total thank fight noise terms thigh tasty light swarm shelf allow unity press board wreck shake decay Sheet2 ...; Created on 14 February 2019
24. Google Drive API v3 - OAuth2 using Service Account in PHP/JWT: / Google /; ... logic and highlight any changes you may need to make. 1. First: the variables are in arrays Well mostly. Simply because we'll be working with JSON data and this encodes/decodes easily into PHP ...; Created on 02 February 2019
25. Sort an associative array by values in Javascript: / JavaScript /; What? An article on how to quickly adapt an array code and sort by its values. Surprising how many examples are on the web and everyone saying you're doing it wrong... Which is true but quite unhelpful. ...; Created on 29 September 2015
26. List of Font Awesome: / Web-Development /; ... 4.1  fa-life-saver (alias) []  fa-lightbulb-o [] 4.2  fa-line-chart ...; Created on 04 September 2015
27. T-SQL functions to convert Strings to Tables: / Transact-SQL /; ... VALUES ( @StringValue ) END RETURN END Now we want to modify this slightly so that it converts a string of words delimited by pipes to a table: CREATE FUNCTION dbo.[ufn_PipeStringToTable] ( ...; Created on 20 August 2014
28. Add attribute xsl:nil=true on empty elements using XSLT: / XML Stylesheet Language Transformations /; ... our XSLT with some slight modifications. First let's look at the XML output from SITS (this is a cut down version for demonstration purposes): 1234567 JOEL LIPMAN Two ...; Created on 18 August 2014
29. 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
30. AHK Countdown Tooltip: / AutoHotkey /; ... would get change." Joke6:="The gates are down, the lights are flashing, but the train ain't coming." Joke7:="This employee is depriving a village somewhere of an idiot." Joke8:="Th ...; Created on 17 July 2014
31. Joomla Component: Set default params on installation: / Joomla /; ... access to this file defined('_JEXEC') or die; // com_XXX is your component name class com_XXXInstallerScript { function postflight($type, $parent) { // $type (install, ...; Created on 24 October 2013
32. SSIS Script: convert UPPERCASE to Mixed-Case using TitleCase: / SQL Server Integration Services /; ... you can add project output to it. Exclude all dependencies by highlighting all of the files under the Detected Dependencies folder and selecting "Exclude". If you'd like to add a readme.rtf file, place ...; Created on 04 October 2013
33. Joes Syntax Styler (JSS): / Product Documentation /; Before you ask, I tried Google Prettify and Alex Gorbatchev's Syntax Highlighter but both were causing problems for the sites I wanted to use it on. Mainly because of JavaScript frameworks (like jQuery ...; Created on 06 April 2013
34. Adding a selectable background to a Yootheme template: / Joomla /; ... Squares Light Squares Mosaic Turquoise Color Ambient Turquoise Add a \templates\\css\background\ambientturquoise.css file. Note the same filename as in the option value of the previous ...; Created on 19 November 2012
35. Returning Oracle Stored Procedure Resultset in SSRS: / SQL Server Reporting Services /; ... dataset Follow these steps carefully. I've added some screenshot images to help and highlighted areas which you should ensure are correct (or which applies to your report) 4a. Add a dataset: query ...; Created on 19 January 2012
36. Basic Oracle Stored Procedure Structure: / Oracle PL/SQL /; ... SSRS. What? I asked someone for a simple, easy and basic Oracle stored procedure as my MySQL and T-SQL stored procedures work slightly differently and are easier to pull off. After much umming ...; Created on 16 January 2012
37. Alternative method of displaying Unicode in Autohotkey GUI: / AutoHotkey /; ... mark 176 B0 U+2591 ░ light shade 177 B1 U+2592 ▒ medium shade 178 B2 U+2593 ▓ dark shade 179 B3 U+2502 │ box drawings light vertical 180 B4 U+2524 ┤ box drawings light vertical and left 181 B5 U+2561 ╡ box ...; Created on 29 September 2011
38. Joes Bug Tracker (JBT): / Product Documentation /; ... add rel for lightboxes - include captions?) --- Restrict to Registered/Special/Joomla! user (allows for dev versions not released to public - overrides category restriction) --- Display/Access based ...; Created on 07 July 2011
39. Win32 Constants: / AutoHotkey /; ... TB_ISBUTTONINDETERMINATE= (WM_USER + 13) Const TB_ISBUTTONHIGHLIGHTED = (WM_USER + 14) Const TB_SETSTATE = (WM_USER + 17) Const TB_GETSTATE = (WM_USER + 18) Const TB_ADDBITMAP ...; Created on 05 July 2011
40. Joes Quicklist Weblinks (JQW): / Product Documentation /; ... on my personal website because I am using a RocketTheme template but this should work if you have RocketTheme's RokBox Extension installed. It simply opens an external link in a "lightbox" which is a prett ...; Created on 03 July 2011