SSRS Parameters in Oracle Stored Procedurehttps://joellipman.com/articles/microsoft/ssrs/ssrs-parameters-in-oracle-stored-procedure.html

02 September 2011 the Username of the person running the report. This second page is called "HouseKeepForm". We have a 3rd report which will actually execute the stored procedure called "HouseKeepExec". The Problem We get the above error if we tried to execute the stored...

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

T-SQL Record Separatorhttps://joellipman.com/articles/database/t-sql/t-sql-record-separator.html

11 October 2011 Monday Monday Monday Tuesday Tuesday Wednesday Thursday Thursday Thursday Thursday Friday Friday */ This is actually part of a SQL query (Transact-SQL) used in an Excel file. Some of our end customers are not even computer literate so the SQL query had...

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

SSRS Retrieving Oracle Stored Procedure Success or ErrorLevelhttps://joellipman.com/articles/microsoft/ssrs/ssrs-retrieving-oracle-stored-procedure-success-or-errorlevel.html

04 November 2011 which the user clicks and confirms that this is the student to update. The confirm button links to a 3rd report which will actually execute the stored procedure which updates the student record as well as an audit table. The Problem The last report will...

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

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

11 February 2023 Estate Photography Still Life Photography Tech Photography Camera Angle Note that there others, I'm only listing ones that actually followed the prompt (eg. Eye-Level Shot puts a massive eye on the picture???) Cinematic Still Shot Full-Body shot...

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

Write a Calendar in Autohotkeyhttps://joellipman.com/articles/automation/autohotkey/write-a-calendar-in-autohotkey.html

27 January 2010 mixed code. Obviously just omit the HTML rubbish if you want to create a calendar using just autohotkey syntax. Actually, the following code is an excerpt from my program which checks an online server (for IT Events during this month) and if it can't...

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

Remove write-protect from USB pen in Windowshttps://joellipman.com/articles/microsoft/windows-os/remove-write-protect-from-pen-in-windows.html

13 April 2010 The chap went to www.apacer.com which is just where I’ve been trawling through and I have found a utility that actually works on my pen!!! It said “repaired USB pen” and when I go to check the space, my 30Gb has returned!!! It’s called Urescue and it’s...

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

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

27 April 2010 what are these Aero effects? Aero Peek: Aero Peek What this is it gives you a preview of windows in a thumbnail without actually opening them by simply hovering over the icon in the taskbar. Click on one of them and you will be taken to that window,...

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

Is it a scam? Gumtree.com's warning signshttps://joellipman.com/hardware/is-it-a-scam-gumtreecoms-warning-signs.html

12 October 2010 suggests using an escrow service to complete the transaction. These escrow websites often may look official, but are actually run by fraudsters. They’ll take your money and never send you the product. Payment for brokerage/importing. A seller claims...

• Type: Article
• Author: Joel Lipman
• Category: IT Support
• Language: *

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 the web, the system introduces only a few new fundamental improvements (particularly Access Control and Groups) which actually only means some minor database alterations. I've googled, yahood and binged, but still can't find a good way to upgrade my...

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

MySQL: Find records in one table that are not in another.https://joellipman.com/articles/database/mysql/mysql-find-records-in-one-table-that-are-not-in-another.html

25 February 2011 880 rows 0.187s STATEMENT2 741 rows 49.933s STATEMENT3 741 rows 48.844s STATEMENT4 741 rows 49.603s And Vice-Versa? Well actually I wanted all the articles that have NOT been approved yet... So would this work if I switched MyTable1 with MyTable2? Um...

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

Inserting incremental weeks in MySQLhttps://joellipman.com/articles/database/mysql/inserting-incremental-weeks-in-mysql.html

15 April 2011 the system last another year. Shame he also forgot the academic year ends halfway in a normal people's calendar, so you actually have to adjust this twice a year. Complicated Facility works like this, ask it what date it is on Tuesday in Week 52 of the...

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

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

10 November 2011 to look them up the error is ORA-12345. Unfortunately Oracle also returns errors of less than 10000 so ORA-00201 would actually be returned as "-201". As I wanted a link so that the user can just click on this link and it would take them to...

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

How to Display Report Execution Time in SSRS (milliseconds)https://joellipman.com/articles/microsoft/ssrs/how-to-display-report-execution-time-in-ssrs.html

17 November 2011 "Dataset1")) ).ToString & " second(s)" // yields // Time Taken: 00:00:02.15443570 second(s) -- What if the report actually took more than a minute... more than an hour ="Time Taken: " & ( (Mid( CStr( ( CDate(Last(Fields!REPORTENDTIME.Value, "Dataset2"))...

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

Background Gradient Disappears on Long Pageshttps://joellipman.com/articles/web-development/css/background-disappears-on-long-pages.html

20 November 2012 background would disappear when the page finally loaded. How? The root cause was because the template I was using was not actually specifying "white" as the contents background-color and was in fact setting a gradient as the background. Consider the...

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

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

03 April 2009 use of that class of product, regardless of the status of the particular user or of the way in which the particular user actually uses, or expects or is expected to use, the product. A product is a consumer product regardless of whether the product has...

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

Upgrading a Joomla 1.5 module to Joomla 2.5https://joellipman.com/articles/cms/joomla/upgrade-a-joomla-1-5-module-to-joomla-1-6.html

11 February 2011 purposes we will be referring to a Joomla module called "mod_moduletoupgrade" in British English (en-GB). I don't think it actually exists in reality but you replace the name "moduletoupgrade" with whatever you're upgrading and follow the below...

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

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

14 March 2013 specified component. There may be error messages posted before this with more information about the failure. All this blab actually means is that there is a chance one of your date values is BLANK, NULL or contains a non-numerical value in a number such...

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

Registered Users Cannot Login - Super Users Canhttps://joellipman.com/articles/cms/joomla/registered-users-cannot-login-super-users-can.html

26 February 2014 website had a redirect on the login which would go to a page accessible by "registered" users but only "Super Users" could actually login. "Registered" users would not be able to login, despite their status in the admin panel saying "enabled" and...

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

JComments 2.3.0 with ReCaptcha in Joomla 2.5.xhttps://joellipman.com/articles/cms/joomla/jcomments-2-3-0-with-recaptcha-in-joomla-2-5-x.html

20 March 2014 post that may get moved/deleted, I've copied most of it and put it here with my minor revisions/adjustments to get it actually working. STEP #1: Check ReCaptcha API Check your recaptcha plugin is up-to-date as some Joomla 2.5.x systems will not have...

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

AHK Countdown Tooltiphttps://joellipman.com/articles/automation/autohotkey/ahk-countdown-tooltip.html

17 July 2014 ThisManyWorkingDaysInMessage:=ThisManyWorkingDaysIn " day" ( ThisManyWorkingDays==1?"":"s") " you actually have to be in." ThisManyWorkingHoursMessage:=ThisManyWorkingHours " hour" ( ThisManyWorkingHours==1?"":"s") " and " ThisManyWorkingHoursRemainder...

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