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

11 September 2012 incomplete! Will post a final solution but here are the basics What? This article is a quick note to myself on the idea of a slideshow with the MooTools javascript framework. Basically, I want to create a div layer that I can see through (like a window...

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

Zoho Creator: isBlank and isNull: Before or After?https://joellipman.com/articles/crm/zoho/zoho-creator-isblank-and-isnull-before-or-after.html

10 February 2025 that I saw other code like this and when reverse engineering or debugging the code, it may be worthwhile having a definitive idea of what will happen. The intended purpose of isBlank() void fn_Test() { info "---------------------- Value of TEST is a...

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

Change default order of weblinkshttps://joellipman.com/articles/cms/joomla/change-default-order-of-weblinks.html

15 November 2009 first) hits => sort by hits (number of times clicked on) published => obviously by whether they're published or not... no idea why u would checked_out => sort by checked out (will either display or not on the front page so again not any use to sort by...

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

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

25 January 2010 ; DON'T EDIT THESE FUNCTIONS BELOW (I have no idea how they work only that they do) SetCursor(pShape, pCtrl="") { return SetCursor_(pShape, pCtrl, 0, 0) } SetCursor_(wparam, lparam, msg, hwnd) { static WM_SETCURSOR := 0x20, WM_MOUSEMOVE := 0x200 static...

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

Windows 7 Aero Featureshttps://joellipman.com/articles/microsoft/windows-os/windows-7-aero-features.html

27 April 2010 shortcut command: Visit http://www.paraesthesia.com/archive/2010/04/16/fun-with-windows-aero-flip-3d.aspx as this was not my idea but quite ingenious and worth a mention. Did anyone else have any problems with Aero effects when they first installed...

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

Language Codeshttps://joellipman.com/articles/cms/joomla/language-codes.html

13 September 2010 started developing multi-language components, it was important that I get a general idea as to what languages are abbreviated to. Usually I only write english files (en-GB) but it's not very international and narrow-minded to think only English speakers...

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

URL passed settings in Reporting Serviceshttps://joellipman.com/articles/microsoft/ssrs/url-passed-settings-in-reporting-services.html

11 February 2011 &rc:FindString=foo Note: I have no idea what this is for. Render a snapshot http:///ReportServer/Pages/ReportViewer.aspx?%2fMYREPORTS%2fDemos%2fRB+Report+for+Me&rs:Command=Render &rs:Snapshot=2004-03-30T15:45:02 Use a specific stylesheet (handy for...

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

MySQL parameters in Excel 2007 PivotTableshttps://joellipman.com/articles/database/mysql/mysql-parameters-in-excel-2007-pivottables.html

24 August 2011 solution but it works in Excel 2007 Now we want to filter the pivotTable data based on these two values... (I don't like the idea of requiring macros as not all users switch this on and teaching executives on how to do this is tough work. What Next?...

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

SSRS Dropdown parameter cannot be blank!https://joellipman.com/articles/microsoft/ssrs/ssrs-dropdown-to-allow-blank-values.html

14 December 2011 This is the tough part. I was reading up on the MSDN page for the closest solution but it still didn't work for me. But the idea of inserting a NULL entry to select sounded good. Aim / Objective The plan will be to replace the default "" with a custom...

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

Copy a table with structure and data into a temporary tablehttps://joellipman.com/articles/database/t-sql/copy-a-table-with-structure-and-data-into-a-temporary-table.html

03 August 2012 maintaining the structure and data. Thinking inside of the box I think everyone suggests the following (or at least the idea of): SELECT * INTO #MyTempTable FROM @GivenTable If @GivenTable is a parameter then the above will simply return an error. Also,...

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

Basic Joomla 2.5 Mootools Formhttps://joellipman.com/articles/cms/joomla/basic-joomla-25-mootools-form.html

20 August 2012 that Yootheme warp does not include the mootools-more.js file: -- reminder: check for conflicts Additional Notes You have no idea how long it has taken me to get this code in working order and as easy as it may be to others, this has been quite a...

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

Search a database with SOUNDEXhttps://joellipman.com/articles/database/search-a-database-with-soundex.html

11 October 2012 somewhat limited in Sql Server 2008 R2 by 4000 characters in a variable (so I couldn't store it in a local variable). So the idea here is to run the below example which outputs a huge SQL query which you then copy & paste and run against your database....

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

AwStats Data Parser (ADP)https://joellipman.com/component/content/article/awstats-data-parser-adp.html?catid=40

03 April 2013 it's the end of the month again and I have to prepare a report for some investors. The idea of an infographic report has excited them to no end but because the end of the month didn't wait for me to finish the project, I quickly created this program to...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

SSIS Skip Blank Rows in Flat File Sourcehttps://joellipman.com/articles/microsoft/ssis/ssis-skip-blank-rows-in-flat-file-source.html

23 April 2013 blank rows and inserted in the next line) and creating discrepancies that would error the flow. Solution Found!!! Taking the idea that the Carriage Return (CR) or Line Feeds (LF) are being inserted, simply extract the entire row as a column and trim it....

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

Export Joomla Users scripthttps://joellipman.com/articles/cms/joomla/export-joomla-users-script.html

28 February 2014 you should get all your users listed... For security reasons, delete the file after you have used it. IT IS A SERIOUSLY BAD IDEA TO LEAVE THIS FILE ON YOUR WEBSITE FOR ANYONE TO ACCESS!!! DELETE IT AFTER USE.

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

A quick run through of setting up an export process in SITShttps://joellipman.com/articles/web-development/xml/a-quick-run-through-of-setting-up-an-export-process-in-sits.html

21 August 2014 key fields from the Course Application (CAP) entity/table. Create the XML Exchange Template (XET) The XET will give me an idea of what the output will be for my staging process as well as seeing what fields I will be bringing through. Run XET from the...

• Type: Article
• Author: Joel Lipman
• Category: Extensible Markup Language
• Language: *

Zoho Deluge: Today, Tomorrow, Day After but Skip Sundayhttps://joellipman.com/articles/crm/zoho/zoho-deluge-today,-tomorrow,-day-after-but-skip-sunday.html

02 November 2021 2022,Wed Jul 27 00:00:00 PDT 2022,Thu Jul 28 00:00:00 PDT 2022,Fri Jul 29 00:00:00 PDT 2022 But if I were to maintain the idea above and skip a selected day, I would write something like the following: // // initialize list to hold valid appointment...

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

PC Build 2022: 5 Monitors connected to 1 PC using 1 GPUhttps://joellipman.com/pc-build-2022-5-monitors-connected-to-1-pc-using-1-gpu.html

12 March 2022 modern motherboard BIOS allows you to enable this. It's just a setting in the BIOS if your motherboard supports it (I had no idea whether my motherboard supported it as it kept talking about AMD Crossfire/NVidia SLI and I'm doing neither). But that...

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

Joel's Reference to MidJourney v4 Promptshttps://joellipman.com/graphic-design/joel-s-guide-to-midjourney-prompts.html

11 February 2023 you can have a private conversation with the MidJourney Bot Type the word /imagine and then a space and then type your idea (eg. "fire mage, steampunk victorian, detailed, full body hyperrealistic female" without the quotes to get the left image here)....

• Type: Article
• Author: Joel Lipman
• Category: Graphic Design
• Language: *

Collin Consulting Ltdhttps://joellipman.com/component/content/article/collin-consulting-ltd.html?catid=33

29 June 2014 did a really superb job for me on this. My website crashed and I had no idea how to fix it. My hosting service were no help at all. Worse, I hadn't backed up my website for 18 months so even if Joe managed to retrieve it I expected most of my data to...

• Type: Article
• Author: Webmaster
• Category: Portfolio
• Language: *