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

19 January 2012 OR REPLACE PROCEDURE sp_get_studentdetails_from_ad ( p_STUDENT_ADNAME IN varchar2, l_CURSOR OUT sys_refcursor ) IS BEGIN -- going to declare variables that are to be returned in SSRS but not -- mentioned in the above OUT variables: DECLARE p_STUDENT_REF...

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

The Mermaidhttps://www.joellipman.com/articles/_other-misc/the-mermaid.html

24 July 2012 below, below, below, And the land lubbers lying down below. (Can you hear the ship, the little cabin boy and the captain going down to the bottom of the sea, the sea, the sea?)

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

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

20 August 2012 to template providers who disallow access to their support forums after the subscription period expires are on the rise. I'm going to annoy them all by posting solutions here: for Joomla 1.6.x - 2.5.x: Out-of-the-box template: -- add subfolder if this...

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

Inline Labels in Form Fields using Javascripthttps://www.joellipman.com/articles/web-development/js/inline-labels-in-form-fields-using-javascript.html

21 August 2012 have used since my fad of JavaScript 1.2 in the 90s. For broader compatibility, this is my recommended solution. How? We're going to use the onBlur and onFocus attributes which do, as the name indicates, trigger events when the cursor is either in the...

• Type: Article
• Author: Joel Lipman
• Category: JavaScript
• 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 boundary 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...

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

Search a database with SOUNDEXhttps://www.joellipman.com/articles/database/search-a-database-with-soundex.html

11 October 2012 case-sensitive, I need to add "COLLATE Latin1_General_CS_AS" after the column this affects. More collations can be found by going to MSDN's SQL Server Collation Name page. Limitations Trailing spaces or prefixing spaces are not obvious in the results,...

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

Sync Outlook 2007 Shared Calendar with SharePoint 2007https://www.joellipman.com/articles/microsoft/sharepoint/sync-outlook-2007-shared-calendar-with-sharepoint-2007.html

09 November 2012 I misunderstood what was going to happen when I started this. We have a SharePoint 2007 site and we have been asked to migrate links and calendar from an existing system. I was worried when following other instructions because I thought my personal...

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

Adding a selectable background to a Yootheme templatehttps://www.joellipman.com/articles/cms/joomla/adding-a-selectable-background-to-a-yootheme-template.html

19 November 2012 how to make this an option that your client can switch off/on using the Joomla Admin Panel. How? For demo purposes, I'm going to add the background "Ambient Turquoise". Yootheme uses CSS files to do this so we'll need to modify the XML file and add some...

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

Upgrading a Joomla 1.5 module to Joomla 2.5https://www.joellipman.com/articles/cms/joomla/upgrade-a-joomla-1-5-module-to-joomla-1-6.html

11 February 2011 but you replace the name "moduletoupgrade" with whatever you're upgrading and follow the below instructions. I'm also going on the basis tha. Basic Checklist Download all J1.5 files to one folder: /modules/mod_moduletoupgrade/mod_moduletoupgrade.xml...

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

Administrator Program Shortcut without Prompthttps://www.joellipman.com/articles/microsoft/windows-os/administrator-program-shortcut-without-prompt.html

25 February 2013 same account as we're currently logged-in with???) instead of being able to just click on "Yes". How? The gist is that we're going to create a scheduled task (that won't be scheduled) and a shortcut to that task: Open the Task Scheduler (Start > Run......

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

Improve Default Joomla Search https://www.joellipman.com/articles/cms/joomla/improve-default-joomla-search-heuristics.html

07 May 2013 search results by giving priority to articles where the search term is in the article title. In the stages thereafter, I'm going to simply enhance the relevance factor: Soundex: Built-in function to list matches that sound like the search term....

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

T-SQL concatenate an incremental row numberhttps://www.joellipman.com/articles/database/t-sql/t-sql-concatenate-an-incremental-row-number.html

24 May 2013 001 00101 001 00101 Almost useful... but the qualification reference has to be unique. We're going to add the ROW_NUMBER() to the employee number to create a unique identifier. Try this: SELECT q.Employee AS EmployeeNo, RIGHT('000' + CAST(q.Employee AS...

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

Creating a custom form field type for Joomla XML fieldsethttps://www.joellipman.com/articles/cms/joomla/creating-a-custom-form-field-type-for-joomla-xml-fieldset.html

25 October 2013 clear button for Joomla article selection. How? We have to create a custom form field type. In the following example, I'm going to create a dropdown which selects all projects associated with a particular user. Method #1: Important! It took me two days...

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

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

11 November 2013 points to different servers based on a report parameter. How? There are various types 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...

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

Client Services: Website Development Agreementhttps://www.joellipman.com/static-items/client-services-website-development-agreement.html

15 November 2013 available for download 24/7 so in the event that we lose contact with each other, the project manager has the option of going to another developer with the source files in order to continue the work. JoelLipman.Com will produce a signed-off production...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

MS-DOS: Copy folders without overwriting fileshttps://www.joellipman.com/articles/automation/ms-dos/ms-dos-copy-folders-without-overwriting-files.html

23 February 2014 Windows XP Microsoft Windows 7 Microsoft Windows 8 for Vista and Windows 2008 without XCOPY, try ROBOCOPY. How? We're going to use MS-DOS because I'm that old. Robust File Copy: Open a command prompt (Start > Run... > CMD > ok) Type the following:...

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

ReCaptcha alternative: Integrate PlayThru in JComments 2.3 for Joomla 2.5https://www.joellipman.com/articles/cms/joomla/recaptcha-alternative-integrate-playthru-in-jcomments-for-joomla.html

24 March 2014 is a follow-up of my article JComments 2.3.0 with Google ReCaptcha (Joomla 2.5.x) but instead of using ReCaptcha, we're going to use an alternative called PlayThru by AreYouAHuman.Com. Why? The kCaptcha used by the jComments extension is easily...

• 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 JOEL LIPMAN MALE 1990-01-01 SUPER SUPPORT TEAM GENERAL DOGSBODY 2014-03-01 Y INSERT 2014-03-27 Extracting the Gender: We're going to extract the value in between the opening and closing XML tags: -- Using .query() SELECT CAST(CAST(Event_XML AS...

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

301 Redirect using htaccess filehttps://www.joellipman.com/articles/web-development/301-redirect-using-htaccess-file.html

03 April 2014 and true to form Google have removed it. Not sure why nobody believed me when I raised the alarm but hey-ho. How? I'm going to show you how to do this with a .htaccess file: Upload a text file to the root folder of the old domain's website Rename it as...

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

mysqldump: Got error: 2049: Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure_auth' enabled) when trying to connecthttps://www.joellipman.com/articles/database/mysql/mysqldump-got-error-2049-connection-using-old-pre-4-1-1-authentication-protocol-refused-client-option-secure-auth-enabled-when-trying-to-connect.html

28 July 2014 system to a service user account... Especially one used by the scripts to access the database-driven website. How? I'm first going to highlight 2 methods which I found on the web and can be applied if you work somewhere that doesn't care about testing,...

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