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

03 April 2009 object code with such an offer, in accord with subsection 6b. d) Convey the object code by offering access from a designated place (gratis or for a charge), and offer equivalent access to the Corresponding Source in the same way through the same place...

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

Room with a view E.M. Forsterhttps://joellipman.com/articles/_other-misc/room-with-a-view-em-forster.html

04 February 2011 share some thoughts I was reminiscing of: "We cast a shadow on something wherever we stand, and it is no good moving from place to place to save things; because the shadow always follows. Choose a place where you won't do harm--yes, choose a place where...

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

SSIS Script: convert UPPERCASE to Mixed-Case using TitleCasehttps://joellipman.com/articles/microsoft/ssis/ssis-script-convert-uppercase-to-mixed-case-using-titlecase.html

04 October 2013 foreach (string myValue in exceptionArray_this) { if (ValueToConvert.Contains(myValue)) { ValueToConvert = ValueToConvert.Replace(myValue, myValue.ToLower()); } } // tranformation exceptions: words to be UPPERCASED // note the first letter case and...

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

ZCRM Client Script: Correct Decimal Fields OnLoadhttps://joellipman.com/articles/crm/zoho/zcrm-client-script-correct-decimal-fields-onload.html

13 December 2023 This is an article detailing the client script to fix any fields which exceed their decimal places limit in ZohoCRM. Why? So we have a customer that has some decimal fields on the products module that are calculated and will sometimes return numbers...

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

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

31 May 2009 This is worse than flaming, because it also hurts other members of the board who fall into the catagory you insult. TEU is a place where everyone is equal, and discrimination will NOT be tolerated! No Bullying - Do not pick on other members. The worst...

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

Keyboard and mouse shortcuts in Google Chromehttps://joellipman.com/articles/google/keyboard-and-mouse-shortcuts-in-google-chrome.html

23 September 2009 Type a URL, then press Alt+Enter. Opens the URL in a new tab. F6 or Ctrl+L or Alt+D Highlights the URL. Ctrl+K or Ctrl+E Places a '?' in the address bar. Type a search term after the question mark to perform a search using your default search engine....

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

SQL Calendar in Business Intelligence Development Studiohttps://joellipman.com/articles/database/t-sql/sql-calendar-in-business-intelligence-development-studio.html

14 January 2011 SELECT DATEADD(DAY, 1, [Date]) FROM Dates WHERE Date...

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

Room Availability Calendar in Business Intelligence Development Studiohttps://joellipman.com/articles/microsoft/ssrs/room-availability-calendar-in-business-intelligence-development-studio.html

23 March 2011 SELECT DATEADD(MI, 30, [Time]) FROM Times WHERE Time...

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

Developer's Checklist: Taking over a projecthttps://joellipman.com/articles/web-development/developers-checklist-taking-over-a-project.html

01 March 2011 and still after 2 years there is no new site (blamed on the customer for not knowing what their application did in the first place... tut tut. How long have you been a developer? And this is new?). Can the developer be contacted? Yes! Questions to ask...

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

Zoho Books: Estimates/Quotes: Accept & Decline Buttons on Templatehttps://joellipman.com/articles/crm/zoho/zoho-books-estimates-quotes-accept-decline-buttons-on-template.html

04 November 2024 to be checked at the webhook endpoint would be good as well; but I couldn't spend time finding fields that can be 'placeheld', other than what the interface offers, into the template. the CRM webhook API function So let's do my favorite method of...

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

GDPR Privacy Policyhttps://joellipman.com/static-items/gdpr-privacy-policy.html

14 February 2019 committed to ensuring that your information is secure. In order to prevent unauthorized access or disclosure, we have put in place suitable physical, electronic, and managerial procedures to safeguard and secure the information we collect online. How we...

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

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

30 May 2009 or the information, products, services, or related graphics contained on the website for any purpose. Any reliance you place on such information is therefore strictly at your own risk. In no event will we be liable for any loss or damage including...

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

Privacy Policyhttps://joellipman.com/static-items/privacy-policy.html

30 May 2009 committed to ensuring that your information is secure. In order to prevent unauthorised access or disclosure we have put in place suitable physical, electronic and managerial procedures to safeguard and secure the information we collect online. How we...

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

Tagliatelle alla Carbonarahttps://joellipman.com/articles/_other-misc/tagliatelle-alla-carbonara.html

07 July 2009 allow to melt, then add the wine and simmer for 2-3 minutes, just to combine with the butter and the prosciutto juices. 3. Place the egg yolks, parmesan and pecorino into a bowl and season, to taste, with salt and freshly ground black pepper. 4. Cook...

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

Sun-Dried Tomato Basil Couscous Recipehttps://joellipman.com/articles/_other-misc/sun-dried-tomato-basil-couscous-recipe.html

03 September 2009 virgin olive oil Salt and freshly ground black pepper to taste Preparation: Heat water to boiling and stir in garlic powder. Place couscous in a large heat-proof bowl. Stir in garlic broth, cover, and let steam for 5 minutes until tender. Fluff with a...

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

Joes FREE Website Thumbnailer (JWT)https://joellipman.com/component/content/article/joes-free-website-thumbnailer.html?catid=40

28 June 2011 it's my years as IT support that push me to make software self-analyze in order to reduce support calls in the first place. Question How do I ask a question here? Answer: Just post a comment, anonymously or as a member, at the bottom of this article....

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

Before and After, Highs and Lowshttps://joellipman.com/articles/microsoft/ssrs/before-and-after-highs-and-lows.html

03 August 2011 a way. Or is time always on that dimension? HAVING is pointless, WITH ROLLUP is interesting, think I'm looking in the wrong place. Using Aggregate Functions? What follows is the T-SQL Query I finally went with. Lots of numbers but I think this pretty...

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

Inline Labels in Form Fields using Javascripthttps://joellipman.com/articles/web-development/js/inline-labels-in-form-fields-using-javascript.html

21 August 2012 spaces with nothing Examples: -- If field is "Joes Just Joking!" yields "JoesJustJoking!" -- If field is " Space is a big place " yields "Spaceisabigplace" Reminder: -- We're using this for a comparison condition and not trying to change the value.

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

Search a database for a string (MySQL, T-SQL)https://joellipman.com/articles/database/search-a-database-for-a-string-mysql-t-sql.html

08 October 2012 I've posted my own as well as some others I've lifted from elsewhere, as they worked with my environment, to put them in one place on a website I've bookmarked (my personal site :c) My own with Typos Note that the below only prints out the SQL query to...

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

Battery Constantly Drained on iPhonehttps://joellipman.com/articles/apple/battery-constantly-drained-on-iphone.html

27 November 2012 notice but I think this is a brilliant example where trying to fix the problem is the very cause of the problem in the first place: The empty arrow next to the battery indicator tells you that location services is enabled but it is attached to a...

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