PHP: First name and Initial of Surnamehttps://www.joellipman.com/articles/web-development/php/php-first-name-and-initial-of-surname.html

27 March 2014 Fred B. How? So different ways, the first thing I did was to create the logic: // default $author_name_disp=$author_name; // check and transform if(strpos($author_name, ' ')!==false){ $author_names=explode(' ', $author_name);...

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

Running Internet Explorer 6, 7, 8 as standaloneshttps://www.joellipman.com/articles/microsoft/windows-os/running-internet-explorer-6-7-8-as-standalones.html

18 May 2010 return a few errors but for basic browsing it will navigate to other pages and it will identify itself as IE7 to sites that check your browser details (see below - Additional Info) The Free Virtual PC solution (Requires ISO or WinXP disk) Go to...

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: *

Joe's CSV Chart Generator (JCG)https://www.joellipman.com/component/content/article/joellipmans-csv-chart-generator.html?catid=40

26 May 2010 are offered freely and in good faith. Please do not pass this off as your own work or try to sell it without due credit. Check back with us at joellipman.com for updates/fixes. If you want more support/work done to it, you could consider a donation :c)...

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

Error during processing - Converting Date/Timehttps://www.joellipman.com/articles/database/t-sql/error-during-processing-converting-datetime.html

13 July 2010 following complex T-SQL Timestamp conversions but to no avail. Not saying that you shouldn't try their solutions but just check you haven't done this silly mistake. I'm only guessing the same error would happen in Report Builder 2.0 which I've stopped...

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

MySQL: Find records in one table that are not in another.https://www.joellipman.com/articles/database/mysql/mysql-find-records-in-one-table-that-are-not-in-another.html

25 February 2011 is the dilemma. The 3 below SELECT statements were derived from a post to the Stack Overflow website about the best way to check for rows in one table which don't exist in another. -- STATEMENT2 SELECT PageID, PageTitle, PageContent FROM MyTable1 WHERE...

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

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

05 July 2011 ;#End Region ;#Region Toolbar button styles Const TBSTYLE_BUTTON = $0000 Const TBSTYLE_SEP = $0001 Const TBSTYLE_CHECK = $0002 Const TBSTYLE_GROUP = $0004 Const TBSTYLE_CHECKGROUP = (TBSTYLE_GROUP Or TBSTYLE_CHECK) Const TBSTYLE_DROPDOWN = $0008 Const...

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

Joes Network Transmission Detector (JTD)https://www.joellipman.com/component/content/article/joes-network-transmission-detector-jtd.html?catid=40

29 September 2011 for download for FREE as OpenSource. Portable so no installation/setup (can run off USB). Source files included for you to check. No signups, etc required, have fun! What's it detecting? Currently it just reads the size of packets sent and received....

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

How to Display Report Execution Time in SSRS (milliseconds)https://www.joellipman.com/articles/microsoft/ssrs/how-to-display-report-execution-time-in-ssrs.html

17 November 2011 query. Blank out the textbox basically (execution time is kinda irrelevant when you get 0 matches) We went with option 2. Check this result - Possibly from the Reporting Server ExecutionLog? Using the ReportServer Execution Logs, we can determine if...

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

Joes DNS Correction (JDC)https://www.joellipman.com/component/content/article/joes-dns-correction2.html?catid=40

25 November 2011 IDE (Business Intelligence Development Studio - BIDS) along with Microsoft's Team Foundation Server (TFS). Sometimes I'll check out an item from TFS and before I get to update it, my connection will drop and my computer will say that it could not...

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

Data Randomization Function in Oracle PL/SQLhttps://www.joellipman.com/articles/database/pl-sql/data-randomization-function-in-oracle-plsql.html

