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

28 June 2011 program again in a month, maybe a year. My websites don't depend on real-time screenshots and the sites I link to don't generally change their website design everyday... It's 100% FREE Open Source, (well as long as you have your own internet connection)...

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

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

05 July 2011 World!')") Accessing WebPage Contents - HTML DOM To understand how to use Javascript to control a webpage, you need a general understanding of the HTML DOM. It is similar to a "map" or "heirarchy" of the Webpage, as shown here: *Image is from this...

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

SSRS Dropdown parameter cannot be blank!https://www.joellipman.com/articles/microsoft/ssrs/ssrs-dropdown-to-allow-blank-values.html

14 December 2011 AS ItemID FROM ExecutionLogStorage ) AS d1 ORDER BY d1.Name ASC Additional Modifications: For all Parameters: » General - Untick "allow blank value" and "allow null value" (so these checkboxes are empty). » Available Values - "Get values from a query" =...

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

How to change local folder for TFShttps://www.joellipman.com/articles/microsoft/tfs/how-to-change-local-folder-for-tfs.html

08 March 2012 So? Once installed, my BIDS install would continuously check-out files and store these in the home directory. I tried the general settings (Tools > Options) but to no avail. How? The way to change this was: Connect to your Team Foundation Server (for me...

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

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

08 October 2012 varchar(50); SET @mySearchString = 'dnya'; DECLARE MyCursor CURSOR FOR SELECT 'SELECT ' + COLUMN_NAME + ' COLLATE Latin1_General_CS_AS AS column1 FROM ' + (TABLE_SCHEMA + '.' + TABLE_NAME) + ' WHERE SOUNDEX(' + COLUMN_NAME + ')=SOUNDEX('''+...

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

T-SQL example of Case-Sensitive Soundexhttps://www.joellipman.com/articles/database/t-sql/t-sql-example-of-case-sensitive-soundex.html

10 October 2012 after the column that needs to be case-sensitive returned the correct results: SELECT DISTINCT StudentDetail COLLATE Latin1_General_CS_AS FROM StudentTable WHERE SOUNDEX(StudentDetail)=SOUNDEX('Data Not Yet Available') -- yields StudentDetail...

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

SSIS Convert a string into a datehttps://www.joellipman.com/articles/microsoft/ssis/ssis-convert-a-string-into-a-date.html

14 March 2013 Check: The problems here relate to when our datasource was a flat file connection. We had to change the Format under General to Ragged Right (I had been setting it to "fixed width" but then got problems with it not understanding the last two characters...

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

Transferring Apps (purchases) from iPhone 4s to 5s on a Windows PChttps://www.joellipman.com/articles/apple/ios/transferring-apps-purchases-from-iphone-4s-to-5s-on-a-windows-pc.html

03 November 2013 your old phone's iOS is fully updated. (I did this while the phone was NOT connected to the computer, ie via the Settings > General > Software > Update option) Right-click on your iTunes shortcut and select "Run as Administrator". Plug both phones into...

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

T-SQL: Parse an XML valuehttps://www.joellipman.com/articles/database/t-sql/t-sql-parse-an-xml-value.html

27 March 2014 in the column "Event_XML" value of the table "XML_EVENTS": 123456 Mr J JOEL LIPMAN MALE 1990-01-01 SUPER SUPPORT TEAM GENERAL DOGSBODY 2014-03-01 Y INSERT 2014-03-27 Extracting the Gender: We're going to extract the value in between the opening and...

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

SSIS: How to loop through multiple flat files as data sourceshttps://www.joellipman.com/articles/microsoft/ssis/ssis-how-to-loop-through-multiple-flat-files-as-data-sources.html

13 June 2014 container (or drag into the container if it already exists) Edit the ForEach Loop Container (or double-click on it) Under General, give it a reasonable name of your choice Under Collection, select as Enumerator the "Foreach File Enumerator" Select the...

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

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

23 October 2015 see that my administrator url is accessed more than my front-end. The below has worked for me on Joomla websites in general and prevents the administrator URL showing up at all in the stats (unless you were using it). Leaving this unchecked means that...

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

Foreign Characters create symbols in PHP and MySQLhttps://www.joellipman.com/articles/web-development/php/foreign-characters-create-symbols-in-php-and-mysql.html

25 January 2016 // add the following to your header This does nothing: // set the collation of the database and any text fields to 'utf8-general-ci' ALTER DATABASE db_name CHARACTER SET latin1 COLLATE utf8-general-ci; // set text fields to utf8 SET NAMES 'utf8'; This...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB

Zoho CRM/Creator - Common Errors & Gotchashttps://www.joellipman.com/articles/crm/zoho/zoho-crm-creator-common-errors-gotchas.html

06 February 2020 A quick article on how to debug some errors in Zoho. Why? I wanted a general note to list certain errors that we get when we do certain things in Zoho but didn't want to write a separate page for each minor issue. How? So I'm going to try and list...

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

AutoHotkey: Get Media Information and Displayhttps://www.joellipman.com/articles/automation/autohotkey/autohotkey-get-media-information-and-display.html

07 August 2020 an app for use in MS Windows 7 to display the properties of sound files though this is also applicable to media files in general. How? So first I'm going to list a function I use called "Filexpro()", then list some examples of usage. And in the...

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

Zoho Deluge: Generate List of TimeZoneshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-generate-list-of-timezones.html

19 October 2021 Indian/Mayotte Indian/Reunion Iran Israel Jamaica Japan Kwajalein Libya MET MST7MDT Mexico/BajaNorte Mexico/BajaSur Mexico/General NZ NZ-CHAT Navajo PRC PST8PDT Pacific/Apia Pacific/Auckland Pacific/Bougainville Pacific/Chatham Pacific/Chuuk...

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

Zoho Creator: Radio group into Calendar Carouselhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-radio-group-into-calendar-carousel.html

09 March 2022 .choice-table-cell span label:nth-child(3){cursor:pointer;} Then I formatted the color of the text and set the general text font to be applied overall / included tweak to width so "Wednesday" will not wrap: div.zc-Calendar_Day_Select .choice-table-cell...

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

ZohoBooks: Error Code 15: Ensure Billing Address has less than 100 charactershttps://www.joellipman.com/articles/crm/zoho/zohobooks-code-15-ensure-billing-address-has-less-than-100-characters.html

18 September 2023 } } } Source(s): Zoho Books Documentation / Update Billing Address Zoho Community / Zoho Inventory / General / Error: Please ensure that the billing_address has less than 100 characters

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

Changing the yourdomain.com for phpBB3https://www.joellipman.com/articles/cms/joomla/changing-the-yourdomaincom-for-phpbb3.html

01 October 2009 of renaming yourdomain.com as your title page in phpBB3. You need to login to the phpBB admin control panel (ACP). On the General tab, look under Board Configuration and click on 'Board Settings'. The Site name is the first field in the right panel.

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

Code Troubleshooting Checklisthttps://www.joellipman.com/articles/web-development/code-troubleshooting-checklist.html

03 June 2011 can derive from that ("working backward") If the problem is abstract, try examining a concrete example. Try solving a more general problem first.

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