Joes Syntax Styler (JSS)https://www.joellipman.com/component/content/article/joes-syntax-styler-jss.html?catid=40

06 April 2013 parameters have no effect. It was initially built for someone as a quick syntax highlighter that recognizes SQL; but I am working on getting it to recognize more programming languages so that I can use it on my own site. Limitations Recognizes SQL only...

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

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

14 May 2013 AND ref.[RefSheet] = 'myPayrollCategory' AND ref.[RefSystem] = 'myPayrollSystem' -- Yields "Conversion failed..." Working version: -- Corrected query (output values enclosed in apostrophes) SELECT CASE WHEN emp.ContributionValue=1 THEN '5010' WHEN...

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

Reorder Columns in a Tablehttps://www.joellipman.com/articles/database/reorder-columns-in-a-table.html

22 July 2013 Though maybe this is derived from a template and depending on if you are using MS Internet Explorer... Can't get it working? I use whatever is most useful and Google's Chrome is the fastest browser I have. Here are some ways to do this: Method: MySQL...

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

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

11 November 2013 of data sources used in SSRS so I'm going to try and cover the ones I have used previously and what we needed to get them working. Custom DataSource Upload the report to the ReportServer. Hover the mouse cursor over it and click on the dropdown arrow to...

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

ReCaptcha disappears from Joomla 2.5 Registrationhttps://www.joellipman.com/articles/cms/joomla/recaptcha-disappears-from-joomla-2-5-registration.html

24 November 2013 window.onload = function() { Recaptcha.focus_response_field(); } '; } Additional This applies to a case where the code WAS working and without any changes to the server (no updates), and the recaptcha simply stopped displaying. Public Key and Private...

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

SSRS: Performance Improvements: SELECT TOPhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-performance-improvements-select-top.html

07 March 2014 search for "SMITH" as a surname would make the report spin for about 10 minutes without the possibility to cancel (link not working!?) and eventually would display circa 3000 matching results. If I attempted to check this in "preview" mode using...

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

JComments 2.3.0 with ReCaptcha in Joomla 2.5.xhttps://www.joellipman.com/articles/cms/joomla/jcomments-2-3-0-with-recaptcha-in-joomla-2-5-x.html

20 March 2014 that may get moved/deleted, I've copied most of it and put it here with my minor revisions/adjustments to get it actually working. STEP #1: Check ReCaptcha API Check your recaptcha plugin is up-to-date as some Joomla 2.5.x systems will not have updated...

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

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

27 March 2014 find so I've posted an article below detailing how to parse or extract values from a string containing XML code. Why? I'm working with a system which stores XML strings in a database and rather than a separate file, it stores these in a row. How?...

• 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 to be used as source data have the same number of columns and where the column widths match. How? I've adapted my real working product with an example. As my work was for a Personnel/HR project, and data confidentiality is somewhat important, some of...

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

List of Font Awesomehttps://www.joellipman.com/articles/web-development/list-of-font-awesome.html

04 September 2015 I needed to use these in a template I was working on. Font awesome is a brilliant tool for webdevelopers who want icons that can be any size of any color without compromising on image quality or overhead maintenance. It's basically a font set that has...

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

Joes Youtube Plugin (JYP) Downloadshttps://www.joellipman.com/component/content/article/joes-youtube-plugin-jyp-downloads.html?catid=92

07 September 2015 Uploaded: Wed, 16th Feb 2011 1.0.1- Removed all unnecessary code - Date Uploaded: Wed, 16th Feb 2011 1.0.0- Shock as its working - Date Uploaded: Wed, 16th Feb 2011

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

Add default to a picture buttonhttps://www.joellipman.com/articles/automation/autohotkey/add-default-to-a-picture-button.html

10 November 2009 events to emulate the mouseover and mouseout effects of a button with an image as a background. I couldn't get any of these working and they looked more confusing then anything else. My solution is to set up the default button and the image to respond...

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

Thank You for your donation!https://www.joellipman.com/thank-you-for-your-donation.html

08 August 2010 any Joomla! material but has many Content Management Systems (CMS) commercial equivalents. I use any donations to justify working on Joomla! specifically; but like to add things I learn along the way :c) Kind Regards, Joel Lipman

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

Accessing Apimo WebService APIhttps://www.joellipman.com/articles/automation/api-misc/accessing-apimo-webservice-api.html

29 March 2016 belonging to a company then 2) getting the properties for each agency: Other Methods Here's the cURL I couldn't get working. Instead I used Apimo's documentation with file_get_contents. Just storing this in case. // cURL With SSL via method GET: FAIL...

• Type: Article
• Author: Joel Lipman
• Category: API Miscellaneous
• Language: *

Convert foreign characters to English alphabethttps://www.joellipman.com/articles/database/mysql/convert-foreign-characters-to-english-alphabet.html

13 June 2016 all the accents from foreign characters and return the English equivalent. Why? A content management system (CMS) that I'm working on has just gone international and started including the names of places in other countries. This is nice but its search...

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

Pure JS - Display Time Elapsed & Remaininghttps://www.joellipman.com/articles/web-development/js/pure-js-display-time-elapsed-remaining.html

30 October 2018 left before another access token will be generated and how long ago was the last token created. How? So almost pure JS. I'm working out the seconds remaining and seconds elapsed in PHP first then passing these as two variables to the below code but you...

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

Zoho Deluge: Loop through 30 Minute Slotshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-loop-through-list.html

30 November 2018 Why? I want to modify a picklist and fill it with options from a certain time of the day to the closing time of the day (working hours). How? The plan is to iterate through a 24-hour clock, enable adding to the picklist when the starting hour is found...

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

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

22 February 2019 preview. Why? Ok doesn't need a song and dance about it, but I went home yesterday downtrodden by an issue which I'd been working on for most of the day where I would remove all the styling and the text would still appear small. Sure I resized the text...

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

CSS Add Text to Breadcrumb Link with a Transitionhttps://www.joellipman.com/articles/web-development/css/css-add-text-to-breadcrumb-link-with-a-transition.html

18 May 2019 this only deals with the opacity transition as the width transition is not a smooth one. If anyone has a tried and working solution to the width transition then feel free to comment/message me (please test before sending it to me as I'm aware of width...

• Type: Article
• Author: Joel Lipman
• Category: Cascading Stylesheets
• Language: *

Zoho Deluge - Some Useful Regular Expressionshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-some-useful-regular-expressions.html

31 May 2019 in returned JSON (invalid in Zoho): v_MyString = "{"MyKey":"MyValue "}"; // the long way (and cos the regex for this isn't working) v_FormattedString = v_MyString.replaceAll("\r","",false); // carriage returns v_FormattedString =...

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