22 August 2012 : value to be returned BEGIN IF p_original_value IS NULL THEN v_returnedval := NULL; ELSIF p_original_datatype='INT' THEN -- Check Parameters and assign proper default values IF p_original_range_1 IS NULL THEN v_rand_param1 := POWER(10,...

• Type: Article
• Author: Joel Lipman
• Category: Oracle PL/SQL
• Language: en-GB

Set up Desktop SlideShow in Windows 7https://www.joellipman.com/articles/microsoft/windows-os/set-up-desktop-slideshow-in-windows-7.html

22 January 2013 Windows 7, who doesn't want it to be a slideshow as well? Create a folder in your “My Pictures” folder in your home drive (check that this is the one on the homedrive and preferably not C:\ drive). I’ve called mine “Win7_ScrSvr”. Copy a few background...

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

SSIS Skip Blank Rows in Flat File Sourcehttps://www.joellipman.com/articles/microsoft/ssis/ssis-skip-blank-rows-in-flat-file-source.html

23 April 2013 simply extract the entire row as a column and trim it. I separate out the first column as my index/key field so I can check if this is a valid data row (the blank ones may return special chars rather than Null). My example here is that the first column...

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

Call to a member function mark() on a non-object in Joomla CMShttps://www.joellipman.com/articles/cms/joomla/call-to-a-member-function-mark-on-a-non-object.html

17 November 2013 was due to an update process gone wrong. Not really the fault of Akeeba, Joomla or anyone, it's just one of those things. Check the sizes of the PHP files on your site and hope that they're not at 0 bytes. Excluding the HOME folder - only check the...

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

Joes Word Cloud (JWC) Downloadhttps://www.joellipman.com/component/content/article/joes-word-cloud-jwc-downloads.html?catid=92

07 September 2015 - Enhancement: Integration: Exclude Joomla Articles. - Date Uploaded: Sun, 12th May 2013 2.1- Enhancement: Debug Mode: Check List - Enhancement: Code Optimization - Enhancement: Integration: Include jEvents. - Date Uploaded: Wed, 8th May 2013 2.0.0-...

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

Migrating from Joomla 2.5.x to 3.4.xhttps://www.joellipman.com/articles/cms/joomla/migrating-from-joomla-2-5-x-to-3-4-x.html

12 September 2015 database and website files Note the CURRENT super user identification number "ID" and alias (name) Ensure all items are "checked-in" (Do a "Global Check In") Install new Joomla: Install Joomla! CMS v3.4.x with Demo Content (eg. 3rd-party QuickStarts):...

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

Zoho Deluge - Get English Ordinalhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-get-english-ordinal.html

08 November 2018 various methods, so here's a couple using the built-in functions of Zoho deluge. Method #1: Using a list/array, I'm going to check the date against the 3 exceptions to this rule (11th, 12th and 13th of each month): // get the date (eg. 1, 2, 3,... 29,...

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

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

17 July 2019 still get the above error, try setting the currentUserEmail to the email address of the super admin of your system just to check, then set a valid user preferably other than the super-admin....

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

Zoho Deluge - Compare time and currenttime with timezonehttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-compare-time-and-currenttime-with-timezone.html

13 January 2020 was just one hour but this caused problems if comparing two datetime values. In this particular case, we needed to check on the expiry of an access token used in OAuth2.0 for an API. How? All with deluge but we will split the date and time value...

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

Zoho Deluge: Duplicate/Clone a Recordhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-duplicate-clone-a-record.html

17 March 2020 article if you don't know how), I'm going to call mine myZohoConnector, with the scope: ZohoCRM.settings.fields.READ Then check your URL is correct. The format for API v2 is: https://www.zohoapis.{eu or com}/crm/v2/settings/fields?module={module-name}...

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

Zoho Creator: Create a Widget which uses JavaScripthttps://www.joellipman.com/articles/crm/zoho/zoho-creator-create-a-widget-which-uses-javascript.html

24 October 2020 to test the install: node –v npm –v You should get a version number for each of these as a response. Failing this you should check your security and privacy and ensure that you have permission to install the above, then re-install. Install the Zoho...

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