First and Last Entry on a Page using Modulus Remainderhttps://joellipman.com/articles/web-development/php/first-and-last-entry-on-a-page-using-modulus-remainder.html

26 September 2011 loop, which entry was first and which was last. This is incredibly useful for pagination. The Situation I want the script to start writing a DIV layer in the code at the start of the loop (and at every first entry of a page). I want the script to close...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: *

Hide Menu Item from Registered and Special https://joellipman.com/articles/cms/joomla/hide-menu-item-from-registered-and-special.html

06 September 2009 admin interface with your website's style. The following is from http://forum.joomla.org/viewtopic.php?f=32&t=252258&start=0 at this date/time. Can't simply hide an item but can hide a menu (of course the menu could have been created with just one item...

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

Pancakeshttps://joellipman.com/articles/_other-misc/pancakes.html

07 July 2009 paper to smear it round before you make each pancake. Now get the pan really hot, then turn the heat down to medium and, to start with, do a test pancake to see if you're using the correct amount of batter. I find 2 tbsp is about right for an 18cm/7in...

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

Database Error: Unable to connect to the database: Could not connect to MySQLhttps://joellipman.com/articles/database/mysql/database-error-unable-to-connect-to-the-database-could-not-connect-to-mysql.html

25 September 2009 was OK. Basically after I use my website (using the default Joomla welcome template with NO modifications whatsoever) I start to get the "cannot connect to MYSQL." I contacted my webhost, and the problem is the number of MYSQL database queries. It goes...

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

Windows Live Messenger: Error 80048820https://joellipman.com/articles/microsoft/windows-os/windows-live-messenger-error-80048820.html

08 March 2010 This is an issue relating to the Time Server Synchronization error. Basically you start up windows live messenger and get the following error: {rokbox title=|Messenger Error 80048820|}/images/screenshots/windows_live_error_80048820.png{/rokbox}...

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

UTF8 Unicode PHP MySQL for International Charactershttps://joellipman.com/articles/web-development/php/utf8-unicode-php-mysql-for-international-characters.html

22 October 2010 to ASCII), they weren't what we were looking for. The quick solution was to make the script run a MySQL command at the start: SET NAMES 'utf8' Now I need to run this command from within a Joomla! extension using the mysql Joomla! classes, here's how...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB

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 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 System DSN tab Select "MySQL ODBC 5.1 Driver" > Finish Data Source Name...

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

Merge the content of two similar tables in MySQLhttps://joellipman.com/articles/database/mysql/merge-the-content-of-two-similar-tables-in-mysql.html

11 January 2011 the alias "AS" is optional in MySQL (think it's optional for most SQL forms). I found that to add further tables, simply start with another "UNION ALL" clause with a note to give the 3rd table a different alias to the 2nd (so "C" instead of "B"): SELECT...

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

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

23 March 2011 hours just to do the below... hopefully it will be quicker next time now that I noted it all down. The SQL Script: DECLARE @StartTime datetime, @EndTime datetime, @GivenDate datetime; SET DATEFORMAT dmy; SET @GivenDate = '23/03/2011'; --First slot of...

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

Joes Quicklist Weblinks (JQW)https://joellipman.com/component/content/article/joes-quicklist-weblinks-jqw.html?catid=40

03 July 2011 Effect" has to equal 1. If you put a fraction of 1, eg. 0.5, this will result in the thumbnail having 50% opacity to start with when the page loads; when you hover the mouse cursor over it the thumbnail will regain 100% opacity. Target Window: Rokbox?...

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

Run commands for Windowshttps://joellipman.com/articles/microsoft/windows-os/run-commands-for-windows.html

05 July 2011 intended for IT Support. It is a list of the system tools available in the Microsoft Windows OS that can be run from the "Start > Run" option. How? To Access… Run Command Accessibility Controls access.cpl Accessibility Wizard accwiz Add Hardware Wizard...

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

SSRS Querying on either of 2 Parametershttps://joellipman.com/articles/microsoft/ssrs/ssrs-querying-on-either-of-2-parameters.html

19 July 2011 can NOT be blank/null. End-users won't usually search based on the username (@StudentADAccount) if it wasn't provided to start with. Additionally, the second solution will mean each dataset must at least join both tables that you are using the OR clause...

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

SSRS Parameters in Oracle Stored Procedurehttps://joellipman.com/articles/microsoft/ssrs/ssrs-parameters-in-oracle-stored-procedure.html

02 September 2011 (reference) varchar2, Username (who's running the report) varchar2 and a JobID (request reference) number. The Report We start off with our detailed report page which lists all the details of a student. There is a textbox linked to an action which will...

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

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

25 November 2011 levels. Installation: 1) Decompress to a folder of your choosing 2) Run the EXE (there is no install process, it should just start) 3) Done! ChangeLog: v1.0 (22/11/2011) - Display internal and external IP address - Display flushdns errorlevel - Display...

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

Getting the mysql where in delimited string to workhttps://joellipman.com/articles/database/mysql/getting-the-mysql-where-in-delimited-string-to-work.html

02 January 2012 -- get total number delimeters and add 1 -- add 1 since total separated values are 1 more than the number of delimiters -- start of while loop WHILE(ctr

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

MySQL: Display Users and Duration in Matrix Timesheethttps://joellipman.com/articles/database/mysql/mysql-display-users-and-duration-in-matrix-timesheet.html

27 April 2012 Data Activities by employees with start dates and end dates in a mySQL database. Objective User Mon Tue Wed Thu Fri Sat Sun Total --------------- ------- ------- ------- ------- ------- ------- ------- --------- Me 09:00 07:30 08:00 07:00 06:00 00:00...

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

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

19 July 2012 Explorer, Right-click on a folder and select the action you named in step 6. For Windows 7: Open the system registry (Start > Run... > Type "REGEDIT" > OK) Navigate to My Computer\HKEY_CLASSES_ROOT\Folder\shell Create a new key with the action name (eg....

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

Search a database for a value and count matching rowshttps://joellipman.com/articles/database/search-a-database-for-a-value-and-count-matching-rows.html

05 November 2012 and execute it SELECT * FROM #CountRecordsPerTablePerCol; END Issues Consider adding a drop of the temporary table to the start of this script if you plan on running this successively against several databases: DROP TABLE #CountRecordsPerTablePerCol or...

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

Export/Import Database using MySQL Workbenchhttps://joellipman.com/articles/database/mysql/export-import-database-using-mysql-workbench.html

05 February 2013 left hand panel: In the screen that appears, select your database, specify to export to a Self-Contained File and click on Start Export: Importing Before importing a SQL file, check that nothing in it instructs it to use a specific database (otherwise...

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

Restore MSSQL Error: Database is in usehttps://joellipman.com/articles/database/restore-mssql-error-database-is-in-use.html

08 March 2013 > Database Specify the "to a point in time" if you don't want to restore from the most recent backup and double-check the "Start/Finish Date" is the one you want. OK Searches ssms restore database in use Cannot drop database because it is currently in...

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