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

09 March 2022 calendar carousel. In that a radio group displays the days of the week with arrows allowing the user to select the next or previous week. This is a follow on from my other articles on restyling Creator: Zoho Creator: Change Radio into Tabs and Zoho...

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

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

26 April 2012 It's an odd one but the example below shows how to do this for when the week ends on Friday. Assuming it starts on the previous Saturday. Why? Problems with MySQL weeks always starting on Sunday means this isn't very useful. I have another system which...

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

Restoring your WYSIWYG editor after upgrading Joomlahttps://joellipman.com/articles/cms/joomla/restoring-your-wysiwyg-editor-after-upgrading-joomla.html

15 September 2009 it's pretty amazing. Incredibly cross-browser compatible with some MS Office 2007 styling and fortunately maintains it's previous button layout. The features such as full-screen editing, emoticons, and pasting from MS Word documents make it the best in...

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

Installing phpBB3 for Joomla with a RocketTheme templatehttps://joellipman.com/articles/cms/joomla/installing-phpbb3-for-joomla-with-a-rockettheme-template.html

28 September 2009 module" button. Make sure "enabled" is selected in the radio buttons and click on the "Submit" button. Click on "Back to previous page" This will create a module category called ROKBB3 which you should click on to go into. In the bottom right, you can...

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

Windows 7 Aero Featureshttps://joellipman.com/articles/microsoft/windows-os/windows-7-aero-features.html

27 April 2010 windows. Keep holding the Microsoft Logo key and pressing the Tab key to rotate between the different windows. As with previous versions of MS Windows, holding down the Alt key and pressing Tab will give you the more traditional window switcher (2D)....

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

Error during processing - Converting Date/Timehttps://joellipman.com/articles/database/t-sql/error-during-processing-converting-datetime.html

13 July 2010 dataset DataSet1. Conversion failed when converting date and/or time from character string. Basically I had to look at a previous report and it was just the way I was inserting the parameters into my query. Once you've added your parameters (date/time...

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

Joes Quicklist Weblinks (JQW)https://joellipman.com/component/content/article/joes-quicklist-weblinks-jqw.html?catid=40

03 July 2011 or something like that. I have not got the upgrade server for J16 working yet but soon. Also there's no need to delete a previous version of this module, just download the updated one, and install as per usual. IMPORTANT NOTES: All images in the folder...

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

SSRS External Images don't displayhttps://joellipman.com/articles/microsoft/ssrs/ssrs-external-images-dont-display.html

19 September 2011 image if file does not exist More of a workaround than a solution but by asking some colleagues who developed the previous version (using 3rd-party components other than Microsoft SSRS) that the existence of a photo depended on the status of a student...

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

Performance Report - Background colors based on dataset valueshttps://joellipman.com/articles/microsoft/ssrs/green-red-background-colors-based-on-dataset-values.html

02 December 2011 would fail an accessibility test but visually it says straight away which is the better report; and when comparing to the previous runs (using a second dataset) you can tell where changes were made and how this affected the reports' performance. What?...

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

Returning Oracle Stored Procedure Resultset in SSRShttps://joellipman.com/articles/microsoft/ssrs/returning-oracle-stored-procedure-resultset-in-ssrs.html

19 January 2012 integration"). Yes, I'm trying to get an SSRS report to display the results from an Oracle stored procedure. I have a previous article describing a basic stored procedure in Oracle, this article aims to outline how to apply this to an SSRS 2008 R2...

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

MySQL: Display Users and Duration in Matrix Timesheethttps://joellipman.com/articles/database/mysql/mysql-display-users-and-duration-in-matrix-timesheet.html

27 April 2012 per week per user 3. Combine in a loop to run query against each user. Post-Notes (Update 2012) The performance of the previous version of this query was pretty abysmal and worse if you want to list users who have no associated activities (outer join...

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

Delete related records from multiple tableshttps://joellipman.com/articles/database/mysql/delete-related-records-from-multiple-tables.html

11 January 2013 refer to the table after the DELETE clause. Rather straightforward but I got this answer from StackOverflow. Based on the previous example, here's the query to only delete records in Session and SessionStudent represented by aliases s and sst...

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

Proposed Budget i3 PC under £200https://joellipman.com/hardware/proposed-budget-i3-pc-under-200.html

26 January 2013 System (in this case Microsoft Windows 7 Pro 32-bit) nor the chassis as we merely transferred the license from our previous machines.

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

Strip HTML in MySQLhttps://joellipman.com/articles/database/mysql/strip-html-in-mysql.html

06 December 2011 Why? We are preparing to migrate old content to a new system. From a MediaWiki CMS to a SaaS called Service-Now. The previous interlinking between images could no longer be used. How? There were a few functions out there. One called "strip_tags" crashed...

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

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

14 March 2013 "00000000" -- Derived column task 2: Add as new Column 'DC_Date' -- (note this is a separate task in the data flow to the previous one): (ISNULL(Date) || (TRIM(Date) == "00000000")) ? NULL(DT_DBTIMESTAMP) : (DT_DBTIMESTAMP)(SUBSTRING(Date,5,4) + "-" +...

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

Convert to Proper Case in T-SQLhttps://joellipman.com/articles/database/t-sql/convert-to-proper-case-in-t-sql.html

04 June 2014 any leading and trailing spaces SET @Ret = LTRIM(RTRIM(@Ret)); -- capitalize first character of data irrespective of previous rules SET @Ret = UPPER(SUBSTRING(@Ret,1,1)) + SUBSTRING(@Ret,2,LEN(@Ret)); END ELSE BEGIN -- return the string unaffected if it...

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

A quick run through of setting up an export process in SITShttps://joellipman.com/articles/web-development/xml/a-quick-run-through-of-setting-up-an-export-process-in-sits.html

21 August 2014 menu system Enter a EOR code (for everyone's sanity, name it something similar to the DOR code) Complete the form as per previous details ensuring you use the same Message Group as the DOR. In our example, our Type is "SQL db connector" and we use a...

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

DJI Phantom FC40 Paint-Job and AerialFreaks Cyclops FC40 Gimbal Upgradehttps://joellipman.com/articles/_other-misc/quadcopters/dji-phantom-fc40-paint-job-and-aerialfreaks-cyclops-fc40-gimbal-upgrade.html

04 September 2014 X4 H107C This model is the DJI Phantom FC40 so the first Phantom (v1.2?) with DJI's own FC40 camera It had had a bad crash previously and loosening some of the screws snapped the edges back into place. I thought why stop there? The anatomy of a DJI...

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

Basic Android App using Google Maps and Current Locationhttps://joellipman.com/articles/google/androidos/basic-android-app-using-google-maps-and-current-location.html

10 October 2014 cameraPosition = new CameraPosition.Builder() .target(myCoordinates) // Sets the center of the map to LatLng (refer to previous snippet) .zoom(17) // Sets the zoom .bearing(90) // Sets the orientation of the camera to east .tilt(30) // Sets the tilt of...

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

Quadcopter App with Flight Restrictions (JQA)https://joellipman.com/component/content/article/quadcopter-app.html?catid=40

24 October 2014 factory returns photos as well - [1.8.4] App: theme and style fixes - [1.8.4] App: code improvements - [1.8.3] App: fix to previous fix - [1.8.3] App: code improvements - [1.8.2] App: fix theme for certain devices - [1.8.1] Map: disabled if location...

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