Mouseover Links in AutoHotkeyhttp://mail.joellipman.com/articles/automation/autohotkey/mouseover-links-in-autohotkey.html

08 July 2011 sometimes leave the link as blue despite the mouse cursor not being anywhere near it. Proper HTML mouseovers: When I have a more stable solution. I would however recommend cwebpage.dll at as a minimum for internal HTML pages for use in an AutoHotkey GUI.

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

MySQL Group_concat equivalent in T-SQL and Oraclehttp://mail.joellipman.com/articles/database/mysql-groupconcat-equivalent-in-t-sql-and-oracle.html

28 November 2011 1 Me,Myself,I Note that the following queries include the nested version because I find myself needing to group concatenate more often from another table then using data from the same table. MySQL SELECT ( SELECT GROUP_CONCAT(column_to_return_as_string)...

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

MySQL day of week ending on Fridayhttp://mail.joellipman.com/articles/database/mysql/mysql-day-of-week-ending-on-friday.html

26 April 2012 Week Ending Date has been requested a lot more frequently now. It's an odd one but the example below shows how to do this for when the week ends on Friday. Assuming it starts on the previous Saturday. Why? Problems with MySQL weeks always starting on...

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

Select unique values in Microsoft Excel columnhttp://mail.joellipman.com/articles/microsoft/excel/select-distinct-values-in-microsoft-excel-column.html

03 July 2012 to do this to. Click on the "Data" tab. Click on "Advanced" (Advanced Filter). Tick the "Unique records only" box. A few more from Microsoft Office Help /* Count the number of unique number values in cells A2:A10, but do not count blank cells or text...

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

Drop If Object Existshttp://mail.joellipman.com/articles/database/t-sql/drop-if-object-exists.html

03 August 2012 page. Go go go Note that in the following examples, I'm checking under the [Common] schema, this might be [dbo] for you or a more specific one. -- drop a stored procedure if it exists IF OBJECT_ID ( '[Common].[usp_MyStoredProcedure]', 'P' ) IS NOT NULL...

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

Ordered List of over 1000 Itemshttp://mail.joellipman.com/articles/web-development/css/ordered-list-of-over-1000-items.html

08 February 2013 What? So many people asking this when the solution is a bit of aesthetic styling. ol{margin:4px} -- yields 995. 996. 997. 998. 999. 000. 1000 Ordered list resets to zero after the ninth item Ordered List Maximum

• Type: Article
• Author: Joel Lipman
• Category: Cascading Stylesheets
• Language: *

Leap Motion and AR Dronehttp://mail.joellipman.com/articles/_other-misc/quadcopters/leap-motion-and-ar-drone.html

17 May 2013 videos were shown to me by a colleague at work. I was so impressed I just had to post them. So here's a screenshot, read more if you want the videos: So Leap in Motion AR Drone: {youtube}ZOdxlrQj_ZU{/youtube} Just as amazing but old news:...

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

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

27 March 2014 '.strtoupper($author_names[1][0]).'.'; } } // output echo $author_name_disp; And a little more: // default $author_name_disp=$author_name; // check and transform foreach(array(' ', '.') as $delimiter) { if (strpos($author_name, $delimiter)!==false) {...

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

Two icons created on Androidhttp://mail.joellipman.com/articles/google/androidos/two-icons-created-on-android.html

20 October 2014 until I found it on the a forum: Stack Overflow: Android App Development. How? Basically don't have the following declared more than once in the AndroidManifest.xml

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

SELECT COUNT(DISTINCT name) FROM tablehttp://mail.joellipman.com/articles/cms/joomla/select-count-distinct-name-from-table.html

24 September 2015 FROM (SELECT DISTINCT my_field FROM my_table) T1; Ones that didn't work for me: Method #3: By grouping (NOT recommended for more complex queries): SELECT COUNT(my_field) FROM my_table GROUP BY my_field; Additional: Not sure why method 3 is an accepted...

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

Zoho Deluge - Get User Timezone, Country and Locationhttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-get-user-timezone-country-and-location.html

03 June 2019 "Europe", "countryCode": "GB", "countryName": "United Kingdom", "stateProv": "England", "city": "Birmingham (Edgbaston)" } A more comprehensive alternative [Limit 150 per minute | not for commercial use]: v_Url = "http://ip-api.com/json/"+...

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

COVID-19: Working from Homehttp://mail.joellipman.com/covid-19-work-from-home.html

05 July 2020 over the coffee table, my back is suffering terribly. I figured on a personal DSE assessment and setup my workstation as a more permanent solution. For fun, our office have posted what taking your work home, including the work computer, looks like... I...

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