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

03 April 2009 applied to a free program could make it effectively proprietary. To prevent this, the GPL assures that patents cannot be used to render the program non-free. The precise terms and conditions for copying, distribution and modification follow. TERMS AND...

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

Connection Strings for SQL Serverhttp://mail.joellipman.com/articles/microsoft/sql-server/connection-strings-for-sql-server.html

05 January 2011 the driver to use named pipes network protocol. This is available on Windows only. The value is ignored if Unix socket is used. Multiple servers Use this to connect to a server in a replicated server configuration without concern on which server to use....

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

Migrate Joomla! 1.5.x to 2.5.x+http://mail.joellipman.com/articles/cms/joomla/migrating-from-joomla-15-to-16.html

30 January 2011 on each iteration so as to avoid session timeouts and memory issues. Edit the script, renaming the database and table names used (DO NOT CONFUSE THE FOLLOWING DATABASE NAMES OR YOU WILL END UP WITH NEITHER SITE WORKING!!!) Open the SQL file in your...

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

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

14 January 2011 was similar to an MS Outlook calendar which will display any room bookings for that month. This is "Reinventing" because we used to use MS Outlook to store these kind of things until the company implemented a software to deal with room bookings and said...

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

Parameters not being used in report processinghttp://mail.joellipman.com/articles/microsoft/ssrs/parameters-not-being-used-in-report-processing.html

07 January 2011 made no difference whatsoever. In case you've been stuck for ages (as I have), I found out you cannot declare the parameters used by the software within the SQL script... So the above should look more like this: --...

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

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

14 February 2019 and is protected by international copyright laws. Trade Marks JoelLipman.com's trademarks and trade dress may not be used in connection with any product or service that is not JoelLipman.com's, in any manner that is likely to cause confusion among...

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

Android: Keytool and Google Maps displaying greyhttp://mail.joellipman.com/articles/google/androidos/android-keytool-and-google-maps-displaying-grey.html

31 October 2014 to add the correct SHA1 to the Google APIs console for release purposes. This is the SHA1 from the certificate (*.jks) you used to upload the APK to the Google Play Developer Console. Finding the Certificate Fingerprint SHA1 of an existing keystore Open...

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

Zoho Creator: Public URL of an Image field / Upload to Shopify APIhttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-public-url-of-an-image-field-upload-to-shopify-api.html

17 October 2021 URL Syntax #4 The following won't work for the example below as it doesn't have the publish/public key, but it can be used internally: // DOESN'T WORK FOR ME!!! v_ImageSrc =...

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

Zoho Creator: Input Color Pickerhttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-input-color-picker.html

14 October 2024 be nice-to-have is if they could be presented with a bunch of colors and they click on one to select it. When are colors used? Well in this use-case, we are using it to color events in a calendar associated with specific staff. Probably not the most...

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

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

30 May 2009 certain information by which you can be identified when using this website, then you can be assured that it will only be used in accordance with this privacy statement. Joel Lipman .Com may change this policy from time to time by updating this page. You...

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

Add Image Mouseover effect in AutoHotkey GUIhttp://mail.joellipman.com/articles/automation/autohotkey/add-image-mouseover-effect-in-autohotkey-gui.html

25 January 2010 3000 return RemoveToolTip: SetTimer, RemoveToolTip, Off ToolTip return } Search: Return GuiClose: ExitApp The images I used in this GUI are: and . These have to be saved in the same folder as the AHK script. It took me a while to get the tooltip to show...

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

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

25 February 2010 Meeting For you to discuss: Aims / Objectives Deadlines / Milestones Target Audience (Internally Centered? / Customer Focused?) Outsources? (Is JoelLipman.Com Project Manager? other 3rd-parties?) Contacts within Client company? Budget (see Rates for...

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

Basic Webpage Controls with JavaScript / COMhttp://mail.joellipman.com/articles/automation/autohotkey/basic-webpage-controls-with-javascript-com.html

05 July 2011 in Black, AHK Basic in Green) - also, note Sean's post below. (Using COM requires Internet Explorer, but JavaScript can be used with most Web Browsers) The guidelines for "translating" JavaScript can be found in the first post of the COM Standard...

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

Problem creating SSRS report subscriptionshttp://mail.joellipman.com/articles/microsoft/ssrs/problem-creating-ssrs-report-subscriptions.html

11 November 2013 a warning message similar to the following: Message from webpage Subscriptions cannot be created because the credentials used to run the report are not stored, or if a linked report, the link is no longer valid. Why? The problem happens because of the...

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

XML Schema Referencehttp://mail.joellipman.com/articles/web-development/xml/xml-schema-reference.html

13 August 2014 the author to extend the XML document with attributes not specified by the schema appinfo Specifies information to be used by the application (must go inside annotation) attribute Defines an attribute attributeGroup Defines an attribute group to be used...

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

Zoho Creator: Retrieve record with case-insensitive queryhttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-retrieve-record-with-case-insensitive.html

21 November 2019 = v_Name.toLowerCase()];... Returns the error: "Expression is not allowed in left side of a Criteria". There used to be an old solution for doing this and can still be found in the community forums from a 7 year old post; but now you can apply a...

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

Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Signhttp://mail.joellipman.com/articles/crm/zoho/zoho-crm-zoho-sign-send-crm-merged-template-for-zoho-sign.html

06 August 2024 p_ContactID) Label: Fn - Contact - Send Credit Application Trigger: Off a button on the contact record Purpose: Function used by a button off the contact record to send a credit application form for signing via ZohoSign Inputs: Contact Record ID...

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

Zoho CRM: Updating a CRM record Custom Line Items using API v7http://mail.joellipman.com/articles/crm/zoho/zoho-crm-updating-a-crm-record-using-api-v7.html

18 December 2024 Function: void automation.fn_Quotes_OnEdit(int p_QuoteID) Label: Fn - Quotes - On Edit Trigger: Used in a workflow when a quote is modified Purpose: Actions when a quote is modified Inputs: int p_QuoteID - the ID of the CRM Quote Record Outputs: void...

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

Passwords: Did-you-knowhttp://mail.joellipman.com/hardware/passwords-did-you-know.html

15 November 2010 following is a list of items I use to include on password checker pages: A program called LC4 (formerly L0phtCrack) used by governments and the military boasts being able to crack 90% of user passwords in under 48 hours on a Pentium II/300....

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

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

13 December 2010 that I've been revising all my scripts to see what SQL I can optimize. One of my systems is a MediaWiki CMS which is used for the official Bournemouth University Knowledge Base. The skin itself is the index page loaded for any page in the Wiki system....

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