Lazy stats: Yootheme / Gavick Pro / Rocket Theme Comparisonhttps://www.joellipman.com/articles/cms/joomla/lazy-stats-yootheme-and-gavick-pro.html

08 April 2010 providers. When I'm less caught up in work I'll try adding to this article. But here's some lazy stats: Package Comparison Table Personal Business Developer YooTheme 3 months 1 license Unlimited YOOtools 39 € ($53) 12 months 3 licenses Unlimited...

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

Joes Word Cloud (JWC)https://www.joellipman.com/component/content/article/module-joes-word-cloud-jwc.html?catid=40

13 October 2010 Download the appropriate file for your system (see compatibility table below) Login to your Joomla admin panel and install as per usual. How to Use Install the ZIP using your Joomla! Admin Panel > Extension Manager View the module on your front-end to...

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

Increment a column in MySQL using the UPDATE queryhttps://www.joellipman.com/articles/database/mysql/increment-a-column-in-mysql-using-the-update-query.html

18 February 2010 Suppose you have a column in your table that you use as a counter (storing the value of the counter - eg. times an article has been displayed). Basically what I used to do is something similar to the following: SELECT counter_field_value FROM table1...

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

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

22 October 2010 extension using the mysql Joomla! classes, here's how I've used in this script pulling IDs and titles from the a sample table: $db =& JFactory::getDBO(); $sql_utf8 = "set names 'utf8'"; $db->setQuery( $sql_utf8 ); $temp_result = $db->query(); $sql =...

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

SQL Queries for Statisticshttps://www.joellipman.com/articles/database/mysql/sql-queries-for-statistics.html

13 December 2010 5 columns: MediaWiki: number of unique guests, students and staff by month. Also associates a UserID to the wikimedia_user table to identify a user. SELECT CONCAT(MONTHNAME(t2.Date), ' ', YEAR(t2.Date)) Month, SUM(IF(t2.VisitorType='Staff', 1, 0))...

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

The ReportServer Databasehttps://www.joellipman.com/articles/database/the-reportserver-database.html

08 August 2011 NULL The ID of the report (looks like a hexadecimal SSID). It's the unique ID of the report but not unique in the table (can be referenced many times). UserName nvarchar(260) NULL Windows authenticated username and domain of the person running the...

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

Basic Oracle Function Structurehttps://www.joellipman.com/articles/database/pl-sql/basic-oracle-function-structure.html

15 January 2012 REPLACE] FUNCTION function_name [ (parameter [,parameter]) ] RETURN return_datatype IS | AS [declaration_section] BEGIN executable_section [EXCEPTION exception_section] END [function_name]; Example: My example accepts an Active Directory (AD) username...

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

Returning Oracle Stored Procedure Resultset in SSRShttps://www.joellipman.com/articles/microsoft/ssrs/returning-oracle-stored-procedure-resultset-in-ssrs.html

19 January 2012 credentials in data source) to run this stored procedure. CREATE PUBLIC SYNONYM sp_get_studentdetails_from_ad FOR base_table_owner.sp_get_studentdetails_from_ad; GRANT EXECUTE ON sp_get_studentdetails_from_ad TO my_ssrs_user; Notes: No "SELECT... INTO...

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

Quickly update all content in mySQL database replacing a stringhttps://www.joellipman.com/articles/database/mysql/quickly-update-all-content-replacing-a-string.html

03 February 2013 tags with . Not I want to switch these back. How? For demo purposes, I'm searching a column called introtext in a database table called MYTABLE_content. First let me find all the articles that need this change: SET @stringtoFind=' '; SET...

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

AwStats Data Parser (ADP)https://www.joellipman.com/component/content/article/awstats-data-parser-adp.html?catid=40

