Improve Default Joomla Search http://mail.joellipman.com/articles/cms/joomla/improve-default-joomla-search-heuristics.html

07 May 2013 CASE order statement: switch ($ordering) { // BEGIN: joes new ordering option case 'relevance': $order = 'relevance DESC'; break; // END: joes new ordering option case 'oldest': $order = 'a.created ASC'; break; case 'popular': $order = 'a.hits DESC';...

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

CSS Printing - Page Break Inside with Headers and Footershttp://mail.joellipman.com/articles/web-development/css/css-printing-page-break-inside-with-headers-and-footers.html

22 February 2019 articles that would cover this but I wanted an example which includes headers and footers and how to get an automatic page-break-inside to not overlap these. Fine on screen but this is obviously for when it comes to printing. Why? I needed to create a...

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

Forum Ruleshttp://mail.joellipman.com/static-items/forum-rules.html

31 May 2009 Breaking rules result in punishments. There are several types of punishments: Warning - This is where a public announcement is made that mentions your name and that you have broken a rule. I will determine whether you knew what you were doing was wrong...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

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

05 July 2011 A_Index-1 "]" ) If ( COM_Invoke( pwb, "LocationName" ) = name && InStr( COM_Invoke( pwb, "FullName" ), "iexplore.exe" ) ) Break COM_Release( pwb ), pwb := "" } COM_Release( oShell ) Return, pwb } How to know when the webpage in done loading? - Sean's...

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

Zoho Deluge - First Monday of Month or Last Tuesday of Monthhttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-first-monday-of-month-or-last-tuesday-of-month.html

27 September 2019 v_NextMonthMonday = v_NextMonthDateFirst.addDay(v_MyDay); if(v_NextMonthMonday.getDayOfWeek()==2) { break; } } input.Next_Switch_Date = v_NextMonthMonday.toDate(); } } else if(input.Switch_Over_Day=="Last Tuesday of Month") { v_NextMonthDate =...

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

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

25 January 2010 the cursor id SystemCursor = 1 If ( CursorName = Cursor ) { CursorHandle := DllCall( "LoadCursor", Uint,0, Int,CursorID ) Break } } If CursorHandle = ; invalid cursor name given { Msgbox,, SetCursor, Error: Invalid cursor name CursorHandle = Error } }...

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

ZohoCRM: Import Attachmentshttp://mail.joellipman.com/articles/crm/zoho/zohocrm-import-attachments.html

