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

28 October 2013 element operator [. .] lets you use a collating sequence in your regular expression. The element you specify must be a defined collating sequence in the current locale. This operator lets you use a multicharacter collating sequence in your regular...

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

Joomla Component: Set default params on installationhttp://mail.joellipman.com/articles/cms/joomla/joomla-component-set-default-params-on-installation.html

24 October 2013 component (ie. same as the XML installation file) Add the install script instructions: // No direct access to this file defined('_JEXEC') or die; // com_XXX is your component name class com_XXXInstallerScript { function postflight($type, $parent) { //...

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

Joes Quicklist Weblinks (JQW) Downloadshttp://mail.joellipman.com/component/content/article/joes-quicklist-weblinks-jqw-downloads.html?catid=92

07 September 2015 Bug: Corrected "trigger popup" text translation. - Date Uploaded: Wed, 2nd Nov 2011 1.5.3.4- Fixed Bug: More variables now defined - Date Uploaded: Fri, 30th Sep 2011 1.5.3.3- Fixed Bug: Undefined variables now defined - Date Uploaded: Thu, 29th Sep...

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

Forum Ruleshttp://mail.joellipman.com/static-items/forum-rules.html

31 May 2009 has run out, in which case you may double post if you have something important to add. Spamming is also not allowed, and is defined as a post that has no meaning. No Topic Bumping - If a topic you created has no replies, you may not post again in it...

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

How to redirect the visitor after the contact pagehttp://mail.joellipman.com/articles/cms/joomla/how-to-redirect-the-visitor-after-the-contact-page.html

06 September 2009 .’&Itemid=’. $Itemid; mosRedirect( $link, _THANK_MESSAGE ) replace that code with the URL for the contact Thank-you page as defined as follows: $link = sefRelToAbs( 'index.php?option=com_contact&task=view&contact_id='. $contact[0]->id .'&Itemid='....

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

SQL Calendar in Business Intelligence Development Studiohttp://mail.joellipman.com/articles/database/t-sql/sql-calendar-in-business-intelligence-development-studio.html

14 January 2011 = DATEPART(MONTH,d.[Date]), -- used to get the time of the event e.EventDate, --event details to display e.Note --CTEs defined above are used as the queries for the results FROM Dates d LEFT JOIN Events e ON CAST(CONVERT(VARCHAR(10),e.EventDate,101) AS...

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

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

01 August 2012 if it already exists IF OBJECT_ID ('ufn_DataJumble', 'FN') IS NOT NULL DROP FUNCTION ufn_DataJumble ; GO -- Create user defined function CREATE FUNCTION ufn_DataJumble ( @OrigVal varchar(max) ) RETURNS varchar(max) WITH ENCRYPTION AS BEGIN -- Variables...

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

Licence GNU/GPLhttp://mail.joellipman.com/static-items/licence-gnugpl.html

03 April 2009 code” means any non-source form of a work. A “Standard Interface” means an interface that either is an official standard defined by a recognized standards body, or, in the case of interfaces specified for a particular programming language, one that is...

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

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

07 December 2012 if it already exists IF OBJECT_ID ('ufn_DataScramble', 'FN') IS NOT NULL DROP FUNCTION ufn_DataScramble ; GO -- Create user defined function CREATE FUNCTION ufn_DataScramble ( @OrigVal varchar(max) ) RETURNS varchar(max) WITH ENCRYPTION AS BEGIN --...

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

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

23 February 2014 default is 30 seconds. /REG :: Save /R:n and /W:n in the Registry as default settings. /TBD :: wait for sharenames To Be Defined (retry error 67). :: :: Logging Options : :: /L :: List only - don't copy, timestamp or delete any files. /X :: report all...

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

Zoho Analytics: Set Up a Widget Displaying Sales Personhttp://mail.joellipman.com/articles/crm/zoho/zoho-analytics-set-up-widget-displaying-sales-person.html

24 October 2022 this for all the invoices against a sales person. It adds to the effect on loading the page that a widget has clearly defined values based on the filters I select on a dashboard. First you will need a table or query that has a bunch of columns and rows...

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

Excel: Extract hyperlink from linkhttp://mail.joellipman.com/articles/microsoft/excel/excel-extract-hyperlink-from-link.html

06 November 2014 Open up a new workbook. Get into VBA (Press Alt+F11) Insert a new module (Insert > Module) Copy and Paste the Excel user defined function below Sub ExtractHL() Dim HL As Hyperlink For Each HL In ActiveSheet.Hyperlinks HL.Range.Offset(0, 1).Value =...

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