ReCaptcha alternative: Integrate PlayThru in JComments 3.0 for Joomla 3.2https://joellipman.com/articles/cms/joomla/recaptcha-alternative-integrate-playthru-in-jcomments-3-0-for-joomla-3-2.html

27 April 2014 to authenticate engaging visitors. How? So I have come up with what I consider a pretty stable solution. I adapted it from various legacy solutions when using Google's ReCaptcha. Note: There is a Joomla plugin for AYAH and this works for the user...

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

SSIS Convert a string into a datehttps://joellipman.com/component/content/article/ssis-convert-a-string-into-a-date.html?catid=74&Itemid=165

14 March 2013 Please note: the following article is not a solution but a page of various methods and date conversions which I try and use depending on the situation. This is a quick article on how I got time conversion working in an SSIS package which read from a...

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

SSRS / MDX Date Querieshttps://joellipman.com/component/content/article/ssrs-mdx-date-queries.html?catid=75&Itemid=165

03 August 2011 I find myself using date ranges endlessly as I've been working in SSRS. The below is derived from a collection of various sources across the web as well as some of my own. These are what worked in my environment: WinXP, BIDS (vs2008), TFS (vs2010), SSRS...

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

SSRS Redirect after a report is runhttps://joellipman.com/component/content/article/ssrs-redirect-after-a-report-is-run.html?catid=75&Itemid=165

12 August 2011 in the results page, then we want it to redirect to the details report for that student automatically. How? So there are various solutions out there, here's an overview of some: Method #1 Create one report with all selectable reports as subreports -...

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

Performance Report - Background colors based on dataset valueshttps://joellipman.com/component/content/article/green-red-background-colors-based-on-dataset-values.html?catid=75&Itemid=165

02 December 2011 made and how this affected the reports' performance. What? What I'm trying to do is display a set of results (comparing various reports) in a table and then to color the backgrounds based on whether they are the fastest or slowest in the set. Something...

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

Problem creating SSRS report subscriptionshttps://joellipman.com/component/content/article/problem-creating-ssrs-report-subscriptions.html?catid=75&Itemid=165

11 November 2013 but in our case, we have a report which points to different servers based on a report parameter. How? There are various types of data sources used in SSRS so I'm going to try and cover the ones I have used previously and what we needed to get them...

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

Drop If Object Existshttps://joellipman.com/articles/else/database/t-sql/drop-if-object-exists.html

03 August 2012 Management Studio doesn't like this and refuses to understand what I'm trying to do. Why? As this data seemed to be across various websites, I wanted a page which has all of them in one place. So here you go, I hope it's of some use. If it's wrong then...

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

Fix Oracle Tnsping 3511 without Windows Registryhttps://joellipman.com/articles/else/database/oracle-pl-sql/fix-oracle-tnsping-3511-without-windows-registry.html

04 March 2013 facility=TNS Why? We NEED several instances of Oracle installed as we have different products/services and these run off various instances of Oracle 9i, 10g, and 11g. This article was written for those that need to support these kind of systems and not...

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

Access MySQL databases using Oracle SQL Developerhttps://joellipman.com/articles/else/database/mysql/access-mysql-databases-using-oracle-sql-developer.html

01 February 2013 So this is a quick article on how to install the mySQL add-on for Oracle SQL Developer v3.0.04. Why? I've used various mySQL administration tools to manage mySQL databases over the years, all freeware until someone expresses an interest in using it and...

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

CSS keeping the footer at the bottomhttps://joellipman.com/articles/cms/website-development/css/css-keeping-the-footer-at-the-bottom.html

25 April 2011 has a background image was under the left and right columns... The main content layer was overlapping the footer. I tried various z-index's bearing in mind that the footer has to be behind because the main content had a semi-transparent layer that...

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

Parse a HTML Table into a ListViewhttps://joellipman.com/articles/cms/website-development/html/parse-a-html-table-into-a-listview.html

30 March 2013 out the HTML Tables into a ListView. Why? I want a snippet of code that replicates any HTML table. How? I've been trying various ways so I'm posting them here. My opinions on them change with the weather so until I do some benchmarking I won't know...

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

Android Background Image Resolutionshttps://joellipman.com/articles/else/app-dev/android-os/android-background-image-resolutions.html

01 December 2014 A reference to what size an image background should be set to for various screen sizes. Why? A background image I was using was unedited at 1600x2133 (364kb) and was not displaying on smaller devices. Configuring drawables for each layout seemed to be...

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