SQL Queries for Statisticshttps://www.joellipman.com/articles/database/mysql/sql-queries-for-statistics.html

13 December 2010 1, 0)) Student, SUM(IF(t2.VisitorType='Anonymous', 1, 0)) Guests FROM ( SELECT b.user_name User, CASE WHEN INSTR(b.user_name, '@staff') THEN 'Staff' WHEN INSTR(b.user_name, '@bournemouth') THEN 'Student' WHEN t1.ID=0 THEN 'Anonymous' END VisitorType,...

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

Returned a data type that is not validhttps://www.joellipman.com/articles/database/t-sql/returned-a-data-type-that-is-not-valid.html

06 January 2011 1, 0)) 'Other', COUNT(t1.VisitorBrowser) 'Total' FROM (SELECT a.DateTimeStamp Date, CASE WHEN INSTR(a.VisitorUAgent, 'MSIE ') THEN 'MSIE' WHEN INSTR(a.VisitorUAgent, 'Firefox') THEN 'Firefox' WHEN INSTR(a.VisitorUAgent, 'Safari') THEN 'Safari' WHEN...

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

Add Image Mouseover effect in AutoHotkey GUIhttps://www.joellipman.com/articles/automation/autohotkey/add-image-mouseover-effect-in-autohotkey-gui.html

25 January 2010 SearchButton_Out:=A_ScriptDir "\images\program\icons\search_globe.png" If (CurrControl PrevControl and not InStr(CurrControl, " ")) { ToolTip ; Turn off any previous tooltip. SetTimer, DisplayToolTip, 1000 If (PrevControl="SearchButton") GuiControl,,...

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

AutoHotkey Format Date and Format Secondshttps://www.joellipman.com/articles/automation/autohotkey/autohotkey-format-date-and-format-seconds.html

20 September 2011 is to convert a given SQL date or a European date formatted value: FormatDate(val) { ; SQL format (yyyy-mm-dd HH:mm:ss) IfInString, val, - { StringReplace, val, val, -,,All StringReplace, val, val, :,,All StringReplace, val, val, %A_Space%,,All } ;...

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

Parse a HTML Table into a ListViewhttps://www.joellipman.com/articles/web-development/html/parse-a-html-table-into-a-listview.html

30 March 2013 is a marker for a value located after Needle1a Needle2a := " " ; Needle2a is the closing marker ; get table HTML Needle1 := InStr( Haystack, Needle1a, false, NeedleMarker ) Needle1 := InStr( Haystack, Needle1b, false, Needle1 ) + StrLen( Needle1b )...

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

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 migration of a Joomla! CMS running version 2.5.11 to an instance of Joomla! CMS version 3.4.1. I would consider the below instructions an ALPHA version as it is considered unstable for official use... Saying that this is how I upgraded my own personal...

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

ZohoCRM: Import Attachmentshttps://www.joellipman.com/articles/crm/zoho/zohocrm-import-attachments.html

16 January 2023 Text, vHeading x10 y10 w400, %v_SubTitle% Gui, Font, s7 w400 c999999, Verdana Gui, Menu, MainMenu Gui, Add, Text, vAttachmentInstruction1 x12 y35 w400, Select the file which contains the foreign key and the file name(s) Gui, Add, Text,...

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

Basic Webpage Controls with JavaScript / COMhttps://www.joellipman.com/articles/automation/autohotkey/basic-webpage-controls-with-javascript-com.html

05 July 2011 Internet Explorer" ) For pwb in ComObjCreate( "Shell.Application" ).Windows If ( pwb.LocationName = Name ) && InStr( pwb.FullName, "iexplore.exe" ) Return pwb } Code: ; AHK Basic: IEGet( name="" ) { IfEqual, Name,, WinGetTitle, Name, ahk_class IEFrame ;...

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

Autohotkey - Chrome Profiles in Alphabetical Orderhttps://www.joellipman.com/articles/automation/autohotkey/autohotkey-chrome-profiles-in-alphabetical-order.html

07 January 2020 "\Preferences" ; Get the preferences file from the profile FileRead, OutputContent, %PreferenceFile% NameStart := InStr(OutputContent, """name"":""")+8 NameEnd := InStr(OutputContent, """", false, NameStart+1) NameLength := NameEnd - NameStart...

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

AutoHotkey: App GUI Listview to Rename Fileshttps://www.joellipman.com/articles/automation/autohotkey/autohotkey-app-gui-listview-to-rename-files.html

08 July 2020 ".") ; remove converter comments from file name v_NewName := "" Loop % a_ThisFileName.MaxIndex() { v_FoundUnderScore := InStr( a_ThisFileName[A_Index], "_") if( a_ThisFileName[A_Index] != "EDIT" && v_FoundUnderScore...

• Type: Article
• Author: Joel Lipman
• Category: AutoHotkey
• 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 ELSIF p_original_datatype='FLOAT' THEN -- Determined submitted value as 'FLOAT'; v_char_at := (INSTR(p_original_value, '.')-1); v_rand_param1 := POWER(10, (LENGTH(p_original_value) - v_char_at)); -- should yield eg. 10 v_rand_param2 := POWER(10,...

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

AutoHotkey: Check Windows Folder Sizeshttps://www.joellipman.com/articles/automation/autohotkey/autohotkey-check-windows-folder-sizes.html

28 January 2019 ; function to loop through files/subfolders and total the file sizes GetFileFolderSize(fPath="") { FolderSize := 0 if InStr(FileExist(fPath), "D") { Loop, %fPath%\*.*, 1, 1 FolderSize += %A_LoopFileSize% Size := % FolderSize ? FolderSize : 0 Return,...

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

AutoHotkey: Get Media Information and Displayhttps://www.joellipman.com/articles/automation/autohotkey/autohotkey-get-media-information-and-display.html

07 August 2020 kind { Return } i:=0, nParams:=p.Count(), fex.SetCapacity(nParams + 11) While ( i++...

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

Regular Expressions in SQLhttps://www.joellipman.com/articles/database/regular-expressions-in-sql.html

09 January 2014 will NOT be returned -- Other REGEXP Functions for Oracle: -- -- REGEXP_REPLACE(country_name, '(.)', '\1 ') -- -- REGEXP_INSTR(email, '\w+@\w+(\.\w+)+') > 0 -- -- REGEXP_SUBSTR('oracle', 'o r a c l e', 1, 1, 'x') Microsoft T-SQL Note the circumflex/hat...

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