Border settings not saving in SSRShttp://mail.joellipman.com/articles/microsoft/ssrs/border-settings-not-saving-in-ssrs.html

24 March 2011 would show for empty spaces. I wasn't getting very far because I'd even ask the border to be grey and save the project but when I come back to the setting, it's still black. I found that you have to select a color or expression first, then define which...

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

Code Troubleshooting Checklisthttp://mail.joellipman.com/articles/web-development/code-troubleshooting-checklist.html

03 June 2011 and procedures? Confirmed any ACL/permissions on the files? Ensured all global, posted and session variables are present when they should be and behave properly? Broken down the error in understandable and diagnosable parts? Checked appropriate services...

• Type: Article
• Author: Joel Lipman
• Category: Web-Development
• Language: *

First and Last Entry on a Page using Modulus Remainderhttp://mail.joellipman.com/articles/web-development/php/first-and-last-entry-on-a-page-using-modulus-remainder.html

26 September 2011 sense (see my 10 mod table below). This article is a quick note (so I never spend as long again) in PHP on how to determine when looping through a loop, which entry was first and which was last. This is incredibly useful for pagination. The Situation I...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: *

Convert seconds to total time in PHPhttp://mail.joellipman.com/articles/web-development/php/convert-seconds-to-total-time-in-php.html

31 January 2012 intended for activity/session durations and although I usually get MySQL to do the date/time calculations, there are times when we have to do with PHP. This is the shortest way I know to properly convert seconds into total hours, minutes and seconds...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB

MySQL day of week ending on Fridayhttp://mail.joellipman.com/articles/database/mysql/mysql-day-of-week-ending-on-friday.html

26 April 2012 Ending Date has been requested a lot more frequently now. It's an odd one but the example below shows how to do this for when the week ends on Friday. Assuming it starts on the previous Saturday. Why? Problems with MySQL weeks always starting on Sunday...

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

Joomla field types clear my htmlhttp://mail.joellipman.com/articles/cms/joomla/joomla-field-types-clear-my-html.html

09 August 2012 Trying to make a component and can't remember how to store HTML code when the save command is clicked (ie. submitted from a PHP form). This is for the Opensource Content Management System (CMS - phew what a mouthful) Joomla! version 1.6.x to 2.5.x; no...

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

List last modified files using FTP Command-linehttp://mail.joellipman.com/articles/web-development/ftp/list-last-modified-files-using-ftp-command-line.html

20 November 2012 to confirm the remote working directory is the current directory. Type lcd to confirm what the local working directory is (when you download or print output, it will save to this folder on your computer). Can type lcd if you want to change this (leave...

• Type: Article
• Author: Joel Lipman
• Category: File Transfer Protocol
• Language: *

Ordered List of over 1000 Itemshttp://mail.joellipman.com/articles/web-development/css/ordered-list-of-over-1000-items.html

08 February 2013 So many people asking this when the solution is a bit of aesthetic styling. ol{margin:4px} -- yields 995. 996. 997. 998. 999. 000. 1000 Ordered list resets to zero after the ninth item Ordered List Maximum

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

Modifying columns in a tablehttp://mail.joellipman.com/articles/database/modifying-columns-in-a-table.html

24 July 2013 to modify a column in a database table the old fashioned way (as in stop making me use GUI interfaces so poorly programmed when even I've made better DBMS tools). All SQL -- Add a column to an existing table (giving it datatype char(2) and allowing...

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

SSRS Subscriptions cannot be createdhttp://mail.joellipman.com/articles/microsoft/ssrs/ssrs-subscriptions-cannot-be-created.html

22 November 2013 How? I'd like to say that the solution is far more complicated then this, but it isn't. This is one of those rare situations when the Microsoft error is describing the exact problem. If you include linked images in the report (as in images not in the...

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

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

05 December 2013 the latest by ordering the dataset of the subquery. In T-SQL and MySQL, this is not so much of an issue. I get this error when having to use an ORDER BY clause in a subquery within an Oracle 11g environment. How? Consider the following: SELECT...

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

SSIS: Add Reference Microsoft.SqlServer.TxScripthttp://mail.joellipman.com/articles/microsoft/ssis/ssis-add-reference-microsoft-sqlserver-txscript.html

03 June 2014 This article is so that I don't spend so long in googling what the TxScript referenced assembly is when creating an SSIS custom component. How? This is simply the "Script Component" under "Extensions". No MSDN website said this... obvious to Microsoft...

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

SITS: XET format for Export not availablehttp://mail.joellipman.com/articles/web-development/xml/sits-xet-format-for-export-not-available.html

08 August 2014 Trying to export a STU record but I want to use the XET template I created rather than the pre-installed XML export formats. When I try to export using data format XET, the system has never heard of it. Why? To test the XET I created, I want to see what...

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

VBScript to retrieve Windows Product Keyhttp://mail.joellipman.com/articles/microsoft/windows-os/vbscript-to-retrieve-windows-product-key.html

23 September 2015 I didn't want to dig through my CD/DVDs to find my original windows 7 disc and no longer have access to the email account when I purchased Windows 7 (my university one). How? I'm going to use my trusty notepad program, copy the following code to it, and...

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

SELECT COUNT(DISTINCT name) FROM tablehttp://mail.joellipman.com/articles/cms/joomla/select-count-distinct-name-from-table.html

24 September 2015 correct number. I'm still unsure as to why WHERE...GROUP BY... doesn't return the same totals and will update this article when I figure it out.

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

Change div height to fit contenthttp://mail.joellipman.com/articles/web-development/css/change-div-height-to-fit-content.html

19 December 2016 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 heading like this: I want this to happen: The code of this is the addedn...

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

FTP on Mac: Failed to retrieve directory listinghttp://mail.joellipman.com/articles/web-development/ftp/ftp-on-mac-failed-to-retrieve-directory-listing.html

06 October 2018 EXCEPT for "Enable Stealth Mode" Settings Security and Privacy Firewall Firewall Options Note: the filezilla just appeared when it was running. I didn't add it. Helpful Links WireNine.com - Knowledgebase - How to fix failed to retrieve directory listing...

• Type: Article
• Author: Joel Lipman
• Category: File Transfer Protocol
• Language: *

Calculate Aspect Ratiohttp://mail.joellipman.com/graphic-design/calculate-aspect-ratio.html

17 January 2019 So this is a quick article on how to maintain an aspect ratio when resizing an image. How? These are the calculations to work out the new height given the width or the new width given the height: (original height / original width) x new width = new...

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

Zoho Deluge - Get Current User IDhttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-get-current-user-id.html

08 April 2019 get the current user ID in Zoho through code. How? I'm not a fan of method #1 but I only started developing in Zoho recently when API v1 was already being deprecated (end of life at the end of this year). So I'm familiar with the methods in API v2 or...

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

JComments errors in PHP 7: plgContentJComments and JCommentsACLhttp://mail.joellipman.com/articles/cms/joomla/jcomments-errors-in-php-7.html

13 March 2020 During a site upgrade, the commenting extension for Joomla called JComments would return errors when using PHP version 7. This is a quick article to document what needed doing to fix the errors. How? First some errors: ERROR: plgContentJComments...

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