Setting up your store to use SSLhttps://joellipman.com/articles/ecommerce/setting-up-your-store-to-use-ssl.html

11 September 2009 will either provide (or can offer) "Shared SSL" or the option to buy a "Dedicated SSL" certificate. Shared SSL means that your store will run using two domains your master domain name and shared secure domain which may be used by other customers of your...

• Type: Article
• Author: Joel Lipman
• Category: eCommerce Systems
• Language: *

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

15 September 2009 for Joomla 2.5.x Note that Joomla versions 1.6 upwards include this as an option in the global configuration settings which you can access using your Joomla admin panel: Template Manager Options Preview Module Positions -> Disabled or Enabled You will...

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

Some milestones for a website projecthttps://joellipman.com/articles/web-development/some-milestones-for-a-website-project.html

14 April 2010 The concept - typically drawings, words, models, code and basic prototypes that describe the nature, objectives and features of the website. Design document - a detailed plan of the website’s features and how it will display are generated from the...

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

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

22 October 2010 Extension I wrote for Joomla! displayed funny characters. The Joomla! articles were displaying the correct characters for that language set. I needed to make my extension read data from a MySQL database and display the caracters as intended with UTF8. I...

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

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

15 April 2011 problem The reason I'm doing this is for another system which decided to "cleverly" use the exports from CMIS Facility so that all the weeks correspond to the rest of the academic data. Unfortunately the developer wrote a system he felt would last the...

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

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

25 April 2011 Right Footer Situation The header displayed fine. The left and right columns finally got them side by side. But the footer that has a background image was under the left and right columns... The main content layer was overlapping the footer. I tried...

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

List all cron jobs for all usershttps://joellipman.com/articles/linux/list-all-cron-jobs-for-all-users.html

04 May 2011 little script I found on Stack Overflow. Wasn't really my solution as after 2 hours, realised that the customer had been looking at the wrong server. But this script showed me where the cron job we intended was located. #!/bin/bash # System-wide crontab...

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

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

03 August 2011 I'm looking for a SQL query that could do this all in one go and return all the results in one table. With PHP & MySQL it's pretty simple: use individual SQL queries to get the count of yesterday, yesterweek, yestermonth, yesteryear and do the layout in...

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

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

24 August 2011 but this was just a workaround and never a solution. Add in the ID of each entry as a field to pull from the database so that anyone can drilldown to the specific logged activity event (smallest unit of the drilldown). What's the problem? Enter this as...

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

Excel PivotTable Filter List Orderinghttps://joellipman.com/articles/microsoft/excel/excel-pivottable-filter-list-ordering.html

05 September 2011 2010, 2011, 2013, 2012. The Solution Bring up the field list of the report (so you see the fields panel) Untick the filter that is not in alphabetical order Click on the Refresh button Re-Tick the filter to add it back to the report Move this added...

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

Alternative method of displaying Unicode in Autohotkey GUIhttps://joellipman.com/articles/automation/autohotkey/alternative-method-of-displaying-unicode-in-autohotkey-gui.html

29 September 2011 use the Chr() function: msgbox % Chr(24) ; upwards arrow msgbox % Chr(25) ; downwards arrow, unstable Generate list of those that work for you: loop 255 fileappend,% a_index . A_Tab . A_Space . Chr(a_index) . "`n",ascii-chartable.txt A bunch of others...

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

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

25 November 2011 and your IT service desk say everything is functioning normally and it's just YOU! Script Function If you are on a network that frequently loses connection or simply forgets what intranet site you were trying to access and your usual solution is a...

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

SSRS Dropdown parameter cannot be blank!https://joellipman.com/articles/microsoft/ssrs/ssrs-dropdown-to-allow-blank-values.html

14 December 2011 I had to match the datatype used by our reporting server for the ItemID field which is some sort of hexadecimal ID value that Microsoft are so very fond of. You will need to use your own head to match the datatypes for including a dummy row. Also note...

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

DataJumble - Shuffling characters in a data valuehttps://joellipman.com/articles/database/t-sql/data-shuffling-function.html

01 August 2012 randomly, so I've renamed it DataJumble as opposed to my article on Data-Scrambling. Why? We want to scramble sensitive data that we send to suppliers for support or analysis. With inspiration from: "Obfuscating your SQL Server Data" by John Magnabosco...

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

Slideshow div layer through a windowhttps://joellipman.com/articles/web-development/mootools/slideshow-div-layer-through-a-window.html

11 September 2012 note to myself on the idea of a slideshow with the MooTools javascript framework. Basically, I want to create a div layer that I can see through (like a window with no glass) and for all the flashy stuff, to only appear within the boundary of the parent...

• Type: Article
• Author: Joel Lipman
• Category: MooTools Framework
• Language: *

Search a database for a string (MySQL, T-SQL)https://joellipman.com/articles/database/search-a-database-for-a-string-mysql-t-sql.html

08 October 2012 I have a PHP script which behaves like PhpMyAdmin, in that it automatically lists a database structure and the fields to modify similar to an excel spreadsheet. Now without using PHP, I need standalone SQL scripts that can simply be used to search an...

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

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

17 March 2013 list of all the IP ranges and their allocated country. Our use here was to create a refreshable country by IP address list that we can use when parsing our website logs to check where visitors were from. Note: we also use and love Advanced Web...

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

Joes Syntax Styler (JSS)https://joellipman.com/component/content/article/joes-syntax-styler-jss.html?catid=40

06 April 2013 other scripts but do I really need a complex solution? So here I am making my own again. I wanted something really basic that simply lets me style content within the tags: Use PHP or JavaScript (avoiding Framework conflicts) You select what words are...

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

Split a row into multiple rows based on a column valuehttps://joellipman.com/articles/database/t-sql/split-a-row-into-multiple-rows-based-on-a-column-value.html

23 August 2013 article on how to split a single row into multipe rows based on the value of a column in the same table. Why? I have a table that has all the days of sickness of employees. This table contains, which employee, on what date, and for how many days they...

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

Registered Users Cannot Login - Super Users Canhttps://joellipman.com/articles/cms/joomla/registered-users-cannot-login-super-users-can.html

26 February 2014 examine the database and a quick scan in the assets table revealed 3 assets had the parent_id = 0. Only one asset can have that and that is "root". Login to your Joomla database using your MySQL database manager (eg. phpMyAdmin, MySQL Workbench) Open...

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