Windows 7: System Clock is constantly going out of synchttps://joellipman.com/articles/microsoft/windows-os/windows-7-system-clock-is-constantly-going-out-of-sync.html

28 January 2010 the system registry setting as per the below. If you have never used the system registry before, ask someone who has. Additional (intended for Vista users) The following is an excerpt from...

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

Embed an FLV file into a web pagehttps://joellipman.com/articles/web-development/html/embed-an-flv-file-into-a-web-page.html

09 March 2010 of the text "http://my.video.com/myVideo.flv" with the full url of your own FLV. Save the HTML page and publish The Code: Additional: Stop AutoPlay Thank you to Anna Moors for writing in and asking "how to stop the movie from playing automatically on...

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

K2 Items disappearhttps://joellipman.com/articles/cms/joomla/k2-items-disappear.html

27 August 2010 on line 80 If I went to K2 Comments, I'd get an additional error: Warning: Invalid argument supplied for foreach() in /home/public_html/administrator/components/com_k2/views/items/tmpl/default.php on line 80 Warning: Invalid argument supplied for...

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

Accessing a MySQL Database with Business Intelligence Development Studiohttps://joellipman.com/articles/database/mysql/accessing-a-mysql-database-with-business-intelligence-development-studio.html

05 January 2011 anyone to go through the same rubbish. I just took a step back and thought this through and this is what I came up with! Additional The above will all work if you're working on a local report within BIDS connecting to remote servers. If you want the...

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

Migrate Joomla! 1.5.x to 2.5.x+https://joellipman.com/articles/cms/joomla/migrating-from-joomla-15-to-16.html

30 January 2011 of website. 2012-11-19: Corrected user migration (new admin is determined by first user in new users table). 2012-11-15: Additional corrections for Menu migration. 2012-11-12: Corrected menu migration if menu items already exist in new site. 2012-11-08:...

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

Alternate row background colour in Reporting Serviceshttps://joellipman.com/articles/microsoft/ssrs/alternate-row-background-colour-in-reporting-services.html

04 February 2011 item. It will alternate between the two for the rest of the report. [The second example is what I use most frequently]. Additional: Suppose you have lots of columns, you don't want to have to click on each cell to specify this so just do it to the first...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: *

Inserting incremental weeks in MySQLhttps://joellipman.com/articles/database/mysql/inserting-incremental-weeks-in-mysql.html

15 April 2011 a clue. Anyway, enough faffing! Here's a script I used to generate the SELECT query. If you run it, it should return the additional 52 rows we want add. Note that the table "WeekStructure" could have been any table with more than 52 rows, I'd say...

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

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

05 July 2011 Find some more JavaScript examples, and then try "translating" them to COM. (JavaScript is well documented online) Learn additional ways to access the HTML DOM. You may be wondering, "How do I find information about the element so I can access it?" Good...

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

SSRS External Images don't displayhttps://joellipman.com/articles/microsoft/ssrs/ssrs-external-images-dont-display.html

19 September 2011 "PhotoDetails") & IIF(Code.ImageExists(First(Fields!PhotoURL.Value, "PhotoDetails")), " exists!", " does NOT exist.") Additional Error (if you get this) We didn't get this error as the problem was down to not having a "unattended user account" who could...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: *

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

30 September 2011 row height would be like a magician revealing the secrets to his tricks... no it wasn't really, time was the issue. Additional conditions Direct access to our databases, both development and production, means that anyone with access to the Excel...

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

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 2008 R2 (SSRS) reading from an Oracle 10g database which works great and lists all the details on a specific student. An additional request is that there appears a link that will run a stored procedure which Updates a timestamp in an existing table...

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

SSRS AlphaNumeric Parameter Validationhttps://joellipman.com/articles/microsoft/ssrs/ssrs-alphanumeric-validation.html

07 November 2011 change 0 to 1. */ =IIF( Parameters!ParameterToCheck.Value"" AND Fields!NOTALPHANUMERIC.Value=0, "Valid", "Not Valid" ) Additional If like us, you've made a report containing a link dependent on parameters submitted, we had to apply a similar IIF...

• 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 AS ItemID FROM ExecutionLogStorage ) AS d1 ORDER BY d1.Name ASC Additional Modifications: For all Parameters: » General - Untick "allow blank value" and "allow null value" (so these checkboxes are empty). » Available Values - "Get values from a query" =...

• 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 ***** H:\temp.txt 1: This is line 1 2: This is line 2 3: This is line 3 ***** C:\TEMP.TXT 1: ECHO is on. ***** Additional You could change c:\results_file.txt to %TEMP%\results_file.txt to send the file to your temporary directory instead of using the...

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

Print Directory Contents to a Filehttps://joellipman.com/articles/microsoft/windows-os/print-directory-contents-to-a-file.html

19 July 2012 (including the double-quotes) TEST: Open an instance of Windows Explorer, Right-click on a folder and select the action. Additional Notes: This outputs the contents to a text file called "directory_printout.txt". This file will be stored in the folder...

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

Connect to Joomla database in standalone scripthttps://joellipman.com/articles/cms/joomla/connect-to-joomla-database-in-standalone-script.html

17 August 2012 $db_connect ); Clear as mud? Feel free to use the comment fields at the bottom of this page to ask a question. Additional I'm pretty sure you don't need all the require files and my solution may be crude, but this script works perfectly for what I had...

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

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

20 August 2012 template: -- note that Yootheme warp does not include the mootools-more.js file: -- reminder: check for conflicts Additional Notes You have no idea how long it has taken me to get this code in working order and as easy as it may be to others, this has...

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

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

21 August 2012 the value back to "Name:" and the color back to grey. If it isn't, then leave as is and ensure the color is still black. Additional Note that instead of just saying if this value equals "Name:" I've added some code to trim the values. If the user types...

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

T-SQL example of Case-Sensitive Soundexhttps://joellipman.com/articles/database/t-sql/t-sql-example-of-case-sensitive-soundex.html

10 October 2012 Success! Now we can run this on a column in a table to determine if there are discrepancies in our default values. Additional Note how this also picked up typos in the 4th value which is good as I didn't want to overcomplicate things using LEVENSHTEIN...

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

Adding a selectable background to a Yootheme templatehttps://joellipman.com/articles/cms/joomla/adding-a-selectable-background-to-a-yootheme-template.html

19 November 2012 logging into the Joomla Admin Panel > Extensions > Template Manager > Styles > "Select the Background" > Save/Apply Done! Additional Note I do not work for Yootheme. I did not post this to Yootheme forums because you have to be a paying member to access...

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