16 January 2023 v_ForeignKey := StrReplace(a_ColumnValues[1], """", "") v_FKCount := v_FKCount + 1 SB_SetText("Foreign Row #" v_FKCount, 2) break } } ; find the Zoho key v_ZohoKey := "-" v_PKCount := 0 GuiControlGet, SearchIntFile,, MyInternalFile Loop, Read,...

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

ZohoRecruit: Create Linking Table for Candidates and Associated Job Openingshttp://mail.joellipman.com/articles/crm/zoho/zohorecruit-create-linking-table-for-candidates-and-associated-job-openings.html

08 February 2023 { for each r_Check in l_CheckExists.get("data") { if(!isnull(r_Check.get("id"))) { v_CountExists = v_CountExists + 1; break; } } } if(v_CountExists == 0) { // // prevent duplicates by updating record with existing name if exists v_Name =...

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

Zoho Cliq: Integrate OpenAI and ChatGPT 3.5 Turbohttp://mail.joellipman.com/articles/crm/zoho/zoho-cliq-integrate-openai-and-chatgpt-3-5-turbo.html

13 February 2023 { // // add the answer text to the response map m_Response.put("text",m_Choice.get("message").get("content")); break; } } } } else { // store in response text m_Response.put("text","I don't know. Consider doing a Google search."); } } // // output...

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

ZohoBooks: Error Code 15: Ensure Billing Address has less than 100 charactershttp://mail.joellipman.com/articles/crm/zoho/zohobooks-code-15-ensure-billing-address-has-less-than-100-characters.html

18 September 2023 { if(!isnull(r_Result.get("contact_id"))) { v_BooksCustomerID = r_Result.get("contact_id").toLong(); break; } } } } if(v_BooksCustomerID != 0) { m_CreateEstimate.put("customer_id",v_BooksCustomerID); } // // ---------------------- QUOTE CONTACT...

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

Zoho People: Get Performance Records over APIhttp://mail.joellipman.com/articles/crm/zoho/zoho-people-get-performance-records-over-api.html

18 September 2025 } m_OutputAll.put(v_GoalKey, m_OutputRecord); } } // // for testing I'm doing 3 records at a time if(v_CountTotal > 3) { break; } } info m_OutputAll; return ""; This should give you all the fields that will be pulled from "Goals" and some records with...

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

Zoho Survey & Zoho Analytics: Query to generate individual responses and grouped pageshttp://mail.joellipman.com/articles/crm/zoho/zoho-survey-zoho-analytics-query-to-generate-individual-responses-and-grouped-pages.html

25 September 2025 { if(m_ReportImage.get("File_Name__s").startsWith(v_SurveyName)) { v_PreviewID = m_ReportImage.get("Preview_Id__s"); break; } } } } // // build up URL if(v_PreviewID != "") { v_ImageURL = v_ZohoApisDomain + "/crm/v8/__attachment_preview/" + v_PreviewID;...

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

Pancakeshttp://mail.joellipman.com/articles/_other-misc/pancakes.html

07 July 2009 mixing bowl with a sieve held high above the bowl so the flour gets a airing. Now make a well in the centre of the flour and break the eggs into it. Then begin whisking the eggs - any sort of whisk or even a fork will do - incorporating any bits of...

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

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

18 May 2010 v0.4.3 (Returned different results from my IE7 tests) ie6olas_nt (from http://browsers.evolt.org - works but installing IE8 breaks it) ie6setup.exe (from Microsoft's website advising on Run > c:\\download\\ie6setup.exe /c:"ie6wzd.exe /d:1 /s:""#E") If...

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

Room with a view E.M. Forsterhttp://mail.joellipman.com/articles/_other-misc/room-with-a-view-em-forster.html

04 February 2011 Taking a break from website migrations. Thought I'd share some thoughts I was reminiscing of: "We cast a shadow on something wherever we stand, and it is no good moving from place to place to save things; because the shadow always follows. Choose a...

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

PHP & MySQL Search Enginehttp://mail.joellipman.com/articles/web-development/php/php-a-mysql-search-engine.html

09 March 2011 foreach ($levenshtein_words as $word) { $lev = levenshtein($term, $word); if ($lev == 0) { $closest = $word; $shortest = 0; break 1; } if ($lev 0)?"Did you mean: ".$didyoumean_string_joined."?":""; $didyoumean_words_array=array(); // Note: for some...

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

Win32 Constantshttp://mail.joellipman.com/articles/automation/autohotkey/win32-constants.html

05 July 2011 Const DT_CENTER = $00000001 Const DT_RIGHT = $00000002 Const DT_VCENTER = $00000004 Const DT_BOTTOM = $00000008 Const DT_WORDBREAK = $00000010 Const DT_SINGLELINE = $00000020 Const DT_EXPANDTABS = $00000040 Const DT_TABSTOP = $00000080 Const DT_NOCLIP =...

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

SSIS Convert a string into a datehttp://mail.joellipman.com/articles/microsoft/ssis/ssis-convert-a-string-into-a-date.html

14 March 2013 ? (DT_DATE)"1900-01-01" : (DT_DATE)This_Date -- last column when datasource is flat file (account for line break): ISNULL(Last_Column) ? "" : TRIM(Last_Column) Last Troubleshooting Check: The problems here relate to when our datasource was a flat file...

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

Include a carriage return in a column headinghttp://mail.joellipman.com/articles/microsoft/sql-server/include-a-carriage-return-in-a-column-heading.html

07 July 2014 from a data source located on a database on the other side of the world. I want the header in the column "Academic Week" to break across two lines so that the column doesn't expand to the width of "Academic Week" and instead expands to the width of the...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server
• Language: *

DJI Phantom FC40 - Fun at the raceshttp://mail.joellipman.com/articles/_other-misc/quadcopters/dji-phantom-fc40-fun-at-the-races.html

17 September 2014 doubled the cost of the quadcopter and that's my mate's girlfriend. I'll use the guards next time if the wind allows. Do NOT break Line-of-Sight (LoS) for any participants Not distract the drivers or fly between them and their vehicle. Avoid flying over...

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