Alternative method of displaying Unicode in Autohotkey GUIhttps://joellipman.com/articles/automation/autohotkey/alternative-method-of-displaying-unicode-in-autohotkey-gui.html

29 September 2011 quarter 173 AD U+00A1 ¡ inverted exclamation mark 174 AE U+00AB « left-pointing double angle quotation mark 175 AF U+00BB » right-pointing double angle quotation mark 176 B0 U+2591 ░ light shade 177 B1 U+2592 ▒ medium shade 178 B2 U+2593 ▓ dark shade...

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

Slideshow div layer through a windowhttps://joellipman.com/articles/web-development/mootools/slideshow-div-layer-through-a-window.html

11 September 2012 to them as "window_slide" and "inner_window". Slide divs to be added inside the "inner_window". Move the slides in from right to left with a transition. Push existing slide out to the left; as soon as this is out of sight then hide it behind the...

• Type: Article
• Author: Joel Lipman
• Category: MooTools Framework
• Language: *

T-SQL concatenate an incremental row numberhttps://joellipman.com/articles/database/t-sql/t-sql-concatenate-an-incremental-row-number.html

24 May 2013 how do we do it? In the above example, Joel Lipman has two qualification records. So let's start with a simple query: SELECT RIGHT('000' + CAST(e.ID AS VARCHAR), 3) AS EmployeeNo, RIGHT('000' + CAST(q.Employee AS VARCHAR), 3) + '01' AS QualificationRef...

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

GDPR Privacy Policyhttps://joellipman.com/static-items/gdpr-privacy-policy.html

14 February 2019 that we provide to you electronically satisfy any legal requirement that such communications be in writing. Copyright All content included on this site, such as text, graphics, logos, button icons, images, audio clips, digital downloads, data...

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

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

05 July 2011 Const WS_EX_WINDOWEDGE = $00000100 Const WS_EX_CLIENTEDGE = $00000200 Const WS_EX_CONTEXTHELP = $00000400 Const WS_EX_RIGHT = $00001000 Const WS_EX_LEFT = $00000000 Const WS_EX_RTLREADING = $00002000 Const WS_EX_LTRREADING = $00000000 Const...

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

CSS keeping the footer at the bottomhttps://joellipman.com/articles/web-development/css/css-keeping-the-footer-at-the-bottom.html

25 April 2011 for me using the "push" div layer. Loosely based on Ryanfait: Make a Footer Stick to the Bottom of the Page Aim: Header Left Right Footer Situation The header displayed fine. The left and right columns finally got them side by side. But the footer that...

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

Zoho Creator: Render to PDF with margins and page numbershttps://joellipman.com/articles/crm/zoho/zoho-creator-render-to-pdf-with-margins-and-page-numbers.html

07 May 2024 with a modern design. How? Ok, admittedly, when first designing the template, there could have been a fair few improvements right out of the gate. Then the client comes back and says things like "can we add this?", "can it say this instead?", "can it be...

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

Oracle: order by subquery missing right parenthesishttps://joellipman.com/articles/database/pl-sql/oracle-order-by-subquery-missing-right-parenthesis.html

05 December 2013 What? A quick note on how I got round one this one. Why? Often enough, our requirement is that the latest record from another table is associated with the current row, and often enough we get the latest by ordering the dataset of the subquery. In T-SQL...

• Type: Article
• Author: Joel Lipman
• Category: Oracle PL/SQL
• Language: *

AutoHotkey - MS Windows 10 - Open Apps on Multiple Monitors and Desktopshttps://joellipman.com/articles/automation/autohotkey/autohotkey-ms-windows-10-open-apps-on-multiple-monitors-and-desktops.html

18 July 2019 virtual desktop on your device. For those that don't know it, the feature is similar to mobile phones where you swipe left/right to reveal another screen of app icons. The same can be done to the desktop versions with open applications instead of just...

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

Installing phpBB3 for Joomla with a RocketTheme templatehttps://joellipman.com/articles/cms/joomla/installing-phpbb3-for-joomla-with-a-rockettheme-template.html

