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

03 April 2009 liability in connection with the Program, unless a warranty or assumption of liability accompanies a copy of the Program in return for a fee. END OF TERMS AND CONDITIONS

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

DataTumble - Randomize Data Rowshttps://www.joellipman.com/articles/database/t-sql/datatumble-randomize-data-rows.html

07 December 2012 Data to be scrambled. Can be null ** ** ** ** Outputs: ** ** The Data in @ColumnName column will be scrambled ** ** ** ** Return Values: ** ** None ** ** ** ** Before: ** ** ID Name DateOfBirth ** ** --------- ------------ ----------- ** ** 1 John...

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

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

07 December 2012 FUNCTION ufn_DataScramble ; GO -- Create user defined function CREATE FUNCTION ufn_DataScramble ( @OrigVal varchar(max) ) RETURNS varchar(max) WITH ENCRYPTION AS BEGIN -- Variables used DECLARE @NewVal varchar(max); DECLARE @OrigLen int; DECLARE...

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

Error 1065: Query was Emptyhttps://www.joellipman.com/articles/database/mysql/error-1065-query-was-empty.html

13 December 2012 common. Why? Bespoke systems are the usual suspects. Developers will have told the system what to do when newline, carriage returns and tab characters are entered in the data. Those who are security-conscious will also make their system escape...

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

Country Lookup by IP address CSVhttps://www.joellipman.com/articles/database/mysql/country-lookup-by-ip-address.html

17 March 2013 where www.mysite.com is your website where you uploaded this script. // should return China Any questions, suggestions? We are looking to add the ability to generate this data using other sources and in time a region by IP for more accuracy. Feel free...

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

Parse a HTML Table into a ListViewhttps://www.joellipman.com/articles/web-development/html/parse-a-html-table-into-a-listview.html

30 March 2013 Needle1b ) Needle2 := InStr( Haystack, Needle2a, false, Needle1 ) NeedleLen := Needle2 - Needle1 NeedleMarker := Needle2 ReturnedHTMLTable := SubStr( Haystack, Needle1, NeedleLen ) ; split the table into rows...

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

AwStats Data Parser (ADP)https://www.joellipman.com/component/content/article/awstats-data-parser-adp.html?catid=40

03 April 2013 menu on the left) Run "Generate_AwStatsParsedData.exe" Select the file you saved in step 1 Click on "Go". What data does it return? Any table/grid in the Awstats report uniquely identified by the labels mentioned below. What data does Joes Infographic...

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

htaccess Rewrites SEF URL and submits to PHPhttps://www.joellipman.com/articles/web-development/php/htaccess-rewrites-sef-url-and-submits-to-php.html

05 September 2013 Anything not ending in ".html" will simply return a 404 error. I've included my error rules (they basically redirect to a branded error page). So I sanitize on the receiving index.php file: Check for possible Code Injection Do NOT allow the use of...

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

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

28 October 2013 list to specify characters that you do not want to match. Characters that are not in the non-matching character list are returned as a match. For example, to exclude the characters 'a', 'b', and 'c' from your search results, use the following regular...

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

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 site. The good news is that it's only the core files and component files. Here are some tips when restoring the site to return it to as it was. The error refers to a function used by the core framework. Comment it out and you get an error referring to...

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

SSRS: Performance Improvements: SELECT TOPhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-performance-improvements-select-top.html

07 March 2014 Studio (BIDS / VS2008), the IDE would crash and close without warnings or notifications. We found that if the query only returned 1000 rows, it completed and displayed in just under 1 minute. If limited to 500 rows, it would complete in just under 40...

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

SSIS Multiple Lookups in onehttps://www.joellipman.com/articles/microsoft/ssis/ssis-multiple-lookups-in-one.html

05 August 2014 this: But we didn't want to do this. How? As a proof of concept, I created one lookup task that executes a SQL query which returns all the joined tables and displays the decode name. Let's pretend the info we want is rather simple: SELECT [sequenceID],...

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

SITS: Export field code and namehttps://www.joellipman.com/articles/web-development/xml/sits-export-field-code-and-name.html

12 August 2014 use "-1|*LookupFailed*" for the error to come through the XSLT but watch your datatypes Notes: We did not find a way to return the code when the lookup failed, only an alternative message "*LookupFailed*".

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

Excel: convert degrees minutes seconds to decimalhttps://www.joellipman.com/articles/microsoft/excel/excel-convert-degrees-minutes-seconds-to-decimal.html

06 November 2014 L1, L1 * -1) There we go! Column M has your latitude and Column N has your longitude. With the example above, this should return: A B C D E F G H I J K L M N -------------------------------------- ---------------------- ------ ------ ------ ------...

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

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

09 March 2015 by OS Solutions and installed this. The client wanted restricted users to be able to search the PDF indexer but not to return any other Joomla articles from other categories. Public users should not be able to use this search or see the restricted...

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

Sort an associative array by values in Javascripthttps://www.joellipman.com/articles/web-development/js/sort-an-associative-array-by-values-in-javascript.html

29 September 2015 What? An article on how to quickly adapt an array code and sort by its values. Surprising how many examples are on the web and everyone saying you're doing it wrong... Which is true but quite unhelpful. The original code is not my own either but that's...

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

Accessing Apimo WebService APIhttps://www.joellipman.com/articles/automation/api-misc/accessing-apimo-webservice-api.html

29 March 2016 XML declaration from results $output = substr($output, stripos($output, '?>') + 2 ); // remove leading spaces, carriage returns $output = trim($output); // process if type specified was xml if($apimo_type=='xml'){ // send header...

• Type: Article
• Author: Joel Lipman
• Category: API Miscellaneous
• Language: *

Pure JS - Display Time Elapsed & Remaininghttps://www.joellipman.com/articles/web-development/js/pure-js-display-time-elapsed-remaining.html

30 October 2018 seconds_remaining--; seconds_elapsed++; if(seconds_remaining>=0){ document.getElementById("time_remaining").innerHTML = returnTime( seconds_remaining ); document.getElementById("time_ago").innerHTML = returnTime( seconds_elapsed ); } } function...

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

Google Drive API v3 - OAuth2 using Service Account in PHP/JWThttps://www.joellipman.com/articles/google/google-drive-oauth-using-service-account-in-php.html

02 February 2019 4. Declare a PHP function to send requests using cURL A standard function that is skipping the SSL checks and returns a PHP array function send_request($url, $header, $data, $method="GET") { $ch = curl_init(); curl_setopt($ch, CURLOPT_SSL_VERIFYPEER,...

• Type: Article
• Author: Joel Lipman
• Category: Google
• 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 Where: SumProduct( is a function to multiply two ranges together (must be the same size) and return the total of these results. -- is a double hyphen/dash which converts a boolean true to 1 and boolean false to 0. IsNumber( is a function returning a...

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