Installing phpBB3 for Joomla with a RocketTheme templatehttps://www.joellipman.com/articles/cms/joomla/installing-phpbb3-for-joomla-with-a-rockettheme-template.html

28 September 2009 inherits the Prosilver traits. When I deleted prosilver from the "Styles", "Themes", and "Imagesets", my first phpBB3 index page with the affinity template finally worked!!! Chuffed to bits as you might imagine but clicking on any other link returned an...

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

Report Builder 2.0 - Hide Series1https://www.joellipman.com/articles/microsoft/ssrs/report-builder-20-hide-series1.html

06 May 2010 Server Reporting Service (SSRS) report. I am guessing that Series1 is the data series from an outer join where the joining index value is null. The chart below has 3 series or data fields: Count the total number of incidents logged (Y-axis - data...

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

Webdeveloper-Speakhttps://www.joellipman.com/articles/web-development/webdeveloper-speak.html

13 July 2010 is accessible by people with disabilities. I'm going to stop there but do check them out at http://www.motive.co.nz/index.php

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

SQL Queries for Statisticshttps://www.joellipman.com/articles/database/mysql/sql-queries-for-statistics.html

13 December 2010 my systems is a MediaWiki CMS which is used for the official Bournemouth University Knowledge Base. The skin itself is the index page loaded for any page in the Wiki system. It logs the IP address (VisitorIP), the URL (VisitorURL) entered via the...

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

Joes FREE Website Thumbnailer (JWT)https://www.joellipman.com/component/content/article/joes-free-website-thumbnailer.html?catid=40

28 June 2011 file of websites (-> see "TEXT file example" below) TEXT file example http://www.joellipman.com http://www.joellipman.com/index.php?option=com_content&view=article&id=509...

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

Basic Webpage Controls with JavaScript / COMhttps://www.joellipman.com/articles/automation/autohotkey/basic-webpage-controls-with-javascript-com.html

05 July 2011 description of each item. HTML DOM, JavaScript, COM, Methods, document, value, element, form, name, ID, Input, Tag, selectedIndex, checked, innerText, innerHTML Methods - The following Methods will be used throughout this tutorial. (comparable to...

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

Fun with DllCall in AutoHotkeyhttps://www.joellipman.com/articles/automation/autohotkey/fun-with-dllcall-in-autohotkey.html

27 September 2011 Int,nPtr, Int,1, Int,1, AStr ) : DllCall( "lstrcpy", Str,Var, UInt,nPtr ), nPtr := nPtr+StrLen( Var )+1, List .= "`n" Var, A_Index=1 ? Omit := StrLen( Var )+2 : StringTrimLeft, List, List, %Omit% DllCall( "ImageHlp\UnMapAndLoad", UInt,&$LI ) Return List...

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

Copy a table with structure and data into a temporary tablehttps://www.joellipman.com/articles/database/t-sql/copy-a-table-with-structure-and-data-into-a-temporary-table.html

03 August 2012 DECLARE @SqlToExecute nvarchar(4000); -- Set variable default values SET @TableName = SUBSTRING(@SchemaTableName, CHARINDEX('.', @SchemaTableName)+1, LEN(@SchemaTableName)); SET @SqlToExecute = ''; -- Declare temporary table to use CREATE TABLE...

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

Setup a copy of your Joomla websitehttps://www.joellipman.com/articles/cms/joomla/setup-a-copy-of-your-joomla-website.html

19 December 2012 $ftp_user and $ftp_pass are the ftp credentials. $log_path and $tmp_path should also be updated. $robots - set this to 'noindex, nofollow' (we don't want google to index our test site). Disable new user registration in the TEST version of the site (User...

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

CharIndex Reverse - find occurrence starting from end of string in TSQLhttps://www.joellipman.com/articles/database/t-sql/charindex-reverse-find-occurrence-starting-from-end-of-string-in-tsql.html

28 January 2013 yields "String1.String2.String3.String4" SELECT REVERSE( @Haystack ); -- yields "4gnirtS.3gnirtS.2gnirtS.1gnirtS" SELECT CHARINDEX(@Delimiter, REVERSE( @Haystack )) -- yields "8" SELECT SUBSTRING(@Haystack, CHARINDEX(@Delimiter, REVERSE(@Haystack)),...

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

Cheat Sheet for mySQL vs t-SQLhttps://www.joellipman.com/articles/database/cheat-sheet-for-mysql-vs-t-sql.html

31 January 2013 REPLACE(haystack,needle,replacement) String Position INSTR(haystack, needle) LOCATE(needle, haystack [, offset]) PATINDEX(%needle%, haystack) CHARINDEX(needle, haystack [, offset]) String Concatenation CONCAT(string1,string2[,stringN]) string1 + string2...

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

SSIS Skip Blank Rows in Flat File Sourcehttps://www.joellipman.com/articles/microsoft/ssis/ssis-skip-blank-rows-in-flat-file-source.html

23 April 2013 Feeds (LF) are being inserted, simply extract the entire row as a column and trim it. I separate out the first column as my index/key field so I can check if this is a valid data row (the blank ones may return special chars rather than Null). My example...

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

Call to a member function mark() on a non-object in Joomla CMShttps://www.joellipman.com/articles/cms/joomla/call-to-a-member-function-mark-on-a-non-object.html

17 November 2013 you may get the above error in a Joomla CMS environment. Call to a member function mark() on a non-object in /public_html/index.php How? Not really a solution here because this is indicating that the system can't find the core framework files. Yes the...

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

Excel: Find values in one column that are not in anotherhttps://www.joellipman.com/articles/microsoft/excel/excel-find-values-in-one-column-that-are-not-in-another.html

06 March 2014 site: Method #1 =MATCH(B2, $A$2:$A$100, 0) -- Check whether value in B2 exists in range of A2:A100. -- Returns the index of column A in which the B2 value was found. -- Returns #N/A for a value which is NOT in column A. Drag the formula in B2 down all...

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

SSIS: How to loop through multiple flat files as data sourceshttps://www.joellipman.com/articles/microsoft/ssis/ssis-how-to-loop-through-multiple-flat-files-as-data-sources.html

13 June 2014 did not work). Under "Variable Mappings" specify the Variable "User::SourceExtractFile" (based on this example) and keep the Index at 0 (zero). OK to close the dialog Edit your Data Flow as per usual, selecting your dynamic connection manager as the...

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

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

09 March 2015 section). Why? A client has a repository of PDF documents that are uploaded to a folder. The client also purchased OS PDF Indexer by OS Solutions and installed this. The client wanted restricted users to be able to search the PDF indexer but not to...

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

Joes Word Cloud (JWC) Downloadhttps://www.joellipman.com/component/content/article/joes-word-cloud-jwc-downloads.html?catid=92

07 September 2015 - - Reduced 3 functions into one (strip_punctuation and strip_symbols) - - Omit words of minimum length and don't index - Re-fixed module class suffix parameter ??? - Reworded "Display SQL Query" to "Debug Mode" - - Added word frequency count checker in...

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

Import Excel CSV file as JavaScript arrayhttps://www.joellipman.com/articles/microsoft/excel/import-excel-csv-file-as-javascript-array.html

05 October 2015 = []; // loop through JS array using Array.prototype.forEach() my_csv_rows_array.forEach( function (row_content, row_index) { // clear and declare the array var column_values = []; // regex to ignore commas between double-quotes var column_values =...

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

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

23 October 2015 folder in the root of your joomla website with a name that is difficult to guess but easy to memorise. Create a file called index.php in the folder you just made with the following contents: Append the following code to the .htaccess file in the root of...

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

Zoho Deluge: Loop through 30 Minute Slotshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-loop-through-list.html

30 November 2018 hourList = hourString.toList("/"); v_includeInPicklist = false; for each index timeSlot in hourList { timeSlotStr = timeSlot.toString(); if(timeSlotStr.length() zoho.currenttime && v_CheckTime1b >= v_OpeningTime.toTime() && v_CheckTime1b...

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