View your available module positionshttps://www.joellipman.com/articles/cms/joomla/view-your-available-module-positions.html

15 September 2009 Click on the link 'Show in New Window' Bookmark the web address of the new window The bookmark/favorite that you have just made can be refreshed when you change things on your site and should reflect exactly how your website is overlayed with the module...

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

Installing phpBB3 for Joomla with a RocketTheme templatehttps://www.joellipman.com/articles/cms/joomla/installing-phpbb3-for-joomla-with-a-rockettheme-template.html

28 September 2009 folder You need to copy any files from your rocket template folder (eg. affinity) into the folder you just made (eg. copy of prosilver) and overwriting when prompted. Rename your copy of prosilver folder to the name of your new template (eg. affinity -...

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

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

15 November 2009 => just cos this value exists, don't know why you would order by this ordering => the setting it's on if you haven't made this modification. I don't like it and nor do u if you've been trawling the web for this solution. archived => is or not approved...

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

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

13 July 2010 like the UK's idiom "belt-and-braces", ‘Belt-and-suspenders’ describes an approach to web design where provision has been made for more than one method of achieving a satisfactory outcome. typosquatter A typosquatter is a company/individual that...

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

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

05 January 2011 earlier should be listed) Enter credentials if necessary and click on "Test Connection" Expand the data connection you just made and expand "Tables" just to see if the connection is working properly. Create the Data Source Still within Business...

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

Parameters not being used in report processinghttps://www.joellipman.com/articles/microsoft/ssrs/parameters-not-being-used-in-report-processing.html

07 January 2011 ASC, tt.[FinishTime] ASC I even separated off the @GivenDate and @GivenCampus and re-assigned them mid-script which made no difference whatsoever. In case you've been stuck for ages (as I have), I found out you cannot declare the parameters used by the...

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

Checklist for the local computer repairshttps://www.joellipman.com/hardware/checklist-for-the-local-computer-repairs.html

28 April 2011 for $75. Then, I’d charge them $150 for “forensic data recovery” with “no guarantees” – while recovering from the backup I’d made silently. I guess it’s part of the “underpromise/overdeliver” thing… but several customers were intensely relieved when I...

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

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

28 April 2011 Get business cards made. Pass them out where ever you go. Don’t rent a storefront yet. Go to people’s businesses/homes and do the repairs there. Ask local businesses if you can post a flyer in their window or on their cash wrap. Initially, charge a...

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

Joes FREE Website Thumbnailer (JWT)https://www.joellipman.com/component/content/article/joes-free-website-thumbnailer.html?catid=40

28 June 2011 It's automation. The situation is that the program takes a picture of whatever that section of the screen is displaying. I made this program stay on top of all the other windows, much like the start menu/task bar (only this program is beneath the task...

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

T-SQL Record Separatorhttps://www.joellipman.com/articles/database/t-sql/t-sql-record-separator.html

11 October 2011 to do that?". Anyway, I was looking for something like the record separator in Oracle SQL*Plus where a row of data (blank or made of symbols) separates two sets of data from within the same select query based on a column that's different. So for...

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

MySQL last year week month day trend periodshttps://www.joellipman.com/articles/database/mysql/mysql-last-year-week-month-day-trend.html

31 October 2011 I recently made a joomla module that displays the lastest members to signup. It goes a little further and counts activated accounts for the past day, week, month and year (the below examples count all accounts irrespective of being activated or not). It...

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

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

04 November 2011 ssrs_audit_table is a table that we want to use as an audit table -- where ssrs_stored_procedure is a stored procedure we made -- where ssrs_sp_user is the user to run the stored procedure in SSRS -- where base_table_owner is your base table owner...

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

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

07 November 2011 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 statement block to the Font...

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

Joes DNS Correction (JDC)https://www.joellipman.com/component/content/article/joes-dns-correction2.html?catid=40

25 November 2011 and the connections would have been restored. As I love automation and reducing processes to single-click fixes, I made this teeny tiny program to run the above commands and check the error levels. Installation: 1) Decompress to a folder of your...

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

Performance Report - Background colors based on dataset valueshttps://www.joellipman.com/articles/microsoft/ssrs/green-red-background-colors-based-on-dataset-values.html

02 December 2011 which is the better report; and when comparing to the previous runs (using a second dataset) you can tell where changes were made and how this affected the reports' performance. What? What I'm trying to do is display a set of results (comparing various...

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

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

17 August 2012 script works perfectly for what I had in mind. Important! There are a few concealed features of this script that I haven't made a song and dance about but are noteworthy: The only anti-code injection facility in this example is the...

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

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

22 August 2012 which could determine the datatype automatically but as you may know, Oracle has a funny way of working with dates which made this need to be changed. The following function now requires a second parameter where you specify the data type: CREATE OR...

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

Three boxes, two roll over, one falls outhttps://www.joellipman.com/articles/web-development/css/three-boxes-two-roll-over-one-falls-out.html

21 January 2013 more the fact that the scripts use that 1 pixel (ceiling rather than floor?). Why? We have a row on a website of three boxes made of div layers. When viewed normally on a 15" Laptop, all was good using Chrome and tolerable using MS Internet Explorer. If...

• Type: Article
• Author: Joel Lipman
• Category: Cascading Stylesheets
• Language: *

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

14 March 2013 was only by trawling through columns that someone mentioned that maybe all the data in that column is not consistent? This made sense as I need to parse the string to extrapolate the date, month and year. How? I used two "Derived Column" tasks for this...

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

Country Lookup by IP address CSVhttps://www.joellipman.com/articles/database/mysql/country-lookup-by-ip-address.html

17 March 2013 in time a region by IP for more accuracy. Feel free to feedback. It's FREE to download unlike others which is probably why I made the generator in the first place but I do like to make people sign up so I can gauge the level of interest.

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