28 September 2009 Click on the 'General' tab, look at the "Server Configuration" section and click the "Load Settings" link. In the right panel, there is an option saying "Recompile stale style components" with a radiobox, set this to "YES" and click on "Submit" at the...

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

CSS Background Without Causing Scrollbarshttps://joellipman.com/articles/web-development/css/css-background-without-causing-scrollbars.html

23 April 2011 A Client had some clouds on the background of his photoshop file for his website. They were to be positioned in the top right corner with the leftmost tip aligned to the right of a central content section. I separated off the clouds as another div...

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

SSRS Zero Paddinghttps://joellipman.com/articles/microsoft/ssrs/ssrs-zero-padding.html

10 November 2011 it would take them to http://ora-00201.ora-code.com/. The Padding Found this in a forum so thought I'd better make a note: Right("00000" & Fields!ERROR_CODE.Value.ToString, 5) -- "Right()" to say extract text from the right -- ".ToString" because it's...

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

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

14 March 2013 problems here relate to when our datasource was a flat file connection. We had to change the Format under General to Ragged Right (I had been setting it to "fixed width" but then got problems with it not understanding the last two characters on the row...

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

Zoho Creator: Set Up Custom Domain for Customer Portalhttps://joellipman.com/articles/crm/zoho/zoho-creator-set-up-custom-domain-for-customer-portal.html

17 November 2020 into your Zoho Creator app and go to the "Settings" tab, then on "Customer Portal" then on the "Settings" button in the top right: Under Portal URL, select "Custom Domain" and in the field below, enter the full domain (incl. subdomain) you want to use:...

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

Keyboard and mouse shortcuts in Google Chromehttps://joellipman.com/articles/google/keyboard-and-mouse-shortcuts-in-google-chrome.html

23 September 2009 Closes the current tab or pop-up. Click a tab with your middle mouse button (or mousewheel). Closes the tab you clicked. Right-click, or click and hold either the Back or Forward arrow in the browser toolbar. Displays your browsing history in the tab....

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

Migrate Joomla! 1.5.x to 2.5.x+https://joellipman.com/articles/cms/joomla/migrating-from-joomla-15-to-16.html

30 January 2011 Joomla Admin Panel using a System Administrator account ("Super User"?) Go to Categories > click on the "REBUILD" icon (top right) Go to Menus > click on the "REBUILD" icon (top right) Check your Joomla Admin User Each new Joomla version is trying a...

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

Licence GNU/GPLhttps://joellipman.com/static-items/licence-gnugpl.html

03 April 2009 GENERAL PUBLIC LICENSE Version 3, 29 June 2007 Copyright © 2007 Free Software Foundation, Inc. Everyone is permitted to copy and distribute verbatim copies of this license document, but changing it is not allowed. Preamble The GNU General Public License...

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

Problem creating SSRS report subscriptionshttps://joellipman.com/articles/microsoft/ssrs/problem-creating-ssrs-report-subscriptions.html

11 November 2013 DataSource Upload the report to the ReportServer. Hover the mouse cursor over it and click on the dropdown arrow to its right Select "Manage" in the dropdown menu Select "Data Sources" in the left menu Specify a "custom data source" and test the...

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

Hide a Drive per User in Windows 7https://joellipman.com/articles/microsoft/windows-os/hide-a-drive-per-user-in-windows-7.html

28 March 2014 In regedit, expand to the following key HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Policies\Explorer In the right pane of Explorer, right click on a empty area, click on New > DWORD (32-bit) Value > type NoDrives > Enter. Right click on...

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

Zoho Analytics: Create a Monitoring System with Imageshttps://joellipman.com/articles/crm/zoho/zoho-analytics-create-a-monitoring-system-with-images.html

25 July 2024 For demo purposes, I'm going into the CRM Reports workspace > Click on "Create" > Then select "Dashboard": Then in the top right of the dashboard, I'm going to click on the "Widget" button: On the data column, I'll select any query and any field. It...

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