Regular Expressions in SQLhttps://www.joellipman.com/articles/database/regular-expressions-in-sql.html

09 January 2014 -- REGEXP_SUBSTR('oracle', 'o r a c l e', 1, 1, 'x') Microsoft T-SQL Note the circumflex/hat to negate the expression in the first example, and then the use of NOT LIKE in the second example: SELECT * FROM [STUDENTS] WHERE [S_SURNAME] LIKE...

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

SSRS Border Problemhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-border-problem.html

20 January 2014 border to some cells and sometimes a whole section of the report with just one border??? How? In Design view, click on the first cell (top-left), hold down the shift key and click on the last cell (bottom-right). This selects all cells. Now open the...

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

SSRS Change Background Color of Imagehttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-change-background-color-of-image.html

08 April 2014 types of results: Success, Failure, Unknown. My images are circles with the background being transparent. I want the first column to display an image based on the status result. If I simply insert an image, the report would use the background color of...

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

SITS: XET format for Export not availablehttps://www.joellipman.com/articles/web-development/xml/sits-xet-format-for-export-not-available.html

08 August 2014 How? I had this in my training environment but not in my development environment. I had to create a Data Exchange Format first: Run the DEF from the menu Clear and create a new one based on the following: Now you can go and retrieve a student/staff...

• Type: Article
• Author: Joel Lipman
• Category: Extensible Markup Language
• Language: *

Joes Transmission Detector (JTD) Downloadshttps://www.joellipman.com/component/content/article/joes-transmission-detector-jtd-downloads.html?catid=92

07 September 2015 minimize - Background made transparent - Added received/sent data graph progress bars - Listview rolls messages (deletes first one and adds to last) - Date Uploaded: Thu, 29th Sep 2011 Download

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

Zoho Deluge: Convert Map to URL Parametershttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-convert-map-to-url-parameters.html

09 March 2020 article on converting a Map (associative array with keys and values) into a URL string to pass as URL parameters. How? Let's first define a map: m_Payload = Map(); m_Payload.put("client_id","my-unique-client-id");...

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

JComments errors in PHP 7: plgContentJComments and JCommentsACLhttps://www.joellipman.com/articles/cms/joomla/jcomments-errors-in-php-7.html

13 March 2020 would return errors when using PHP version 7. This is a quick article to document what needed doing to fix the errors. How? First some errors: ERROR: plgContentJComments Deprecated: Methods with the same name as their class will not be constructors in a...

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