Increment a column in MySQL using the UPDATE queryhttp://www.joellipman.com/articles/database/mysql/increment-a-column-in-mysql-using-the-update-query.html

18 February 2010 Suppose you have a column in your table that you use as a counter (storing the value of the counter - eg. times an article has been displayed). Basically what I used to do is something similar to the following: SELECT counter_field_value FROM table1...

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

How to make your Joomla site use SEO friendly urlshttp://www.joellipman.com/articles/cms/joomla/how-to-make-your-joomla-site-use-seo-friendly-urls.html

02 April 2010 Basically so that you can set all those SEO settings in the global configuration tab to YES. Note: you need the permissions to rename the file ("htaccess.txt" to ".htaccess" in your website root folder). You'll need ftp access or a file manager with...

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

Gavick - How to add a navigation menu to Image Showhttp://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!http://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 Orderinghttp://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 siteshttp://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 Sandpithttp://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 2008http://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 Oraclehttp://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 MySQLhttp://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 columnhttp://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 Existshttp://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 footerhttp://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 Referencehttp://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 IThttp://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 linkshttp://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 TFShttp://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 Excelhttp://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 permissionshttp://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 numberhttp://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