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

22 August 2012 on a given value. 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...

• Type: Article
• Author: Joel Lipman
• Category: Oracle PL/SQL
• 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 red styling Convert: this='a string' » this='a string' $string_formatted = preg_replace ( '/\'([^\']+)\'/', '$0', $string_original ); Surround string (apostrophes) with red styling but ignore escaped apostrophes: Convert: this='joe\'s string' »...

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

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

11 October 2011 ROW_NUMBER() OVER (ORDER BY t1.Date ASC, t1.Start ASC, t1.Room ASC, t1.Finish ASC) as 'RowNumber' FROM ( -- start your original SQL query and save results as table t1 SELECT -- perform formatting to extract the minimum data here (eg. datetime into date,...

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

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

08 July 2020 it will name them. The app needs to rename files but append an incremented count if the name of a file already exists. The original file needs to keep its original name. What I have EDIT 0_00 0_30 My File 1 00_00 00_30.txt edIT 0_00 0_31 My File 2 00_00...

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

ZohoCRM: Import Attachmentshttps://www.joellipman.com/articles/crm/zoho/zohocrm-import-attachments.html

16 January 2023 ID) and column B contains the foreign key/id from the 3rd-party database. It then prompts for a folder containing the original files and will collapse any subfolders as well as rename the files to unique filenames. ; ; Language: English ; Platform:...

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

Joe's Unduplicater (JUD)https://www.joellipman.com/component/content/article/joes-unduplicater.html?catid=40

12 July 2010 and store these in another folder. I needed a program to: Check the final folder for all the MP3 filenames Check the original folder for the same filename (BUT NOT necessarily with the same extension) Delete the original file if I have the MP3 version...

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

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 of code into the same document and then needing lines prefixed so that I can explain the code. What? Change contents of "original_file.txt" The first line of my code The second line of my code The third line of my code To "results_file.txt" 1: The first...

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

Calculate Aspect Ratiohttps://www.joellipman.com/graphic-design/calculate-aspect-ratio.html

17 January 2019 an image. How? These are the calculations to work out the new height given the width or the new width given the height: (original height / original width) x new width = new height (original width / original height) x new height = new width

• Type: Article
• Author: Joel Lipman
• Category: Graphic Design
• Language: *

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

25 February 2010 Setup automated backup system. Create test space with same access details. Database Setup For JoelLipman.Com to do: Backup original database if exists already Assign unique database name Assign unique database username/password Add the user to the...

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

URL Alias uniqueness with PHP & MySQLhttps://www.joellipman.com/articles/web-development/php/url-alias-uniqueness-with-php-mysql.html

06 May 2019 incrementUrlAlias; DELIMITER | CREATE TRIGGER incrementUrlAlias BEFORE INSERT ON my_table_name FOR EACH ROW BEGIN declare original_url varchar(255); declare url_counter int; set original_url = new.url_alias; set url_counter = 1; while exists (select...

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

Applying a button and centering it in the RocketTheme Affinity templatehttps://www.joellipman.com/articles/cms/joomla/applying-a-button-and-centering-it-in-the-rockettheme-affinity-template.html

15 September 2009 more to do than just that. Instructions Open the templates/rt_affinity_j15/index.php Look at the last few lines with the original code (below) For this website template: I've added the module-dark classes. Specified float:none to get rid of float:left...

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

Migrate Joomla! 1.5.x to 2.5.x+https://www.joellipman.com/articles/cms/joomla/migrating-from-joomla-15-to-16.html

30 January 2011 -- -- References to J30 indicate a Joomla version 1.6.x or greater. -- REQUIRED: -- -- A minimum of 2 databases. The original and the one to migrate to. -- -- A login account (mysql user) with most privileges on BOTH databases. -- -- To change the...

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

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

03 July 2011 module until all thumbnails are generated. Switch "STOP Thumbnail Service" to "YES" Copy the image just generated to your ORIGINAL site (live/production) Add the weblink on your ORIGINAL site. (you wont need the service as the image already exists...)...

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

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

11 October 2012 ** ** ** ** - For performance, return results based on string length which is 1 greater or lesser than the original ** ** string value: ** ** Automatic: ** ** @minStringLength and @maxStringLength are calculated based on original value. ** ** ** **...

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

Licence GNU/GPLhttps://www.joellipman.com/static-items/licence-gnugpl.html

03 April 2009 of that material, or requiring that modified versions of such material be marked in reasonable ways as different from the original version; or d) Limiting the use for publicity purposes of names of licensors or authors of the material; or e) Declining...

• 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 synchronizes files on an internal hard drive to an external one. I wanted it to copy only the files that were new in the original folder and only copy those over (reason being, the archive is 4 terabytes and backing up only the changed files would speed...

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

PHP Script: Make your own Thumbnail Generator via APIhttps://www.joellipman.com/articles/crm/zoho/php-script-make-your-own-thumbnail-generator-via-api.html

29 May 2025 not render a webpage. Create Storage Folders In the same directory, create two writable subfolders: _origs/ — stores the original downloaded images _thmbs/ — stores the 75×75 thumbnail images Ensure both folders are writable by your web-server user...

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

Making a CD copy with only one drivehttps://www.joellipman.com/articles/microsoft/windows-os/making-a-cd-copy-with-only-one-drive.html

23 September 2009 case that you have only one optical drive which is a minimum of a CD Writer and you want to make a copy of a CD. Insert original CD in the drive In the CD Drive dialog box, click CANCEL On the desktop, double-click on MY COMPUTER Right-click on the CD...

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

Using MetaMod to hide buttons from logged in usershttps://www.joellipman.com/articles/cms/joomla/using-metamod-to-hide-buttons-from-logged-in-users.html

22 September 2009 to the module mgr and create a new menu module for the regmenu menu, mine are called - 'pubmenu' and 'regmenu'. Edit your original menu module and select everything you want your registered users to see and then copy over to the newly created 'regmenu'...

• 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 Special:Version $wgExtensionCredits['parserhook'][] = array( 'name' => 'BUKB Player', 'author' => 'Joel Lipman (based on original flvplayer by Christopher Ottley)', 'url' => 'http://www.joellipman.com/', 'description' => 'Displays videos we have created...

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