Data Randomization Function in Oracle PL/SQLhttps://www.joellipman.com/articles/database/pl-sql/data-randomization-function-in-oracle-plsql.html

22 August 2012 The function intends to determine the data type and return data that is absolutely irrelevant to the original data but the same length and the same type of data. Why? The joy of working with the plethora of applications out there result in me using...

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

Vertically align an asterisk on a linehttps://www.joellipman.com/articles/web-development/css/vertically-align-an-asterisk-on-a-line.html

02 September 2012 So I have an unordered list of values (*, 1, 2, 3...) and for styling reasons I want the asterisk to be the same size as the numbers but not overlap any list item beneath it. By increasing the size of the asterisk, this often increases the line-height...

• Type: Article
• Author: Joel Lipman
• Category: Cascading Stylesheets
• Language: *

Three boxes, two roll over, one falls outhttps://www.joellipman.com/articles/web-development/css/three-boxes-two-roll-over-one-falls-out.html

21 January 2013 template called "yoo_sync". Some clever scripts (both mootools and jquery) using the equalize method to make div layers the same height, and in this case, the same width. It isn't so much a miscalculation of 100% divided by 3 that leaves 1 pixel left...

• Type: Article
• Author: Joel Lipman
• Category: Cascading Stylesheets
• Language: *

Fix Oracle Tnsping 3511 without Windows Registryhttps://www.joellipman.com/articles/database/pl-sql/fix-oracle-tnsping-3511-without-windows-registry.html

04 March 2013 policies: Need to run with elevated permissions which requires UAC prompt (despite being already logged in, this is the same user but re-prompted for credentials) Cannot run System Registry (not even DOS REG Query!!!) All oracle utilities and...

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

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

07 May 2013 '.$sql_keyword.',\'\'))) / LENGTH('.$sql_keyword.'))) AS relevance '); « Show Me » [Same file again and optional if your search opts to search archived articles] \plugins\search\content\content.php: Insert this between the if ($sArchived && $limit > 0){...

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

Split a row into multiple rows based on a column valuehttps://www.joellipman.com/articles/database/t-sql/split-a-row-into-multiple-rows-based-on-a-column-value.html

23 August 2013 (T-SQL) What? This is a quick article on how to split a single row into multipe rows based on the value of a column in the same table. Why? I have a table that has all the days of sickness of employees. This table contains, which employee, on what date,...

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

SSIS Script: convert UPPERCASE to Mixed-Case using TitleCasehttps://www.joellipman.com/articles/microsoft/ssis/ssis-script-convert-uppercase-to-mixed-case-using-titlecase.html

04 October 2013 has to be generic, it should only apply this to columns we specifically tick in a package and we should be able to use the same script in any package... eek! Either of the two following script examples can be included in an SSIS Script Task but this...

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

Regular Expression Basic Usage Exampleshttps://www.joellipman.com/articles/web-development/regular-expression-basic-usage-examples.html

28 October 2013 ahead of time. For example, the regular expression: ^(.*)\1$ matches a line consisting of two adjacent appearances of the same string. Escape Character Use the escape character '\' to search for a character that is normally treated as a metacharacter....

• Type: Article
• Author: Joel Lipman
• Category: Web-Development
• 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 the activity or layout) and click on Finish: Get yourself a developers' Google Android Maps API Key (not necessarily the same as Google API Key) and enter it as instructed: Change the Java file to open on your current location, find the...

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

Joes Search Module (JSM)https://www.joellipman.com/component/content/article/joes-search-module-jsm.html?catid=40

09 March 2015 not in an MVC structure but it has been tested on Joomla 2.5.28 and Joomla 3.3.1. It simply displays a search module form (same as the default install) only with the additional hidden fields: limit, search phrase (all, any, exact), ordering, and areas...

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

Protecting your Joomla Administrator Sectionhttps://www.joellipman.com/articles/cms/joomla/protecting-your-joomla-administrator-section.html

