Forum Ruleshttps://joellipman.com/static-items/forum-rules.html

31 May 2009 muted for 10 days will be banned for a month, and for 2 months for the next offense. Permanent ban - At this point, it is obvious that will never learn your lesson, thus, a permanent ban is necessary to be rid of the problems you cause. The following...

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

Project Plan for Freelance Websitehttps://joellipman.com/articles/web-development/project-plan-for-freelance-website.html

25 February 2010 template project initiation plan (project mandate?) for my freelance website development process. It may look clean, clear, obvious... it's just an outline of what I picture as a perfect project; unfortunately the first 2 pages tend to be completed in...

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

Difference between two dates - the midnight hourhttps://joellipman.com/articles/web-development/difference-between-two-dates-the-midnight-hour.html

06 April 2011 -------------- 04/03/2011 Tweedle Dee 10:00 12:00 2.00 08/03/2011 Tweedle Dum 23:30 00:30 -23.00 Note the last row is obviously incorrect. This is because the script is not changing the date at the stroke of midnight. Take the last row as an example,...

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

What's the problem? Amusing computer issueshttps://joellipman.com/articles/web-development/whats-the-problem-amusing-computer-reports.html

28 April 2011 website and it's not displaying properly on my colleague's computers". [Priority 1] What's a web guru? Well this might be obvious to some but these are self-proclaimed highly qualified web-gurus in the marketing department. They'd paid around £150,000...

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

Joes Quicklist Weblinks (JQW)https://joellipman.com/component/content/article/joes-quicklist-weblinks-jqw.html?catid=40

03 July 2011 file). Save it to the images folder which keeps all your other thumbnails for this module. No Semi-Transparency Effect? Not obvious but to switch this off, the parameter "Semi-Transparent Effect" has to equal 1. If you put a fraction of 1, eg. 0.5, this...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

Connect to Joomla database in standalone scripthttps://joellipman.com/articles/cms/joomla/connect-to-joomla-database-in-standalone-script.html

17 August 2012 to use the existing configuration file in order to retrieve the credentials (ie. username, password, database, etc.). For obvious reasons, these cannot be hardcoded. What? Any developer installing my component will do so on a website which uses...

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

Search a database with SOUNDEXhttps://joellipman.com/articles/database/search-a-database-with-soundex.html

11 October 2012 End-users said that they could see the options "Data Not Yet Available" as well as "Data not yet available". These are obviously the same values, so I should go through the database and change all variations to be typed the same way in the same case....

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

SSIS Skip Blank Rows in Flat File Sourcehttps://joellipman.com/articles/microsoft/ssis/ssis-skip-blank-rows-in-flat-file-source.html

23 April 2013 There may be error messages posted before this with more information about the failure. Why? So the solution must be obvious to you by now. At least that's what Microsoft people think to themselves every time they see the error they programmed in....

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

T-SQL Conversion failed when converting the varchar to data type inthttps://joellipman.com/articles/database/t-sql/t-sql-conversion-failed-when-converting-the-varchar-to-data-type-int.html

14 May 2013 = ref.RefMappedValue AND ref.[RefSheet] = 'myPayrollCategory' AND ref.[RefSystem] = 'myPayrollSystem' Yes well obvious to some but then you google the above and you get half a million results. That's a lot of reading so here's the simple fix for my...

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

Split a row into multiple rows based on a column valuehttps://joellipman.com/articles/database/t-sql/split-a-row-into-multiple-rows-based-on-a-column-value.html

23 August 2013 1.00 1 003 2.00 1999-02-25 1.00 2 Great! Now let's just add the Rownum value to the date of sickness (minus 1 for obvious reasons - 25th + row(1) = 26th when the person was off the 25th): SELECT EmployeeNo , '1' + substring(CAST(DaysOffSick AS...

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

Include a carriage return in a column headinghttps://joellipman.com/articles/microsoft/sql-server/include-a-carriage-return-in-a-column-heading.html

07 July 2014 is that when you refresh the data, it will retain the carriage return in the column headings. Additional: Only appears obvious in SQL Server Management Studio resultset. Remember to format the cells (column headings) in the Excel spreadsheet for it to...

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

Zoho Templates - Font size is inexplicably tinyhttps://joellipman.com/articles/crm/zoho/zoho-templates-font-size-is-inexplicably-tiny.html

22 February 2019 here to see if that helps: Wrapping all your HTML in : Ok it's used in bootstrap and few other frameworks so this should be obvious, but for some reason the header and footer of my code set with CSS {position:fixed} won't display on the first/cover page...

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

Zoho Projects: Get All Eventshttps://joellipman.com/articles/crm/zoho/zoho-projects-get-all-events.html

22 July 2024 remember is that status is a mandatory field and it can either be "closed" or "open". If you have used ZohoCRM then this is obvious; if you haven't then it may be difficult to work this out. Put simply, "Closed" are events in the past and "Open" are...

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

SSRS Use T-SQL Like with a Parameterhttps://joellipman.com/articles/microsoft/ssrs/ssrs-use-t-sql-like-with-a-parameter.html

04 April 2011 must have been so obvious to everyone 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...

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

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

26 September 2011 and the inability to know exactly what I'm looking for... always difficult. After a cup of tea the solution was glaringly obvious, just do a primary school mathematics table and it all makes sense (see my 10 mod table below). This article is a quick...

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

Link to a Joomla article from within another articlehttps://joellipman.com/articles/cms/joomla/link-to-a-joomla-article-from-within-another-article.html

04 December 2012 Quick article here as googling/binging for how to refer to Joomla articles after versions 1.5.x wasn't obvious. This article is to demonstrate how to write the webaddress for a Joomla article even when you have Search-engine-friendly website addresses...

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

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

03 January 2013 files in a Visual Studio 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...

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

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

03 June 2014 an SSIS custom component. How? This is simply the "Script Component" under "Extensions". No MSDN website said this... obvious to Microsoft staff so why should their documentation include it? Workaround (applies for any dll) You right-click on the...

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