Assuming 1 is required, the following 337 results were found.
-
Update June 2013 - How to use this migration script: Make a backup copy of your old Joomla website (1.5.x) Download and install the latest Joomla CMS Go through the Joomla Web-based Installation GUI until the process deletes the Installation folder....
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
A quick article on how to get the value of 40°4′20″N 116°35′51″E into 40.079857, 116.603112. How? Let's pretend all the names are in column A, in Column B I have the coordinates that I want to convert: A B -------------------------------------...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
data very difficult to work with: Before: StudentID StudentName DateOfBirth ----------- -------------------- ------------- 1 John Smith 1990-03-21 2 Fred Bloggs 1988-11-02 3 Another User 1985-07-11 4 Yet Another User 1977-06-25 After: StudentID...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
This is a quick article on how I built my 2022 workstation and got 5 monitors working with only 1 graphics card. Why? This took me a good few hours to get working so I thought this article could help others. It's also a chance to show off my build....
- Type: Article
- Author: Joel Lipman
- Category: Articles
- Language: *
-
the performance and database load. Before: StudentID StudentName DateOfBirth ----------- -------------------- ------------- 1 John Smith 1990-03-21 2 Fred Bloggs 1988-11-02 3 Another User 1985-07-11 4 Yet Another User 1977-06-25 After: StudentID...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
is what I don't want to lose. ;// ;// Win32 Constants ;// ;#region Peek Message Flags Const PM_NOREMOVE = 0 Const PM_REMOVE = 1 Const PM_NOYIELD = 2 ;#End Region ;#Region Windows Messages Const WM_NULL = $0000 Const WM_CREATE = $0001 Const WM_DESTROY =...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
table to identify a user. SELECT CONCAT(MONTHNAME(t2.Date), ' ', YEAR(t2.Date)) Month, SUM(IF(t2.VisitorType='Staff', 1, 0)) Staff, SUM(IF(t2.VisitorType='Student', 1, 0)) Student, SUM(IF(t2.VisitorType='Anonymous', 1, 0)) Guests FROM ( SELECT...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
Search Gui, Add, Picture, x573 y40 w93 h96 vSearchButton gSearch, %A_ScriptDir%\search_globe.jpg Gui, Add, Edit, x45 y40 w520 r1 vSearchTextInput Limit70, Search... Gui, Show OnMessage(0x200, "WM_MOUSEMOVE") Return ; FUNCTION TO HANDLE BOTH TOOLTIP AND...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
"joes_weekstructure"): ID AcademicSet WeekNumber StartDate --------- ----------------- --------------- ------------------ 417 2012/2013 1 2012-07-16 418 2012/2013 2 2012-07-23 419 2012/2013 3 2012-07-30... 467 2012/2013 51 2013-07-01 468 2012/2013 52...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
compile the code into an executable, and schedule it as a windows task for when you are logged in: ; ; AutoHotkey Version: 1.0.47.06 ; Language: English ; Platform: Win9x/XP ; Author: Joel Lipman ; Date Created: 15-July-2014 ; ; Script Function: ; Just...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
(as opposed to "File Name" which is the file name as it is to be displayed in ZohoCRM). For example "5a4bed37590588baa5fc272219e8e553_image001.jpg" for Attachment ID and just "image001.jpg" for File Name. Attachment Owner Id: This is a "zcrm_" prefixed...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
but SQL*Plus has a nifty separator record activated similarly to the following: SET RECSEP WRAPPED SET RECSEPCHAR "-" Stage #1: Duplicate the table and create a separator marker Granted this will slow the query down a touch and only adds a check column...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
poi."Item Name" AS "PO Item Name", poi."Item Price (BCY)" AS "PO Item Price", poi."FCY Tax Amount" / if(poi."Quantity" = 0, 1, poi."Quantity") AS "PO Item Tax", poi."Quantity" AS "PO Qty", poi."FCY Tax Amount" AS "PO Line Tax", if_null(pshipping."PO...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- Language: *
-
it stores these in a row. How? Assuming the following data exists in the column "Event_XML" value of the table "XML_EVENTS": 123456 Mr J JOEL LIPMAN MALE 1990-01-01 SUPER SUPPORT TEAM GENERAL DOGSBODY 2014-03-01 Y INSERT 2014-03-27 Extracting the...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
indented neatly. Other examples out there will work, but I found that once the list count increased the number of digits (eg. 1.10) the text would be more indented (relative) to 1.1. I need all list elements to be all perfectly aligned. // What I Have...
- Type: Article
- Author: Joel Lipman
- Category: Cascading Stylesheets
- Language: en-GB
-
This is an article to document the 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...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
Typographyhttps://www.joellipman.com/articles/else/e-commerce/woocommerce/typography.html
H1 Heading example A wonderful serenity has taken possession of my entire soul, like these sweet mornings of spring which I enjoy with my whole heart. I am alone, and feel the charm of existence in this spot, which was created for the bliss of souls...
- Type: Article
- Category: Uncategorised
- Language: *
-
get today's date, then use the .addDay(), check none of these are a Sunday, and move the next few days along: thisDate = '2021-10-30'; v_Today = thisDate; v_Tomorrow = v_Today.addDay(1); v_NextDay = v_Today.addDay(2); if(v_Today.getDayOfWeek()==1) {...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
DECLARE @GivenDate datetime, @GivenCampus varchar(100), @setId varchar(10), @weekNumber int, @siteId nvarchar(5), @baseDate datetime, @specifiedDate datetime, @specifiedCampus varchar(25) SET DATEFORMAT dmy --SET @GivenDate = '1/7/2011' --SET...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
%A_Space%,,All } ; Standard European format (dd/mm/yyyy HH:mm:ss) IfInString, val, / { ThisTime:=SubStr(val, InStr(val, " ")+1) StringReplace, ThisTime, ThisTime, :,,A ThisTime=%ThisTime% ThisDate:=SubStr(val, 1, InStr(val, " ")) ThisDate=%ThisDate%...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB