List all cron jobs for all usershttps://www.joellipman.com/articles/linux/list-all-cron-jobs-for-all-users.html

04 May 2011 "s/\s+/ /g" | sed --regexp-extended "s/^ //" done; } # Given a stream of cleaned crontab lines, echo any that don't include the # run-parts command, and for those that do, show each job file in the run-parts # directory as if it were scheduled...

• Type: Article
• Author: Joel Lipman
• Category: Linux
• Language: *

Joes FREE Website Thumbnailer (JWT)https://www.joellipman.com/component/content/article/joes-free-website-thumbnailer.html?catid=40

28 June 2011 no colons, back/forward slashes, etc). If there is nothing specified, it will name it something like "000065.bmp". Do not include the file extension (and the dot/period) as this is set in the program options (specifying output thumbnail file type). For...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

Win32 Constantshttps://www.joellipman.com/articles/automation/autohotkey/win32-constants.html

05 July 2011 Const SHCONTF_FOLDERS = 32 ;// For shell browser Const SHCONTF_NONFOLDERS = 64 ;// For Default view Const SHCONTF_INCLUDEHIDDEN = 128 ;// For hidden/system objects ;#end region ;#region ShellGetDisplayNameOfFlags Const SHGDN_NORMALConst = 0 ;// Default...

• Type: Article
• Author: Joel Lipman
• Category: AutoHotkey
• Language: *

SSRS Querying on either of 2 Parametershttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-querying-on-either-of-2-parameters.html

19 July 2011 ("@StudentReference") to populate itself if it is left blank when the report is executed. So my first dataset has to include the Username check as well (…WHERE StudentID=@StudentReference OR StudentName=@StudentADAccount). And according to other web...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

MySQL parameters in Excel 2007 PivotTableshttps://www.joellipman.com/articles/database/mysql/mysql-parameters-in-excel-2007-pivottables.html

24 August 2011 grouping/drilldown pivot tables. Have managed to get this working with SQL Server, Oracle and MySQL databases... Now how to include parameters in non Microsoft technology. Limitations of Excel 2007 PivotTables Aesthetics: Drilldown bolded items are NOT...

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• Language: en-GB

SSRS Dropdown parameter cannot be blank!https://www.joellipman.com/articles/microsoft/ssrs/ssrs-dropdown-to-allow-blank-values.html

14 December 2011 then the alert message "parameter cannot be blank!" and less confusing to the end-user. If this bugs you, you can always include a custom message which displays on top if all 4 parameters are equal to ""; such as the instructions on selecting a dropdown...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

DataJumble - Shuffling characters in a data valuehttps://www.joellipman.com/articles/database/t-sql/data-shuffling-function.html

01 August 2012 2 - LEN(@RandDay))); END -- DETERMINE TIME VALUE IF TIME WAS IN GIVEN VALUE IF @TimeMatch=1 BEGIN -- SET RANDOM TIME VALUE (include Milliseconds) SELECT @RandHour = (0 - 23) * RandomValue + 23 FROM dbo.vwRandom; SELECT @RandMinute = (0 - 59) *...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: *

DataScramble - Randomizing data rowshttps://www.joellipman.com/articles/database/t-sql/datascramble-randomizing-data-rows.html

07 December 2012 2 - LEN(@RandDay))); END -- DETERMINE TIME VALUE IF TIME WAS IN GIVEN VALUE IF @TimeMatch=1 BEGIN -- SET RANDOM TIME VALUE (include Milliseconds) SELECT @RandHour = (0 - 23) * RandomValue + 23 FROM dbo.vwRandom; SELECT @RandMinute = (0 - 59) *...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: en-GB

Proposed Budget i3 PC under £200https://www.joellipman.com/hardware/proposed-budget-i3-pc-under-200.html

26 January 2013 Bulk DVDRW Internal DVD Drive £12.49 (exc. VAT) £14.99 (inc. VAT) Total £122.44 (exc. VAT) £146.93 (inc. VAT) Prices do not include the Operating System (in this case Microsoft Windows 7 Pro 32-bit) nor the chassis as we merely transferred the license...

• Type: Article
• Author: Joel Lipman
• Category: IT Support
• Language: *

CharIndex Reverse - find occurrence starting from end of string in TSQLhttps://www.joellipman.com/articles/database/t-sql/charindex-reverse-find-occurrence-starting-from-end-of-string-in-tsql.html

