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

15 January 2012 FUNCTION fn_get_sref_from_adname (ad_username IN varchar2) RETURN number IS student_no number; cursor c1 is select student_reference from student_accounts_table where student_ad_account = trim(lower(ad_username)); BEGIN open c1; fetch c1 into...

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

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

19 January 2012 fields button Parameter name (oracle input sp variable) and Parameter value (ssrs input parameter) Fields (field name=ssrs reference, field source=oracle sp field name) 1. Create a stored procedure using a cursor for SSRS CREATE OR REPLACE PROCEDURE...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• 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 (Start > Run... > Type "COMMAND" > Enter) [Optional] Browse to the folder that contains the file (or use full path in path reference). This example assumes the file is in C drive (C:\). Create an empty text file (Type "ECHO > TEMP.TXT") Type "FC /N /LB...

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

DataJumble - Shuffling characters in a data valuehttps://www.joellipman.com/articles/database/t-sql/data-shuffling-function.html

01 August 2012 Precursor You will need to be able to create the following view to generate random numbers on SQL Server. -- Used to reference RAND with in a function CREATE VIEW dbo.vwRandom AS SELECT RAND() as RandomValue; GO The Function Again you need permission to...

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

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 is an input field for single line of text. name="name" - attribute that assigns a variable name to this field so we can reference it later. style="color:grey" - add a styling to it by default (on initial load), in this specific case the color grey....

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

DataScramble - Randomizing data rowshttps://www.joellipman.com/articles/database/t-sql/datascramble-randomizing-data-rows.html

07 December 2012 -- Drop the view if it already exists IF OBJECT_ID ('vwRandom', 'V') IS NOT NULL DROP VIEW vwRandom ; GO -- Used to reference RAND within a function CREATE VIEW vwRandom AS SELECT RAND() as RandomValue; GO The Function -- Drop the function if it already...

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

Joes Revolver Map (JRM)https://www.joellipman.com/component/content/article/joes-revolver-map-jrm.html?catid=40

07 December 2012 Visit the website http://revolvermaps.com/?target=setup Configure the map to the settings you want. Copy the ID reference as per the "Important Note" below. Login to your Joomla website admin panel Install this module as per usual (will auto-install) Go...

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

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

27 January 2013 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 v1.5.x and...

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

Preg_Replace all strings between two tagshttps://www.joellipman.com/articles/web-development/php/preg-replace-all-strings-between-two-tags.html

07 February 2013 understanding with regular expressions is shady and varies from language to language, I've written this article as a quick reference point. How? Well you use this in your PHP scripts, the examples below are meant to help but feel free to comment if they...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: *

T-SQL Conversion failed when converting the varchar to data type inthttps://www.joellipman.com/articles/database/t-sql/t-sql-conversion-failed-when-converting-the-varchar-to-data-type-int.html

14 May 2013 8475 3 Fred Director 7749 4 Bill Manager 0011 5 Another Tape-Monkey 8475 6 Joe Tape-Monkey 8475 Table: DMExtractReferenceTable ------------------------------ ID MapIn MapOut 1 0011 71 2 8475 84 3 7749 63 4 B110 92 -- so we have 1 director, 2 managers,...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• 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 EmployeeNo QualificationRef -------------------------------- 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:...

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

AHK Countdown Tooltiphttps://www.joellipman.com/articles/automation/autohotkey/ahk-countdown-tooltip.html

17 July 2014 Pictures\Win7_ScrSvr\BU_Core_CMYKportraitbigwithborder.jpg" ; Default Message reference ThisMessageIndex:=0 ;...

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

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 a Short Name (unsure of how this is used) Enter a descriptive "Full Name" as it will automatically display alongside any reference to the Message Group in the remaining screens. Check/ensure the "In Use?" is ticked. Store/save your SMG Setting up the...

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

Android: Function to let user take photo or choose existinghttps://www.joellipman.com/articles/google/androidos/android-function-to-let-user-take-photo-or-choose-existing.html

04 November 2014 I wanted both options to be available to the user and for it to replace a displayed image in an ImageView. How? More as a reference for myself but this displays an AlertDialog designed by an XML layout file ("res/layout/dialog_edititem_photo"). The...

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

Convert XML UTF-16 to JSON UTF-8 with PHP cURLhttps://www.joellipman.com/articles/web-development/php/convert-xml-utf-16-to-json-utf-8-with-php-curl.html

28 March 2015 all over the Internet as the accepted solution... Doesn't work for me because I'm using cURL but it's a first point of reference. This will work if the received XML is a string. // setting XML value $string = ' 2/13/2013 10:37:24 PM Failure Incorrect...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB

List of Font Awesomehttps://www.joellipman.com/articles/web-development/list-of-font-awesome.html

04 September 2015 want in a modern website design. How? To use this list, you can either: Copy the font files to your template folder (my preference) and add the linked stylesheet in the head section of your webpage. I'm selective of what icons I copy over but the full...

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

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 `urls`, `attribs`, `version`, `ordering`, `metakey`, `metadesc`, `access`, `hits`, `metadata`, `featured`, `language`, `xreference`) SELECT a.`id`, ( SELECT x.`id` FROM `v34_db`.`v34_assets` x WHERE x.`name` LIKE 'com_content.article.%' AND x.`name`...

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

AutoHotkey: Get Media Information and Displayhttps://www.joellipman.com/articles/automation/autohotkey/autohotkey-get-media-information-and-display.html

07 August 2020 Windows 7 Professional v6.1.7601 32-bit AutoHotkey v1.1.33.02 What? This is a copied article just to store a permanent reference for if I ever need to build an app similar to the file explorer in the Microsoft Windows OS. Why? I had an app for use in MS...

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

Zoho Creator: Create a Widget which uses JavaScripthttps://www.joellipman.com/articles/crm/zoho/zoho-creator-create-a-widget-which-uses-javascript.html

24 October 2020 between either Creator or CRM (as in pure HTML,CSS and JS). Files referring to Creator specifically: ./app/widget.html: reference to script src at https://js.zohostatic.com/creator/widgets/version/1.0/widgetsdk-min-js ./app/custom.js: my custom...

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

Zoho Creator: Button on Report for Merging Multiple Selected Recordshttps://www.joellipman.com/articles/crm/zoho/zoho-creator-button-on-report-for-merging-multiple-selected-records.html

06 December 2020 are sending (in my example here I have a form called "Partners Quote". Within your function you can use the following as a reference. In theory, you could loop through each submitted quote but I do a call at the beginning of each iteration of the loop...

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