MySQL day of week ending on Fridayhttp://www.joellipman.com/articles/database/mysql/mysql-day-of-week-ending-on-friday.html

26 April 2012 didn't get me very far until I decided to write this article: DAYOFWEEK(myDate, 1) or WEEKDAY(mydate, 1) MySQL code for first and last day of week. Day of Week starting on Monday.

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

Trim in T-SQL and SSIShttp://www.joellipman.com/articles/microsoft/ssis/trim-in-t-sql-and-ssis.html

14 May 2013 Some methods of removing trailing spaces, tabs, carriage returns and line feeds (new lines). How? First in Transact-SQL: SELECT RTRIM( REPLACE( REPLACE( REPLACE( @myString, CHAR(9), ''), CHAR(10), ''), CHAR(13), '') ) -- CHAR(9) = Tab -- CHAR(10) = Line...

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

A for loop within a for loop in MS-DOShttp://www.joellipman.com/articles/automation/ms-dos/a-for-loop-within-a-for-loop-in-ms-dos.html

03 October 2013 FOR /F "tokens=2,3* delims=_" %%A IN ('DIR InitializingFile*') DO ECHO %%A -- yields: 123.csv 456.csv So that's our first loop, here's what the second loop should do: -- the following loops through a line and separates by period (.) FOR /F "tokens=1,2*...

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

Regular Expressions in SQLhttp://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 Problemhttp://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 Imagehttp://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 availablehttp://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) Downloadshttp://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 Parametershttp://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 JCommentsACLhttp://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: *