Forgotten Super User Password in Joomla 2.5.x - 3.xhttps://joellipman.com/articles/cms/joomla/forgotten-super-user-password-in-joomla.html

06 February 2015 How? This method is reliant on having access to the database of your Joomla website. Method #1: Quickest way I know This is based on if you have another user account (registered or administrator, any) with a password known to you (create a new joomla...

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

SSRS Use T-SQL Like with a Parameterhttps://joellipman.com/component/content/article/ssrs-use-t-sql-like-with-a-parameter.html?catid=75&Itemid=165

04 April 2011 else that nobody bothered to write an article on it... till now. Situation I have a report that returns room bookings based on a user and given a date range. The problem is that there are a few thousand users and Microsoft's SQL Server Reporting...

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

Set default parameter dates to start and end of monthhttps://joellipman.com/component/content/article/set-default-parameter-dates-to-start-and-end-of-month.html?catid=75&Itemid=165

05 April 2011 format - mm/dd/yyyy) =dateadd("d",-1, CDate(cstr(month(today.now())+1) + "/1/" + cstr(year(today.now()))) ) This idea was based on Bob Griffin's post on SQL Server Central.com forums where he subtracts 1 day from the first day of next month to get the...

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

Increase Recent Documents Number in Windows XPhttps://joellipman.com/component/content/article/increase-recent-documents-number.html?catid=80&Itemid=165

28 July 2011 Just a quick note here. This is an article based on the REG file from Kelly's Korner (@www.kellys-korner-xp.com/xp_tweaks.htm). I'm not fond of downloading REG files and running them even if I have checked what it's doing. I'm putting a note here just...

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

MySQL Group_concat equivalent in T-SQL and Oraclehttps://joellipman.com/articles/else/database/mysql-groupconcat-equivalent-in-t-sql-and-oracle.html

28 November 2011 other job and it beats daytime television any day. I use this quite a lot so I thought I'd put an article here somewhere. Based on the following concept: RowID column_to_return_as_string --------- -------------------------- 1 Me 2 Myself 3 I -- to be...

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

Change div height to fit contenthttps://joellipman.com/articles/cms/website-development/css/change-div-height-to-fit-content.html

19 December 2016 to: CSS HTML What? A quick article on how to get a div layer to increase height based on how a heading fits on a page. What? I have a heading like this: The code of this is: A long heading that wraps over several lines When I shrink the browser, I get a...

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

SITS: XET format for Export not availablehttps://joellipman.com/articles/cms/website-development/xml/sits-xet-format-for-export-not-available.html

08 August 2014 development environment. I had to create a Data Exchange Format first: Run the DEF from the menu Clear and create a new one based on the following: Now you can go and retrieve a student/staff (depending on what data your XET feeds off) Bring up STU File...

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

Cranberry flapjackhttps://joellipman.com/component/content/article/cranberry-flapjack.html?catid=96&Itemid=165

07 July 2009 oats, honey, self-raising flour, egg and dried cranberries. This should form a thick batter. 2. Melt the butter in a thick based non-stick frying pan. Spoon the mixture into small rounds. 3. Fry for 2-3 minutes on each side until golden. 4. For the...

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