Licence GNU/GPLhttps://joellipman.com/static-items/licence-gnugpl.html

03 April 2009 is precisely where it is most unacceptable. Therefore, we have designed this version of the GPL to prohibit the practice for those products. If such problems arise substantially in other domains, we stand ready to extend this provision to those domains...

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

MS-DOS: Copy folders without overwriting fileshttps://joellipman.com/articles/automation/ms-dos/ms-dos-copy-folders-without-overwriting-files.html

23 February 2014 hard drive to an external one. I wanted it to copy only the files that were new in the original folder and only copy those over (reason being, the archive is 4 terabytes and backing up only the changed files would speed things up). Applies to: Microsoft...

• Type: Article
• Author: Joel Lipman
• Category: MS-DOS
• 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 any 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...

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

Returning Oracle Stored Procedure Resultset in SSRShttps://joellipman.com/articles/microsoft/ssrs/returning-oracle-stored-procedure-resultset-in-ssrs.html

19 January 2012 Services v2008 R2 (SSRS) Oracle SQL Developer v3 (you can use any equivalent, eg. SQL*Plus) Why? I think this is one of those very rare occasions that Microsoft people can say "it's so much easier using a Microsoft product to work with another Microsoft...

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

DJI Phantom FC40 Paint-Job and AerialFreaks Cyclops FC40 Gimbal Upgradehttps://joellipman.com/articles/_other-misc/quadcopters/dji-phantom-fc40-paint-job-and-aerialfreaks-cyclops-fc40-gimbal-upgrade.html

04 September 2014 videos) Possibly my new facebook profile photo My old FC40 looking new(ish) Ok, still going with painting on a budget, yes those are permanent marker color-ins the chipped smaller propeller is stock Less on a budget, let's replace the FC40 gimbal...

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

Protecting your Joomla Administrator Sectionhttps://joellipman.com/articles/cms/joomla/protecting-your-joomla-administrator-section.html

23 October 2015 two methods I like and will work in tandem. They will not affect the standard visitors to your Joomla website (specifically those not interested in logging into the administrator section). Updated for Joomla 3.x but pretty much the same system as used...

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

ZohoCRM GetRelatedRecords INVALID_DATAhttps://joellipman.com/articles/crm/zoho/zohocrm-getrelatedrecords-invalid_data.html

30 January 2025 { // // cancel all related quotes // (...) // // cancel all related sales orders (including those that have been approved or converted) l_RelatedSOs = zoho.crm.getRelatedRecords("SalesOrders", "Deals", m_Deal.get("id"), 1, 200, m_IgnoreRestrictions);...

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

Terms & Conditionshttps://joellipman.com/static-items/terms-conditions.html

30 May 2009 'Joel Lipman .Com', 'I', 'myself', 'us' or 'we' refers to the owner of the website whose registered office is available to those who contact Joel Lipman .Com. The term 'you' refers to the user or viewer of our website. The use of this website is subject...

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

Disclaimerhttps://joellipman.com/static-items/disclaimer.html

30 May 2009 which are not under the control of Joel Lipman .Com. We have no control over the nature, content and availability of those sites. The inclusion of any links does not necessarily imply a recommendation or endorse the views expressed within them. Every...

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

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

31 May 2009 ban is necessary to be rid of the problems you cause. The following are a set of amendments to clarify the rules for those people who wish to nitpick: Amendment 1 - There are no excuses for breaking the rules. It doesn't matter if you were angry at the...

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

Database Error: Unable to connect to the database: Could not connect to MySQLhttps://joellipman.com/articles/database/mysql/database-error-unable-to-connect-to-the-database-could-not-connect-to-mysql.html

25 September 2009 was only 1 user (me). There are reports though that some people set up websites with NO 3rd-party items whatsoever... For those of you with this issue, I'd double-check your website host allows Joomla and if they don't, look for either an upgrade or a...

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

Community Builder in Joomla Vulnerabilityhttps://joellipman.com/articles/cms/joomla/community-builder-in-joomla-vulnerability.html

10 November 2009 . In fact, there are quite a few vulnerabilities my scanners have picked up on and so I'll be posting solutions for those who need to keep Community Builder as their user manager. There are several things I have picked up which I will go into more...

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

Change default order of weblinkshttps://joellipman.com/articles/cms/joomla/change-default-order-of-weblinks.html

15 November 2009 changes is a hard process to keep track of. Joomla 1.6.x Responding to a comment by J16 User (9 July 2011): As an update for those of us brave enough to use the upgraded CMS, I have looked into this and it would appear that Joomla! CMS have not changed...

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

Anti-Spam override for all submitted datahttps://joellipman.com/articles/cms/joomla/anti-spam-override-for-all-submitted-data.html

03 February 2010 the captcha wouldn't even match what you typed and what it displayed!!! I have written this article to be another one of those programmer's tweaks. This is quite a simple fix and I will hopefully be able to keep it simple for non-programmers. The tweak...

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

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

25 February 2010 all marketing, promotional material (can include fonts, images, word documents, etc) We can accept most formats except for those exclusive to the Apple Mac operating systems. Webspace Setup For JoelLipman.Com to do: Assess allocated server space -...

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

RokDownloads Manager does not list fileshttps://joellipman.com/articles/cms/joomla/rokdownloads-manager-does-not-list-files.html

28 October 2010 this isn't a problem for those that don't use RokDownloads. The other day, I logged in to upload some new files and manage some of my downloadable files... Only to find that the Rokdownloads manager would not list any of my files!?! I am in the middle...

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

SQL Queries for Statisticshttps://joellipman.com/articles/database/mysql/sql-queries-for-statistics.html

13 December 2010 0 if not logged in) and of course the Timestamp (DateTimeStamp). Here is a page of some MySQL queries I can do based on just those 5 columns: MediaWiki: number of unique guests, students and staff by month. Also associates a UserID to the wikimedia_user...

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

Merge the content of two similar tables in MySQLhttps://joellipman.com/articles/database/mysql/merge-the-content-of-two-similar-tables-in-mysql.html

11 January 2011 Note how I don't use the `id` columns of the tables as I'm quite content with just the two columns I requested. And for those of you that don't know, the alias "AS" is optional in MySQL (think it's optional for most SQL forms). I found that to add...

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

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

06 April 2011 midnight into the next day... But what system doesn't do this (no Microsoft jokes please)? The Solution Eureka! Or duh! for those that it's obvious to... Compare the two timestamps, if the "To date" is less than the "From date" then add 1 day to the...

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

Inserting incremental weeks in MySQLhttps://joellipman.com/articles/database/mysql/inserting-incremental-weeks-in-mysql.html

15 April 2011 Situation: I have a silly database table (not mine) storing CMIS Facility week numbers and their starting dates. For those of you unfamiliar with this system, the reason week numbers are different to normal people's week numbers is because these are...

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