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

31 May 2009 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 (although you may edit the post if the timer has not run out). If you made the...

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

Mediawiki Extension for Camtasia Studio SWF videoshttps://joellipman.com/articles/cms/mediawiki/mediawiki-extension-for-camtasia-studio-swf-videos.html

08 October 2009 flvplayer by Christopher Ottley)', 'url' => 'http://www.joellipman.com/', 'description' => 'Displays videos we have created using Camtasia Studio.' ); $wgExtensionFunctions[] = "wfFlvPlayerExtension"; /* * The FlvPlayer class generates code that embeds...

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

Change default order of weblinkshttps://joellipman.com/articles/cms/joomla/change-default-order-of-weblinks.html

15 November 2009 an issue if some of your links have http and some don't description - not recommended! date - the one I use for most recent created - this is also a date formatted field modified - and this is a date formatted field hits - number of times that weblink...

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

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

12 July 2010 off the executable (EXE) within or run the Autohotkey file (AHK) if you have AutoHotkey installed on your computer. It was created in AutoHotkey and the download includes the source file if you want to check it doesn't have any malicious code....

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

Joe's CSV Chart Generator (JCG)https://joellipman.com/component/content/article/joellipmans-csv-chart-generator.html?catid=40

26 May 2010 need to release service packs and updates. OTHER NOTES: This program does not install other files nor is a setup. It was created in AutoHotkey and the download includes the source file if you want to check it doesn't have any malicious code....

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

Blank columns issue when exporting to Excel (Data Only) from Crystal Reportshttps://joellipman.com/articles/microsoft/excel/blank-columns-issue-when-exporting-to-excel-data-only-from-crystal-reports.html

15 June 2010 headers, a further issue with our web-report is that even an export to Excel (Data Only) from Crystal Reports 9, created extra columns. This issue could not be replicated on the client machine (ie. from my workstation). I would have to upload the report...

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

T-SQL DateTimestampshttps://joellipman.com/articles/database/t-sql/t-sql-datetimestamps.html

23 March 2011 got a list from databases.aspfaq.com but the convert numbers didn't correspond to the output formats. This is my list created within my environment and setup (see above).

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

Creating a Profile Plugin for Joomla 1.6https://joellipman.com/articles/cms/joomla/creating-a-profile-plugin-for-joomla-16.html

27 April 2011 (and sync with 3rd party avatar). Not riveting stuff but something that all my clients want. Fortunately for me, I just created one plugin which I can install on any number of Joomla 1.6 sites and it does all this for me... Neat huh? Folder I'm going to...

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

Joes Bug Tracker (JBT)https://joellipman.com/component/content/article/joes-bug-tracker-jbt.html?catid=40

07 July 2011 Tracker for Remository that they use (not Joomla! integrated though?). Joes Bug Tracker (JBT) is a Joomla! CMS component created by JoelLipman.Com as a download manager and bug tracker all in one. I needed a solution that was FREE but was good enough to...

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

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

04 November 2011 to list all the details. On the last report, the one to execute the stored procedure, we use an account specifically created to run the stored procedure. This requires using 2 data sources in SSRS. A user will specify the student reference in the...

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

SSRS Dropdown parameter cannot be blank!https://joellipman.com/articles/microsoft/ssrs/ssrs-dropdown-to-allow-blank-values.html

14 December 2011 I have created an SSRS report which can compare 4 reports side by side and brings up their latest execution times to the nearest millisecond. The report has 4 parameters. Each parameter is a dropdown populated by a list of all available reports. Why? I...

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

Prefix Line Numbers in a Text Filehttps://joellipman.com/articles/automation/ms-dos/prefix-line-numbers-to-a-text-file.html

18 July 2012 file) temp.txt is just a dummy file which should be empty for clarity results_file.txt is the resulting file, it will be created in the current working directory. Above and Beyond: Add to your Context Menu My absolute laziness drives me to write the...

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

Inline Labels in Form Fields using Javascripthttps://joellipman.com/articles/web-development/js/inline-labels-in-form-fields-using-javascript.html

21 August 2012 which do, as the name indicates, trigger events when the cursor is either in the field or not. The above field was created with the following code: Explanation type="text" - standard attribute that tells the field this is an input field for single line...

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

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

22 August 2012 WHEN others THEN RETURN ('Unable to generate random value'); END UFN_DATASCRAMBLE; Usage SELECT -- UFN_DATASCRAMBLE(DATE_CREATED, 'DATE') scramble_column, -- testing inputted column UFN_DATASCRAMBLE(0123456789012345, 'INT') random_integer, -- testing 16...

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

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

07 December 2012 ** Author: - ** ** Created On: 28 August 2009 ** ** Revision: V 0.01 ** ** Description: Stored Procedure to scramble Data in a column of a table. ** ** The process will mix the Data using a random function. ** ** Once the Data has been scrambled it...

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

Administrator Program Shortcut without Prompthttps://joellipman.com/articles/microsoft/windows-os/administrator-program-shortcut-without-prompt.html

25 February 2013 Additional: You can change the icon for the shortcut using the shortcut properties and browsing to the program it was created to run. Related Link(s): Elevated Program Shortcut without UAC Prompt Avoid UAC prompts by using an elevated program launcher...

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

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

03 April 2013 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 extract all the data values from an AwStats report. Advanced Web Statistics or AwStats, is a reporting system...

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

SSIS Script: convert UPPERCASE to Mixed-Case using TitleCasehttps://joellipman.com/articles/microsoft/ssis/ssis-script-convert-uppercase-to-mixed-case-using-titlecase.html

04 October 2013 columns passed into the component // It locates the actual column value (including checking for null) using the index array created in the Pre-Execute public override void ProcessInput(int inputID, PipelineBuffer buffer) { string inputValue; string...

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

Hide a Drive per User in Windows 7https://joellipman.com/articles/microsoft/windows-os/hide-a-drive-per-user-in-windows-7.html

28 March 2014 right click on a empty area, click on New > DWORD (32-bit) Value > type NoDrives > Enter. Right click on the DWORD you just created and click on Modify. Type in the drive option hex or decimal number from the list below you want to set as restricted,...

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

AHK Countdown Tooltiphttps://joellipman.com/articles/automation/autohotkey/ahk-countdown-tooltip.html

17 July 2014 you are logged in: ; ; AutoHotkey Version: 1.0.47.06 ; Language: English ; Platform: Win9x/XP ; Author: Joel Lipman ; Date Created: 15-July-2014 ; ; Script Function: ; Just a countdown for my last days at BU. ; ;...

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