Gavick - How to add a navigation menu to Image Showhttps://www.joellipman.com/articles/cms/joomla/gavick-how-to-add-a-navigation-menu-to-image-show.html

07 April 2010 (well i had). This is how to make sure it shows on the template style and how to position it on the image slide show module that comes bundled with the extension.{youtube}qOWGxgyoqA4{/youtube}

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

Thank You for your donation!https://www.joellipman.com/thank-you-for-your-donation.html

08 August 2010 As an IT professional, I feel that both OpenSource and Commercial applications have their benefits and neither should go. My day job doesn't involve any Joomla! material but has many Content Management Systems (CMS) commercial equivalents. I use any...

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

Frontpage Item Orderinghttps://www.joellipman.com/articles/cms/joomla/frontpage-item-ordering.html

16 September 2010 where it was taking the order it puts the articles in the front page (or landing page) was confusing me. The quick answer is that it is within the menu manager > main menu > menu item section of your Joomla! Admin Panel. Certain Advanced Parameters in...

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

Comparing two mediawiki siteshttps://www.joellipman.com/articles/cms/mediawiki/comparing-two-mediawiki-sites.html

17 September 2010 basically highlighted articles found in one but not the other - we had over 2000 articles... I guess I'm a bit geekly like that) This doesn't show modified date and content size differences but I can run this SQL query to show me these.

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

The Sandpithttps://www.joellipman.com/graphic-design/the-sandpit.html

26 September 2010 Personally I can sit there watching it without sound. Here's another video that shows how to build the camera: {module title="Youtube Embedded Video - Tilt-Shift Camera"}

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

SSRS Templates in BIDS 2008https://www.joellipman.com/articles/microsoft/ssrs/ssrs-templates-in-bids-2008.html

01 April 2011 Open a Windows Explorer and make a duplicate of the report that you want to use as a template. Rename the copy (suffix with template?) Remove objects unique to the report and leave elements for all reports. File > Save selected item as... For SSRS...

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

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

28 November 2011 1 Me 2 Myself 3 I -- to be returned as RowID my_field_name --------- -------------------------- 1 Me,Myself,I Note that the following queries include the nested version because I find myself needing to group concatenate more often from another table...

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

Strip HTML in MySQLhttps://www.joellipman.com/articles/database/mysql/strip-html-in-mysql.html

06 December 2011 used. How? There were a few functions out there. One called "strip_tags" crashed in the running of the query. The function that did work errored persistently complaining about the delimiter, create the function by running the following: SET GLOBAL...

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

Select unique values in Microsoft Excel columnhttps://www.joellipman.com/articles/microsoft/excel/select-distinct-values-in-microsoft-excel-column.html

03 July 2012 I'd put a quick note here, I tried a fair few solutions that didn't work and then found this hidden away in a forum: Quick Count =INT(SUMPRODUCT((A3:A1000"")/COUNTIF(A3:A1000,A3:A1000&""))) This returns the number of unique values in the range A3 to...

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

Drop If Object Existshttps://www.joellipman.com/articles/database/t-sql/drop-if-object-exists.html

03 August 2012 So here you go, I hope it's of some use. If it's wrong then just post a comment at the bottom of this page. Go go go Note that in the following examples, I'm checking under the [Common] schema, this might be [dbo] for you or a more specific one. -- drop...

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

Mootools - How to contain a menu sidebar between header and footerhttps://www.joellipman.com/articles/web-development/mootools/mootools-how-to-contain-a-menu-sidebar-between-header-and-footer.html

10 August 2012 This has taken me too long to figure out and I hope I don't lose this note again. The only website that was titled similarly kept slowing down my computer too much so I decided to work out my own. The complexity is due to content also being dynamically...

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

DBMS Random Referencehttps://www.joellipman.com/articles/database/pl-sql/dbms-random-reference.html

21 August 2012 How to use the randomization features of Oracle PL/SQL. Why? I've been tasked with writing a stored procedure that scrambles data for developers working with some of our databases containing sensitive data. How? SELECT DBMS_RANDOM.option1[(option2)]...

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

The greatest invention in IThttps://www.joellipman.com/hardware/the-greatest-invention-in-it.html

13 September 2012 hardware has to be the following notion from IBM: a 1976 research report by Lance A. Miller and John C. Thomas of IBM, noted that "It would be quite useful to permit users to 'take back' at least the immediately preceding command (by issuing some...

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

UNC Paths in Sharepoint 2007 linkshttps://www.joellipman.com/articles/microsoft/sharepoint/unc-paths-in-sharepoint-2007-links.html

08 November 2012 use the link. Why? As soon as someone suggested I setup WebDAV to do this, I thought I'd write this article to warn others that that's unnecessary and can simply open another can of worms (security-wise). There may be situations when this is better but...

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

Deserialization and cannot checkout files in TFShttps://www.joellipman.com/articles/microsoft/tfs/deserialization-and-cannot-checkout-files-in-tfs.html

03 January 2013 2010 project. All my colleagues can. What? Rather silly I know and the solution is one of those obvious ones for those that know how but for those who can't remember, then it can take a while. How? Open the solution file Select any file in the Solution...

• Type: Article
• Author: Joel Lipman
• Category: Team Foundation Server
• Language: *

Convert Decimal (Person Days) to Time in Excelhttps://www.joellipman.com/articles/microsoft/excel/convert-decimal-person-days-to-time-in-excel.html

13 February 2013 to [h]:mm:ss -- yields 1:00:00 0.04166667 =(ROUND(B5/0.07, 0)*0.5)/24 -- now format to [h]:mm:ss -- yields 1:00:00 Note that the first formula is converting person days into minutes and then dividing by 1440 (resulting in the decimal number: 0.04166667...

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

SharePoint 2007: Change profile picture with minimal permissionshttps://www.joellipman.com/articles/microsoft/sharepoint/sharepoint-2007-change-profile-picture-with-minimal-permissions.html

07 November 2013 permissions they've been given. Why? Because I can How? Setup an account with gravatar.com and they’ll give you a link to that picture (eg. http://www.gravatar.com/my-picture), Go to your SharePoint site Click on the “People and Groups” link at the...

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

MS Excel: Convert a text to a numberhttps://www.joellipman.com/articles/microsoft/excel/ms-excel-convert-a-text-to-a-number.html

15 November 2013 pounds (sterling). When I multiply the Philippine peso by the conversion rate, it returns #VALUE! How? The problem is that I have a column which includes the currency symbol as per the following image: I create another column with the symbol omitted...

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

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

22 November 2013 credentials used to run the report are not stored, or if a linked report, the link is no longer valid. 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...

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

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

05 December 2013 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 and...

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