Add the website name to the page title in Joomla!https://www.joellipman.com/articles/cms/joomla/add-the-website-name-to-the-page-title.html

06 September 2009 new version. If you have installed Joomla 2.5, this is now a setting in the global configuration... The only problem is that your landing page becomes "HOME - SITENAME.COM" which is ridiculous and I'm sure Joomla will release a new version addressing...

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

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

25 September 2009 The Issue Basically that you've installed JoomlaEZ's ReCaptcha Integrator plugin to protect your forms ("type two 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...

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

How To Make Chocolate Chip Cookieshttps://www.joellipman.com/articles/_other-misc/how-to-make-chocolate-chip-cookies.html

30 September 2009 and eggs in a large bowl, then stir in flour, baking soda and salt. Add chocolate chips and pecans. That's it. That's your dough. Step 3: Drop Drop globs of dough, by rounded tablespoons, onto an parchment paper-lined cookie sheet. Leave about 2 inches...

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

Error during processing - Converting Date/Timehttps://www.joellipman.com/articles/database/t-sql/error-during-processing-converting-datetime.html

13 July 2010 I had to look at a previous report and it was just the way I was inserting the parameters into my query. Once you've added your parameters (date/time type): Right-click on the DataSet. Select 'DataSet Properties. Find your parameters in the Query. Check...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• 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 time of print v5.1) Visit http://dev.mysql.com/downloads/connector/ Click on "Connector ODBC" Download a version suitable to your system Install it Setup the ODBC Connection Start > Programs > Administrative Tools > Data Sources (ODBC) Click on the...

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

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

14 January 2011 Still deleting: Make sure you select "delete columns and associated groups": Overview: So the following screenshot is how your report should look now. Result: You can even run/preview it and you should get the below: Formatting In other words, making it...

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

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

04 February 2011 the first column then bring up the properties pane and scroll down to the "Fill > BackgroundColor" row and copy the value to your clipboard or notepad, etc. Then select all the remaining cells in the row and paste your expression in the "Fill >...

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

URL passed settings in Reporting Serviceshttps://www.joellipman.com/articles/microsoft/ssrs/url-passed-settings-in-reporting-services.html

11 February 2011 That's because I was using the Reporting Manager URL rather than the Reporting Server URL. Note: Change "" to the name of your Reporting Server Change "%2fMYREPORTS%2fDemos%2fRB+Report+for+Me" to the name and folder of your report. To hide all except...

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

MySQL: Find records in one table that are not in another.https://www.joellipman.com/articles/database/mysql/mysql-find-records-in-one-table-that-are-not-in-another.html

25 February 2011 that aren't listed in the audit table (articles yet to be approved). So this will be based on the SQL query to get just your articles from your MediaWiki CMS: -- to get articles from MediaWiki CMS: Let's call it STATEMENT1 SELECT wikimedia_page.page_id...

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

Room Availability Calendar in Business Intelligence Development Studiohttps://www.joellipman.com/articles/microsoft/ssrs/room-availability-calendar-in-business-intelligence-development-studio.html

23 March 2011 (DO NOT USE THE BELOW: this works for me and the timetabling system I have, you need to adjust how you get the values from your events database). First get the events from your database and then get the rooms: ), Events AS ( --Create some events to...

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

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

28 April 2011 forms in duplicate. Right above the signature line was a BIG BOLD WARNING ABOUT LOSS OF DATA and “Check this box to have your data backed up for $75. Then, I’d charge them $150 for “forensic data recovery” with “no guarantees” – while recovering from...

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

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

24 August 2011 Query > select Data Source Specify SQL Query: > Add Tables (not really just "close" this) > click on SQL button > Type/Paste your SQL Query > OK > Click on "Return Data" button Report Type: Select PivotTable Report > OK Design Table: Drag StaffName to...

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

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 the backgrounds based on whether they are the fastest or slowest in the set. Something like: The DataSet This should work on your reporting server as well. I'm using the database "ReportServer". select * from ( SELECT TOP 1 c.[Name] AS [ReportName] ,...

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

How to change local folder for TFShttps://www.joellipman.com/articles/microsoft/tfs/how-to-change-local-folder-for-tfs.html

08 March 2012 home directory. I tried the general settings (Tools > Options) but to no avail. How? The way to change this was: Connect to your Team Foundation Server (for me this was already done) Go to File > Source Control > Workspaces Edit... the workspace which...

• Type: Article
• Author: Joel Lipman
• Category: Team Foundation Server
• Language: *

Background Gradient Disappears on Long Pageshttps://www.joellipman.com/articles/web-development/css/background-disappears-on-long-pages.html

20 November 2012 above issue happened when using Google Chrome v23 or MS Internet Explorer v8 (so Webkit and MSIE appear to be affected). If your website consists of small pages then ignore this issue as it's unlikely to happen on your site.

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

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

01 February 2013 the download, then copy or move the JAR file (at time of print: mysql-connector-java-5.1.22-bin.jar) to the folder of your SQL Developer program Open SQL Developer, go Tools > Preferences > Database > Third Party JDBC Drivers and click on Add Entry......

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• 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 : (DT_DBTIMESTAMP)(SUBSTRING(Date,5,4) + "-" + SUBSTRING(Date,3,2) + "-" + SUBSTRING(Date,1,2) + " 00:00:00") So although your SSIS IDE (Visual Studio?) will give you a useless Microsoft message saying something like: Error: Data conversion failed while...

• 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 0, 1 count++ -- note for future use: ; if A_LoopFileAttrib contains H,R,S ; continue This works fine at home on your local host on a local drive. Try using this over a networked drive and more time will be spent counting the files then the actual...

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

Creating a custom form field type for Joomla XML fieldsethttps://www.joellipman.com/articles/cms/joomla/creating-a-custom-form-field-type-for-joomla-xml-fieldset.html

25 October 2013 and wanting to call my type "user_projects")!!! My recommendation is to remove any non-alphanumeric characters... In your component, create a PHP file in /administrator/models/fields/ (eg. "userprojects.php"). Rename "userprojects" with the name of your...

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

Problem creating SSRS report subscriptionshttps://www.joellipman.com/articles/microsoft/ssrs/problem-creating-ssrs-report-subscriptions.html

11 November 2013 the report can access the datasource (ask a DBA if you're unsure). Parameter-Driven DataSource In the folder where you put your Data Sources, click on the button "New Data Source" Specify the details, especially the connection string (which the system...

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