Joes Network Transmission Detector (JTD)https://www.joellipman.com/component/content/article/joes-network-transmission-detector-jtd.html?catid=40

29 September 2011 tcpdump, pcap) IP and resolved host names on double-click without causing network traffic (tried netstat. NTS: try this again with dll calling) Program used to open port (still need to distinguish between out/in) detect bytes instead of kilobytes GUI...

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

Stop Excel Row Height Self-Adjust on Refreshhttps://www.joellipman.com/articles/microsoft/excel/stop-excel-row-height-self-adjust-on-refresh.html

30 September 2011 of text would adjust their row to fit but all others were left untouched. Perfect! Other Searches that I may search for again but get me nothing stop row height change on refresh data excel 2007 excel row height refresh data row height being reset on...

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

SSRS Retrieving Oracle Stored Procedure Success or ErrorLevelhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-retrieving-oracle-stored-procedure-success-or-errorlevel.html

04 November 2011 says either "Stored Procedure was successful" or "No sorry you're going to have to go back to the beginning and try that again."... This isn't a solution that sounded good enough for our customers. The Workaround we actually went with Our Stored...

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

No rows returned in Oracle causes SP to failhttps://www.joellipman.com/articles/database/pl-sql/no-rows-returned-in-oracle-causes-sp-to-fail.html

24 January 2012 Running the second based on the first will error this procedure. One Issue I just kept getting this error over and over again: ORA-00936: missing expression 00936. 00000 - "missing expression" The solution was to enclose the subquery with an opening and...

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

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

01 August 2012 -- Used to reference RAND with in a function CREATE VIEW dbo.vwRandom AS SELECT RAND() as RandomValue; GO The Function Again you need permission to create this function. Don't forget to GRANT permission to execute this function for whatever user/system...

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

Basic Joomla 2.5 Mootools Formhttps://www.joellipman.com/articles/cms/joomla/basic-joomla-25-mootools-form.html

20 August 2012 file, if you have this enabled in Joomla then you already have this and don't need to include it again (just view the source of your webpage that this form will be on). Does not use JQuery - Although most of the sites I work for use JQuery as well as...

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

Slideshow div layer through a windowhttps://www.joellipman.com/articles/web-development/mootools/slideshow-div-layer-through-a-window.html

11 September 2012 contents of the hidden slide with contents of the displayed slide. Hide currently displayed slide to expose the first slide again (restores the starting position of "next slide"). The Gist Strategy This may not be a great idea, I'm just trying something...

• Type: Article
• Author: Joel Lipman
• Category: MooTools Framework
• Language: *

Quickly update all content in mySQL database replacing a stringhttps://www.joellipman.com/articles/database/mysql/quickly-update-all-content-replacing-a-string.html

03 February 2013 @stringtoFind, @stringtoReplaceWith) WHERE `introtext` LIKE CONCAT('%',@stringtoFind,'%') Run the first query again and no rows should be returned. Quick Joomla One I use this reluctantly but often necessarily. SET @stringtoFind=' '; SET...

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

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

03 April 2013 it's the end of the month again and I have to prepare a report for some investors. The idea of an infographic report has excited them to no end but because the end of the month didn't wait for me to finish the project, I quickly created this program to...

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

Joes Syntax Styler (JSS)https://www.joellipman.com/component/content/article/joes-syntax-styler-jss.html?catid=40

06 April 2013 jQuery and MooTools) conflicting with other scripts but do I really need a complex solution? So here I am making my own again. I wanted something really basic that simply lets me style content within the tags: Use PHP or JavaScript (avoiding Framework...

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

MS Excel - Sort pivottable column headings by datehttps://www.joellipman.com/articles/microsoft/excel/sort-pivottable-column-headings-by-date.html

12 April 2013 This is a quick note to myself so that I never use parentheses in the column headings again. Basically I have a pivot table in Microsoft Excel 2010 with the projects down the left (in the first column) and the days of the week along the top. Why? The...

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

ReCaptcha disappears from Joomla 2.5 Registrationhttps://www.joellipman.com/articles/cms/joomla/recaptcha-disappears-from-joomla-2-5-registration.html

24 November 2013 #1 didn't work for you then if the following code works, it's because Google have changed where they're storing the API (again). This overrides the Core Joomla code for ReCaptcha: 1. Open the file: /plugins/captcha/recaptcha/recaptcha.php 2. Find the...

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

Generate a Timesheet in MySQL https://www.joellipman.com/articles/database/mysql/generate-a-timesheet-in-mysql.html

05 December 2013 Saturday -- 2013-12-08 Sunday Brilliant! We have the first two columns of what we want to do. Now we need the same again but this time we want the morning slots SELECT DATE( DATE_ADD( NOW( ) , INTERVAL 0 - WEEKDAY( NOW() ) DAY ) ) AS ThisDate, DAYNAME(...

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

301 Redirect using htaccess filehttps://www.joellipman.com/articles/web-development/301-redirect-using-htaccess-file.html

03 April 2014 topic, but as this took me the good part of an hour just to find out, I'm posting it here so I never have to look for it again. A client changed their website domain address and wanted any person visiting the old domain to be redirected to the new...

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

A quick run through of setting up an export process in SITShttps://www.joellipman.com/articles/web-development/xml/a-quick-run-through-of-setting-up-an-export-process-in-sits.html

21 August 2014 a few times and run through a few, I thought I'd note this down to remind me if I ever work for a company using SITS:Vision again. How? For demonstration purposes, I'm going to create a table update process (TUP) based around a change in the course...

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

DJI Phantom FC40 Paint-Job and AerialFreaks Cyclops FC40 Gimbal Upgradehttps://www.joellipman.com/articles/_other-misc/quadcopters/dji-phantom-fc40-paint-job-and-aerialfreaks-cyclops-fc40-gimbal-upgrade.html

04 September 2014 a crash and sorta had the day off so... There are so many pictures because I wanted to be sure I could put it back together again, I'd recommend anyone who doesn't have a photographic memory to do the same. My beloved DJI Phantom and the Hubsan X4 H107C...

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

DJI Phantom FC40 - Fun at the raceshttps://www.joellipman.com/articles/_other-misc/quadcopters/dji-phantom-fc40-fun-at-the-races.html

17 September 2014 I reckon they should make drones that go right a tipped over car or bring it back to the track... Then again, couldn't those cars self-right themselves? Ok. back to work.

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

Quadcopter App with Flight Restrictions (JQA)https://www.joellipman.com/component/content/article/quadcopter-app.html?catid=40

24 October 2014 reminders, password resets, or e-mail changes. The key stored on the device expires after 30 days and requires you to login again if you have not used this app in that time. ChangeLog v1.8.x [25 Nov 2014] - [1.8.5] Hangar: prepared for aircraft data -...

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

Android OS: Add GoogleMap as fragmenthttps://www.joellipman.com/articles/google/androidos/android-os-add-googlemap-as-fragment.html

25 November 2014 MapFragment fragment = new MapFragment(); transaction.add(R.id.mapView, fragment); transaction.commit(); } Same file again but on the menu item (or to call it from anywhere): eg. MainActivity.java setContentView(R.layout.activity_map_fragment);...

• Type: Article
• Author: Joel Lipman
• Category: AndroidOS
• 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 }, { my_col1_val: 'item1b', my_col2_val: 'item2b' }, { my_col1_val: 'item1c', my_col2_val: 'item2c,c' } ]; What I want again: Read a CSV file already uploaded with JavaScript Populate a JS array with each row Account for strings containing double-quotes...

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