23 October 2015 (and all tabs) once done or this cookie will remain on the computer and will be readable by other users who access the same computer (this is irrespective of whether you have logged out of the CMS). Add an IP filter To include this method, ensure you...

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

Excel - Check a column for values found in another columnhttps://www.joellipman.com/articles/microsoft/excel/excel-check-a-column-for-values-found-in-another-column.html

14 February 2019 me how to search a column in an Excel file for values found in another column (in this example, on another worksheet in the same workbook). How? So for demonstration purposes, I'm using a new Excel file with two worksheets called "Sheet1" and "Sheet2"...

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

CSS Add Text to Breadcrumb Link with a Transitionhttps://www.joellipman.com/articles/web-development/css/css-add-text-to-breadcrumb-link-with-a-transition.html

18 May 2019 Specify a prefix with a word which is fully opaque */ ul.breadcrumb a:hover span:before { opacity:1; content: 'More '; } /* Same as above but different prefix for this particular link */ ul.breadcrumb a.home:hover span:before { opacity:1; content:...

• Type: Article
• Author: Joel Lipman
• Category: Cascading Stylesheets
• Language: *

Zoho Deluge - Determine Quarter from Date with Fiscal Yearhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-determine-quarter-from-date-with-fiscal-year.html

31 January 2020 :: Quarter: 1 Month: October :: Quarter: 1 Month: November :: Quarter: 2 Month: December :: Quarter: 2 And just to prove the same code snippet works for any month, let's use the same code but start in April: // let's say financial year starts in April...

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

Zoho CRM/Creator - Common Errors & Gotchashttps://www.joellipman.com/articles/crm/zoho/zoho-crm-creator-common-errors-gotchas.html

06 February 2020 = invokeurl [ url :v_DataEndpoint type :POST parameters:m_CreateRecord headers:m_Header ]; Solution: My endpoint was the same as a create/add record when it should be suffixed with the ID of the item to update: v_DataEndpoint =...

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

Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Bookshttps://www.joellipman.com/articles/crm/zoho/zoho-creator-download-uploaded-file-and-attach-to-sales-order-in-zoho-books.html

15 May 2020 attachment field In Zoho Creator, in the "Edit" mode, go to "Settings" Under "Users and Control" click on "Publish" On the same row as your report, click on "Get embed Code" (ensure this report is published) Get the Permalink and copy and paste this...

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

AutoHotkey: App GUI Listview to Rename Fileshttps://www.joellipman.com/articles/automation/autohotkey/autohotkey-app-gui-listview-to-rename-files.html

08 July 2020 the word EDIT and words containing an underscore (eg. 01_23) ; and then add an increment to the file name if a file with the same name exists. ; ; Date (v1.0): 8 July 2020 ; - Initial Release ; Date (v1.1): 10 August 2020 ; - Checks for duplicates done...

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

Zoho Creator: Set Up Custom Domain for Customer Portalhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-set-up-custom-domain-for-customer-portal.html

17 November 2020 saying "Domain Verified Successfully": There are other ways to verify your custom domain such as TXT, which I feel has the same difficulty level and equal number of steps as verifying by CNAME; or by uploading a HTML verify file which I tend to forget...

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

ZohoCRM: Process all records of a modulehttps://www.joellipman.com/articles/crm/zoho/zohocrm-process-all-records-of-a-module.html

24 August 2021 of looping through all the records of a module and processing these with the ability auto-resume without processing the same record twice. Why? Whether you have a few hundred records, or a few hundred thousand records, we sometimes want to write a...

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

Zoho CRM: Get Unique Values of a Text Fieldhttps://www.joellipman.com/articles/crm/zoho/zoho-crm-get-unique-values-of-a-field.html

08 October 2021 } ], "info": { "count": 200, "more_records": true } } Which isn't what I want because it has returned the same currency several times and thinks they're unique/distinct because the IDs of each quote record are different. Having spoken to Zoho and raised...

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