Using K2 with jezReCaptcha plugin causing errorshttps://joellipman.com/articles/cms/joomla/using-k2-with-jezrecaptcha-plugin-causing-errors.html

25 September 2009 words" captcha) and then installed K2 Comments to use it's own ReCaptcha. If you try adding a comment, you may get something like the following: Fatal error: Cannot redeclare_recaptcha_qsencode() ( previously declared in...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• 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 on your webpage. The following example is a demonstration of how to do this without installing anything on your webserver. I like to use flowplayer for this example but my own systems can't use a solution as crude as this. Copy the below code (beginning...

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

Running Internet Explorer 6, 7, 8 as standaloneshttps://joellipman.com/articles/microsoft/windows-os/running-internet-explorer-6-7-8-as-standalones.html

18 May 2010 XP and I have to emulate their environment as accurately as I can which I can do by setting up my work computer to be just like theirs (using the same image, etc). Programs which I would NOT recommend I've put a list of programs which I installed and...

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

Crystal Reports: Exporting to Excel omits column headershttps://joellipman.com/articles/microsoft/excel/crystal-reports-exporting-to-excel-omits-column-headers.html

03 June 2010 same height value as the one that worked Repeat for all heading textboxes that weren't appearing This will yield something like the following: A few other things that I did to this report that may have contributed to it working: Checked all headings...

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

Webdeveloper-Speakhttps://joellipman.com/articles/web-development/webdeveloper-speak.html

13 July 2010 in the web browser window when the page first loads is described as being ‘above-the-fold’. "belt-and-suspenders" Just like the UK's idiom "belt-and-braces", ‘Belt-and-suspenders’ describes an approach to web design where provision has been made for...

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

Is it a scam? Gumtree.com's warning signshttps://joellipman.com/hardware/is-it-a-scam-gumtreecoms-warning-signs.html

12 October 2010 find it anymore. This is quite a thorough list though it still needs some work. Requests to use money transfer services like Western Union or MoneyGram. These services are not meant for transactions between strangers. In our experience they’re favoured...

• Type: Article
• Author: Joel Lipman
• Category: IT Support
• Language: *

Create Read-Only Database User in SQL Serverhttps://joellipman.com/articles/database/create-read-only-database-user-in-sql-server.html

09 November 2010 to. Tick the boxes for role membership next to public and db_datareader. Confirm by clicking OK. You should get something like the following: Database-level role names from http://msdn.microsoft.com/en-us/library/ms189121(SQL.100).aspx db_accessadmin...

• Type: Article
• Author: Joel Lipman
• Category: Databases
• 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 report to be viewable on a specified Reporting Server than you'll need to deploy the report. If you get the following error (like I did) when you view the deployed report on the Reporting Server: An error occurred during client rendering. An error has...

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

Formatting a date in an MDX queryhttps://joellipman.com/articles/database/t-sql/formatting-a-date-in-an-mdx-query.html

11 January 2011 "=Today()" [yields: 01/01/2011] and this did the trick. English Ordinal Suffix in T-SQL for MDX Working in the UK my bosses like the English Ordinal Suffix. I haven't seen this anywhere in Google, I thought I could use SWITCH to do this in an MDX query...

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

SQL Calendar in Business Intelligence Development Studiohttps://joellipman.com/articles/database/t-sql/sql-calendar-in-business-intelligence-development-studio.html

14 January 2011 within Business Intelligence Development Studio (BIDS). Weekdays along the top and then dates inside. Additionally we would like this linked to events in a database. I'm calling this project "Reinventing the Wheel" because the request was a report that...

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

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

04 February 2011 is my dataset -- and Count(Fields!Field1.Value, "DataSet1") returns the maximum number of rows retrieved Yields something like: This is the bottom left of a report where both the above examples (fill and borders) have been applied:

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

SSRS Hide results table if emptyhttps://joellipman.com/articles/microsoft/ssrs/ssrs-hide-results-table-if-empty.html

29 March 2011 the admins had not added the equipment info on the system), it just showed the heading "Equipment". Iteration in T-SQL? Unlike good old MySQL where you can do iteration within the query (SELECT @ncount:=@ncount+1), we're stuck with T-SQL. Ask Google...

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

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

15 April 2011 ends halfway in a normal people's calendar, so you actually have to adjust this twice a year. Complicated Facility works like this, ask it what date it is on Tuesday in Week 52 of the Academic year 2011/2012... It tells you 2012-07-10. Ask it what date...

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

Newbies guide to be the local computer guyhttps://joellipman.com/hardware/newbies-guide-to-be-the-local-computer-guy.html

28 April 2011 businesses if you can post a flyer in their window or on their cash wrap. Initially, charge a nominal fee…maybe something like $30/hour just to build up a client base and get some referalls. Put up a Web site describing your services. It makes you look...

• Type: Article
• Author: Joel Lipman
• Category: IT Support
• Language: *

What's the problem? Amusing computer issueshttps://joellipman.com/articles/web-development/whats-the-problem-amusing-computer-reports.html

28 April 2011 The computer had two CD-Roms. The user put the disc in one of the drives but was pressing eject on the second drive. Like these? Share your experiences as comments below :)

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

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

05 July 2011 to get the value of the 1st element in the 1st form, which will be the Search for Keywords Input Box. The path would look like this (a collection of objects starts at 0): Code: document.forms[0].elements[0].value Now if you want to show the value of the...

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

SSRS / MDX Date Querieshttps://joellipman.com/articles/microsoft/ssrs/ssrs-mdx-date-queries.html

03 August 2011 // yields: 31/12/2011 I'll add to this if I use others. Apologies for the European formats but this is what I work with so I like to just copy and paste from this article.

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

Before and After, Highs and Lowshttps://joellipman.com/articles/microsoft/ssrs/before-and-after-highs-and-lows.html

03 August 2011 '01/01/2010' AND '08/01/2011' GROUP BY DATEPART(dayofyear, ItemDate), DATEPART(year, ItemYear), ItemName // yields something like ItemName DayOfYear YearRun Counter --------------------- -------------- ------- ------- Report 001 181 2010 134 Report 002...

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

SSRS Redirect after a report is runhttps://joellipman.com/articles/microsoft/ssrs/ssrs-redirect-after-a-report-is-run.html

12 August 2011 This article serves to describe several workarounds or proofs of concept. Why? We have a first report which acts like a search page. You enter the student you are looking for by reference or name and if there is only 1 result in the results page, then...

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

MySQL parameters in Excel 2007 PivotTableshttps://joellipman.com/articles/database/mysql/mysql-parameters-in-excel-2007-pivottables.html

24 August 2011 Crude solution but it works in Excel 2007 Now we want to filter the pivotTable data based on these two values... (I don't like the idea of requiring macros as not all users switch this on and teaching executives on how to do this is tough work. What...

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