03 April 2013 by my infographic script which allowed quicker reports then scanning entire website visitor logs. No installation and USB portable. Currently runs using either Windows XP or Windows 7. How to use: Save a frame of your Awstats page (so there isn't the...

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

MS Excel - Sort pivottable column headings by datehttps://www.joellipman.com/articles/microsoft/excel/sort-pivottable-column-headings-by-date.html

12 April 2013 This is a quick note to myself so that I never use parentheses in the column headings again. Basically I have a pivot table in Microsoft Excel 2010 with the projects down the left (in the first column) and the days of the week along the top. Why? The...

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

Generate a Timesheet in MySQL https://www.joellipman.com/articles/database/mysql/generate-a-timesheet-in-mysql.html

05 December 2013 11:50:00 -- 2013-12-05 Thursday 10:00:00 11:30:00 -- 2013-12-06 Friday 07:00:00 09:00:00 This example is using a small table with very little sample data so do not expect it to reconcile with the requirement example. Note that we have two events on the...

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

T-SQL: Parse an XML valuehttps://www.joellipman.com/articles/database/t-sql/t-sql-parse-an-xml-value.html

27 March 2014 a separate file, it stores these in a row. How? Assuming the following data exists in the column "Event_XML" value of the table "XML_EVENTS": 123456 Mr J JOEL LIPMAN MALE 1990-01-01 SUPER SUPPORT TEAM GENERAL DOGSBODY 2014-03-01 Y INSERT 2014-03-27...

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

SSIS Multiple Lookups in onehttps://www.joellipman.com/articles/microsoft/ssis/ssis-multiple-lookups-in-one.html

05 August 2014 convert the data and output it to the target system. For our package to decode what "M" means, it needs to look this up in a table on the original server. We had around 12 lookups to do, so you could do this: But we didn't want to do this. How? As a...

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

Joes Quicklist Weblinks (JQW) Downloadshttps://www.joellipman.com/component/content/article/joes-quicklist-weblinks-jqw-downloads.html?catid=92

07 September 2015 Custom Order by Weblink ID - Date Uploaded: Thu, 2nd May 2013 2.1.2- Moved "More Links" text to Joomla language file (translatable) - Date Uploaded: Sun, 10th Mar 2013 2.1.1- Corrected alias reference to all columns irrespective of order settings. -...

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

Search and Replace in a MySQL Databasehttps://www.joellipman.com/articles/database/mysql/search-and-replace-in-a-mysql-database.html

17 March 2010 well that's usually me. Found it a bit boring but here's a short bit of code to speed it up which I now use: update table_name set field_name=REPLACE(field_name,'string_to_find','string_to_replace'); Source:...

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

Zoho Deluge: Loop through 30 Minute Slotshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-loop-through-list.html

30 November 2018 when the closing hour is found. The picklist field is called "Time_Field". The following reads from a form (creator data table) where thisServiceRecord.Opening_Time is returning an hour value (eg. "08:00") and thisServiceRecord.Closing_Time returns an...

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

CSS Ordered List 1, 1.1...1.10 Formatting and Alignmenthttps://www.joellipman.com/articles/web-development/css/css-ordered-list-1-1-1-1-10-formatting-and-alignment.html

10 July 2019 Item 1d 2. Item 2 How? I've been refining this based on several examples and the following solution seems to be the most stable: ol { list-style-type: none; counter-reset: myCounter; display: table; margin: 0; padding: 5px 0 5px 15px; } ol > li {...

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

Zoho Creator: info/alert/modal/popup notification for any userhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-info-alert-modal-popup-notification-for-any-user.html

06 November 2020 and the popup size will automatically resize based on content. I tend to use the first solution combined with a form/table of standard messages allowing the client to enter their own text to display to their users. A preset form/page with openUrl could...

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

Zoho Deluge: Sort a Map by a specific fieldhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-sort-a-map-by-a-specific-field.html

29 January 2021 date in descending order. Yes this functionality exists in reports but I want to do it in code so as to display it in a HTML table. What I have: id name date --------------------------------------------- 46498 Joel 1977-11-14T12:30:00+00:00 8949...

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