Sort order a dropdown list in MS InfoPath without programminghttps://www.joellipman.com/articles/microsoft/infopath/sort-order-a-dropdown-list-in-ms-infopath-without-programming.html

21 July 2011 you what you're getting yourself into) Go to Settings Select Create View Select Datasheet View (you could probably use a "Standard View", I just used the Datasheet one) Give the view a name, select what columns you want the form to have (I included the...

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

AutoHotkey Format Date and Format Secondshttps://www.joellipman.com/articles/automation/autohotkey/autohotkey-format-date-and-format-seconds.html

20 September 2011 val, - { StringReplace, val, val, -,,All StringReplace, val, val, :,,All StringReplace, val, val, %A_Space%,,All } ; Standard European format (dd/mm/yyyy HH:mm:ss) IfInString, val, / { ThisTime:=SubStr(val, InStr(val, " ")+1) StringReplace, ThisTime,...

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

List MediaWiki Articleshttps://www.joellipman.com/articles/cms/mediawiki/list-mediawiki-articles.html

22 September 2011 do I want? Page ID, Title, Content, Category, AccessLevel (note that AccessLevel is extra to your standard MediaWiki setup and one that was customized for my day job). Thought I already had this somewhere on my site, so it took a while again but I've...

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

Basic Oracle Stored Procedure Structurehttps://www.joellipman.com/articles/database/pl-sql/basic-oracle-stored-procedure-structure.html

16 January 2012 the cursor. Why A standalone query is faster in the eyes of SSRS, however within SSRS we don't have the capability to run standard PL/SQL commands... unless they're run from within a stored procedure. Our aim is to run a small query first to return the...

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

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

21 August 2012 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 of text. name="name" - attribute that assigns a...

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

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

19 December 2012 — Do NOT overwrite/remove the TEST configuration.php file. — Do NOT enable users access till the last step. My Standard Setup LIVE - the public facing version of your site QA - for clients who need to test enhancements that you've developed....

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

Set up Desktop SlideShow in Windows 7https://www.joellipman.com/articles/microsoft/windows-os/set-up-desktop-slideshow-in-windows-7.html

22 January 2013 And we still need to re-login for every change. About a zillion group policies control our every deviation from the standard staff image and so we spend more time on "how do you make it like it was in XP?" situations. How? Who doesn't want to change...

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

SSIS Convert a string into a datehttps://www.joellipman.com/articles/microsoft/ssis/ssis-convert-a-string-into-a-date.html

14 March 2013 being applied to a NULL date timestamp. Dealing with Date NULLs: Fix: Put conditional statements to account for NULLs. -- Standard TRIM(This_Date) == "" ? NULL(DT_DATE) : (DT_DATE)This_Date -- if data source column is of datatype string and european...

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

Autohotkey Count Number of Files/Folders in a Directoryhttps://www.joellipman.com/articles/automation/autohotkey/autohotkey-count-number-of-files-folders-in-a-directory.html

04 June 2013 FolderCount := ItemCount - FileCount TotalFileCount += FileCount TotalFolderCount += FolderCount } Method #3: Standard Function with Loop -- input parameters: -- -- Folder=folder/file pattern. -- -- Subfolders=1 or 0 (recurse into subfolders or not)...

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

Client Services: Website Development Agreementhttps://www.joellipman.com/static-items/client-services-website-development-agreement.html

15 November 2013 you have been directed to this page, this is a draft article on a standard development project. The below is just a draft agreement and has to be mutually agreed. As the client, feel free to adjust, suggest and query against this. Here is an outline...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• 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 last file backup was over a year old but we only needed the core files, a working system, and then we could proceed with a standard Joomla update. I suspected that part of an auto-update process had corrupted all the files. In our case, the problem was...

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

SSRS Stop Scrolling Behindhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-stop-scrolling-behind.html

08 April 2014 2008 R2 Microsoft Visual Studio 2012 Microsoft Business Intelligence Development Studio What? I recently revamped our standard report with a new template comprising of a single Tablix which contained the images of the corners and sides of the report. It...

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

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

17 July 2014 ; set up array of jokes Joke1:="I pretend to work here, work pretends to pay me." Joke2:="He sets low personal standards and then consistently fails to achieve them." Joke3:="If he were any more stupid, he'd have to be watered twice a week." Joke4:="He...

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

MessageBox or AlertDialog in Android Javahttps://www.joellipman.com/articles/google/androidos/messagebox-or-alertdialog-in-android-java.html

20 October 2014 box, only Android let's you redesign the dialog. For my purposes I have used an XML as the layout. How? This displays a standard Ok/cancel message popup which you attach to some event import android.app.AlertDialog; import...

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

Android: Replace return key with done, go, send...https://www.joellipman.com/articles/google/androidos/android-replace-return-key-with-done-go-send.html

03 November 2014 No suggestions/autocorrect textEmailAddress // valid email address textPersonName // name of a person textPostalAddress // standard postal address textPassword // password type field textVisiblePassword // um... textPhonetic // text that will sound like...

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

Submit form as a server and not the client with cURLhttps://www.joellipman.com/articles/automation/api-misc/submit-form-as-a-server-and-not-the-client-with-curl.html

20 February 2015 the server IP address. We're going to use a PHP script with the cURL function to receive and send the data. cURL is a standard feature on most LAMP setups. If not you can install it from here: http://curl.haxx.se/download.html I'm demonstrating this...

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

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

09 March 2015 This is the component to search so other valid values are: categories contacts newsfeeds weblinks To determine yours, do a standard search on your website and check the search results page. There should be several additional options to your search that...

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

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

07 September 2015 via Joomla Extension Update Manager corrected. - Date Uploaded: Wed, 4th Jun 2014 3.0.1 ThomasM- Fixed Bug: Strict Standards Issue: New Operator removed for PHP5+. - Fixed Bug: Object without reference: Child object design converted to Object array. -...

• 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 Information(s): StackOverflow: Split string by comma, but ignore commas inside quotes WhatWG.org - XMLHttpRequest Standard

• 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 # change this to your 403 - forbidden page. These are two methods I like and will work in tandem. They will not affect the standard visitors to your Joomla website (specifically those not interested in logging into the administrator section). Updated...

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