28 January 2013 "3.String4" Almost there, counting backwards and forwards it seems the index is just two characters off (as I don't want to include the period): SELECT LEN(@Haystack) - CHARINDEX(@Delimiter, REVERSE(@Haystack)) + 2 -- yields "25" SELECT...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: en-GB

XML Schema Referencehttps://www.joellipman.com/articles/web-development/xml/xml-schema-reference.html

13 August 2014 elements to be used in complex type definitions import Adds multiple schemas with different target namespace to a document include Adds multiple schemas with the same target namespace to a document key Specifies an attribute or element value as a key...

• Type: Article
• Author: Joel Lipman
• Category: Extensible Markup Language
• Language: en-GB

Android OS: Add GoogleMap as fragmenthttps://www.joellipman.com/articles/google/androidos/android-os-add-googlemap-as-fragment.html

25 November 2014 article suggests how to add Map as a sub activity. Note that this article is based on a new blank project which does not include code from the previous example but you can still build this over the previous example (as I did). Why? The previous article...

• Type: Article
• Author: Joel Lipman
• Category: AndroidOS
• Language: *

Copy a Wordpress Site for Developmenthttps://www.joellipman.com/articles/cms/wordpress/copy-a-wordpress-site-for-development.html

08 March 2015 www.myexample.com to dev1.myexample.com Search and replace any other occurrences in the `wp_options` database table (note: include `wp_postmeta` and `wp_posts` if you want images and attachments) Done Sample Configuration PHP Note that the following are...

• Type: Article
• Author: Joel Lipman
• Category: Wordpress
• Language: en-GB

Protecting your Joomla Administrator Sectionhttps://www.joellipman.com/articles/cms/joomla/protecting-your-joomla-administrator-section.html

23 October 2015 users who access the same computer (this is irrespective of whether you have logged out of the CMS). Add an IP filter To include this method, ensure you have a static IP address (most home broadband users are now assigned these by ISPs so that they can...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• Language: en-GB

Foreign Characters create symbols in PHP and MySQLhttps://www.joellipman.com/articles/web-development/php/foreign-characters-create-symbols-in-php-and-mysql.html

25 January 2016 symbols and how I solved it in my case. Why? My company has started using international country and region names which include foreign characters. When we copy and paste their content into our website, our webpages display a question mark inside a...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB

Display Feeds to major Social Networkshttps://www.joellipman.com/articles/web-development/display-feeds-to-major-social-networks.html

16 May 2016 Copy & Paste the code into your blog or website HTML. Pinterest Browse to Pinterest Developer Tools - Widget Builder Include the javascript file '//assets.pinterest.com/js/pinit.js' once in the page Customize your feed and Copy & Paste the code where...

• Type: Article
• Author: Joel Lipman
• Category: Web-Development
• Language: *

Windows Live Mail Error ID: 0x8DE00005https://www.joellipman.com/articles/microsoft/windows-os/windows-live-mail-error-id-0x8de00005.html

14 December 2016 account. The problem has something to do with DeltaSync no longer being supported. Deactivate the account by deselecting "include this account when receiving mail or synchronising" in the account properties dialog. Add an account by selecting 'Accounts'...

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: en-GB

Google Authentication - OAuth 2.0 using PHP/cURLhttps://www.joellipman.com/articles/google/google-authentication-oauth-2-0-using-php-curl.html

31 October 2018 && !file_exists($STORE_PATH)) $credentials = storeCredentials($STORE_PATH, $credentials); return $credentials; } Include the following at the end of all of this and to execute the functions but before any outputs (HTML or JS): $credentials =...

• Type: Article
• Author: Joel Lipman
• Category: Google
• Language: en-GB

CSS Ordered List 1, 1.1...1.10 Formatting and Alignmenthttps://www.joellipman.com/articles/web-development/css/css-ordered-list-1-1-1-1-10-formatting-and-alignment.html

10 July 2019 list that indents and aligns correctly. Why? I'm finding that I need to do this quite often for some clients who want to include their terms and conditions in quote/invoice templates and want the HTML to be indented neatly. Other examples out there will...

• Type: Article
• Author: Joel Lipman
• Category: Cascading Stylesheets
• Language: en-GB

Zoho Deluge - Get Refresh/Access Token API v2https://www.joellipman.com/articles/crm/zoho/zoho-deluge-get-refresh-access-token.html

17 July 2019 // for China servers v_Endpoint = "https://www.zohoapis.com.cn/crm/v2/"; // for China servers Scope(s) to include ALL modules: Books: ZohoBooks.fullaccess.all CRM: ZohoCRM.modules.ALL,ZohoCRM.settings.ALL Zoho Books API v3 Limits 2019: Free Organization...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: en-GB