T-SQL Record Separatorhttps://www.joellipman.com/articles/database/t-sql/t-sql-record-separator.html

11 October 2011 t0 WHERE [pretendField]='elephantastic' -- end your original SQL query here (note no "order by" allowed -- refer to 6th line of this query for order by) ) AS t1 ) -- Query that will display extracted data SELECT t2.*, CASE WHEN t2.Day=t3.Day THEN NULL...

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

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

11 January 2013 existence of those rows is stored in another table, how do we delete from all the related tables as well? How? You need to refer to the tables just after the DELETE clause (so instead of DELETE FROM myTable WHERE myValue=givenValue): DELETE s, ssf, sst...

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

JDatabase: using the Joomla database with exampleshttps://www.joellipman.com/articles/cms/joomla/jdatabase-using-the-joomla-database.html

27 January 2013 another article on how to access the Joomla Database using the Joomla classes but this is just a quick note for myself as a reference sheet. Plus the official documentation don't have enough examples in my view. Source: http://docs.joomla.org/ for...

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

Migrating from Joomla 2.5.x to 3.4.xhttps://www.joellipman.com/articles/cms/joomla/migrating-from-joomla-2-5-x-to-3-4-x.html

12 September 2015 with upgrading a Joomla! CMS and running MySQL statements against your database. For the purposes of this article, we will refer to the live/current/production website running Joomla v2.5 as "v25" and the new Joomla instance as "v34". Their respective...

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

Zoho Projects: Add a Time Log to an Issue using Delugehttps://www.joellipman.com/articles/crm/zoho/zoho-projects-add-a-time-log-to-an-issue-using-deluge.html

30 April 2021 a time against a project Task but this article is focused on getting this working against Project Issues. Also note, we will refer to Project Issues in this article, but in the backend code, Zoho refer to Issues as "Bugs". Why? At time of this article...

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

Hide Menu Item from Registered and Special https://www.joellipman.com/articles/cms/joomla/hide-menu-item-from-registered-and-special.html

06 September 2009 Hide Menu Item from Registered and Special Refer to this link if you want to clean out a front-end admin interface with your website's style. The following is from http://forum.joomla.org/viewtopic.php?f=32&t=252258&start=0 at this date/time. Can't...

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

Mediawiki Extension for Camtasia Studio SWF videoshttps://www.joellipman.com/articles/cms/mediawiki/mediawiki-extension-for-camtasia-studio-swf-videos.html

08 October 2009 = "wfFlvPlayerExtension"; /* * The FlvPlayer class generates code that embeds a flash movie player * with reference to the uploaded movie. */ class FlvPlayer { /* Generate final code */ function render() { $this->url = $this->getViewPath($this->file);...

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

Project Plan for Freelance Websitehttps://www.joellipman.com/articles/web-development/project-plan-for-freelance-website.html

25 February 2010 date entered description owner status (open, in progress, closed)? solution date resolved Errors List Clear error logs Refer to list of all pages and run each one Download new error logs Correct and prevent Close-Out Meeting Project Closure Review...

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

Creating a Profile Plugin for Joomla 1.6https://www.joellipman.com/articles/cms/joomla/creating-a-profile-plugin-for-joomla-16.html

27 April 2011 blank "index.html" files into each of these folders in case "directory listing" gets enabled on your server.I'm going to refer to the files to create as being in this folder. ./profile5/profile5.php User - Profile - JoelLipman.Com Joel Lipman April 2011...

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

SSRS Retrieving Oracle Stored Procedure Success or ErrorLevelhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-retrieving-oracle-stored-procedure-success-or-errorlevel.html

04 November 2011 created to run the stored procedure. This requires using 2 data sources in SSRS. A user will specify the student reference in the parameters of the first report (the one with all the main details), as well as a job reference (for audit purposes) and...

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

Basic Oracle Function Structurehttps://www.joellipman.com/articles/database/pl-sql/basic-oracle-function-structure.html

15 January 2012 I need to refer to how to create a function in Oracle PL/SQL and sites on the net just attempt to overcomplicate everything and have forgotten how it is to be new to Oracle. I need a function in it's simplest form and if I want to torture my successors,...

• Type: Article
• Author: Joel Lipman
• Category: Oracle PL/SQL
• Language: en-GB

Prefix Line Numbers in a Text Filehttps://www.joellipman.com/articles/automation/ms-dos/prefix-line-numbers-to-a-text-file.html

18 July 2012 with programming languages, I often need to write the accompanying documentation. Within the documentation, I may want to refer to a line of code within a text file. I also find myself copying amounts of code into the same document and then needing...

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

Basic Joomla 2.5 Mootools Formhttps://www.joellipman.com/articles/cms/joomla/basic-joomla-25-mootools-form.html

20 August 2012 the default submit event from loading a new page. e.stop(); // Set the options of the form's Request handler. // ("this" refers to the $('myForm') element). this.set('send', { onComplete: function(response) { $('log').set('html', response); } }); //...

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

Joomla article modal with clear buttonhttps://www.joellipman.com/articles/cms/joomla/joomla-article-modal-with-clear-button.html

27 August 2012 ones, namely administrator\components\models\fields\modal\article.php and \libraries\joomla\form\fields\media.php. You then refer to it in your XML file where instead of type="sql" use type="modal_article". A usage example is: Just copy & paste the...

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

Slideshow div layer through a windowhttps://www.joellipman.com/articles/web-development/mootools/slideshow-div-layer-through-a-window.html

11 September 2012 of the parent div layer. Why? I'm making a slideshow from scratch. How? The idea is: Use two main div layers, I'm going to refer to them as "window_slide" and "inner_window". Slide divs to be added inside the "inner_window". Move the slides in from...

• Type: Article
• Author: Joel Lipman
• Category: MooTools Framework
• Language: *

Hide a Drive per User in Windows 7https://www.joellipman.com/articles/microsoft/windows-os/hide-a-drive-per-user-in-windows-7.html

28 March 2014 and name it NoDrives (or NoViewOnDrive). The value you enter for NoDrives depends on the drive(s) you want to restrict (Refer to the list above) CRITICAL STEP: Once you've saved this value, navigate back up to HKEY_USERS, select the Foo key you loaded,...

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: *

T-SQL functions to convert Strings to Tableshttps://www.joellipman.com/articles/database/t-sql/t-sql-functions-to-convert-strings-to-tables.html

20 August 2014 SQL Server 2008 R2 Microsoft SQL Server 2012 What? These were in a solution and I thought I'd note them on my site so I can refer to them more easily. How? Let's start with a function that just converts a string of words delimited by spaces to a table:...

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

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

21 August 2014 your XET Setting up the Stu-Talk Message Group (SMG) This should be done before continuing as the remaining screens will refer to this and allow you to specify the related SMG Run SMG from the menu system Enter a CODE (in our demo "CAPCHG") Enter a...

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

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

10 October 2014 CameraPosition 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) //...

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

Android: Keytool and Google Maps displaying greyhttps://www.joellipman.com/articles/google/androidos/android-keytool-and-google-maps-displaying-grey.html

31 October 2014 now added both to the console). [Optional] To use the keytool: If you know the command prompt, you know that you have to refer to each tool using their full path unless you add it to the PATH environment variable: This allows you to use keytool from any...

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