Here are a few examples of how you can use the search feature:

Entering this and that into the search form will return results containing both "this" and "that".

Entering this not that into the search form will return results containing "this" and not "that".

Entering this or that into the search form will return results containing either "this" or "that".

Search results can also be filtered using a variety of criteria. Select one or more filters below to get started.

Assuming where is required, the following 228 results were found.

  1. List MediaWiki Articleshttps://joellipman.com/articles/cms/mediawiki/list-mediawiki-articles.html

    is extra to your standard MediaWiki setup and one that was customized for my day job). Thought I already had this somewhere on my site, so it took a while again but I've posted my finished query here: The base query to list mediawiki articles Page ID,...

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

  2. Performance Report - Background colors based on dataset valueshttps://joellipman.com/component/content/article/green-red-background-colors-based-on-dataset-values.html?catid=75&Itemid=165

    says straight away 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...

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

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

    t1.Date Date FROM ( SELECT MAX(a.VisitorID) ID, a.VisitorIP IP, a.DateTimeStamp Date FROM custombu_stats_visits a WHERE YEAR(a.DateTimeStamp)='2010' GROUP BY a.VisitorIP ORDER BY MAX(a.VisitorID) DESC ) t1 LEFT OUTER JOIN wikimedia_user b ON...

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

  4. Generate Academic Calendar using MySQLhttps://joellipman.com/articles/else/database/mysql/generate-academic-calendar-using-mysql.html

    INTERVAL 4 DAY), '\%e-\%b-\%y') AS Fri, WEEKOFYEAR(calendar.StartDate) AS CalendarWeek FROM joes_weekstructure calendar WHERE calendar.SetID=( SELECT acyear.SetID FROM joes_weekstructure acyear WHERE NOW() >= acyear.StartDate ORDER BY acyear.StartDate...

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

  5. Delete related records from multiple tableshttps://joellipman.com/articles/else/database/mysql/delete-related-records-from-multiple-tables.html

    So this is a quick article on how to delete from multiple tables in a mySQL database where we use some JOIN statements. Why? It is never recommended to delete from multiple tables and instead to use the system you were given. Given a Relational Database...

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

  6. MySQL Transactions in PHPhttps://joellipman.com/articles/else/database/mysql/mysql-transactions-in-php.html

    a group of queries are all executed successfully to maintain the integrity of our data. Let's say we have a banking app where we need to subtract funds from one account and add funds to another: $mysqli->query ("UPDATE 'accounts' SET 'balance' =...

    • Type: Article
    • Author: Ike Francis
    • Category: MySQL
    • Language: en-GB

  7. Forum Ruleshttps://joellipman.com/component/content/article/forum-rules.html?catid=50&Itemid=165

    Breaking rules result in punishments. There are several types of punishments: Warning - This is where a public announcement is made that mentions your name and that you have broken a rule. I will determine whether you knew what you were doing was wrong...

    • Type: Article
    • Author: Joel Lipman
    • Category: Static Items
    • Language: *

  8. Zoho Templates - Font size is inexplicably tinyhttps://joellipman.com/articles/crm/zoho/zoho-crm/zoho-templates-font-size-is-inexplicably-tiny.html

    This is an article resolving an issue where a template will shrink all the text when in PDF preview. Why? Ok doesn't need a song and dance about it, but I went home yesterday downtrodden by an issue which I'd been working on for most of the day where I...

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

  9. Zoho Survey & Zoho Analytics: Query to generate individual responses and grouped pageshttps://joellipman.com/articles/crm/zoho/zoho-analytics/zoho-survey-zoho-analytics-query-to-generate-individual-responses-and-grouped-pages.html

    Variables (Zoho Survey)" r3 ON r2."ID" = r3."Respondent ID" LEFT JOIN "Pages (Zoho Survey)" p ON r."Page ID" = p."ID" WHERE p."Title" 'GENERAL' ORDER BY "Response Date" DESC, "Attempt ID", "Page Number", "Question Number" You can take out the order by...

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

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

    Login to your Joomla database using your MySQL database manager (eg. phpMyAdmin, MySQL Workbench) Open the #__assets table where #_ is the Database Tables Prefix value found by logging into your Joomla admin panel Browse to Site > Global Configuration >...

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

  11. Upgrading Joomla CMS version 3.x to Joomla CMS 5.xhttps://joellipman.com/articles/cms/joomla/upgrading-joomla-cms-version-3-x-to-joomla-cms-5-x.html

    Data Migration using SQL files: Import Categories: export SQL file and amend the insert(s) into the new table `#_categories` where `id` > 7 Add column in #_content just before note called `xreference` VARCHAR(50) allows NULL. Import Content (articles):...

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

  12. Report Builder 2.0 - Hide Series1https://joellipman.com/component/content/article/report-builder-20-hide-series1.html?catid=75&Itemid=165

    in your SQL Server Reporting Service (SSRS) report. I am guessing that Series1 is the data series from an outer join where the joining index value is null. The chart below has 3 series or data fields: Count the total number of incidents logged (Y-axis -...

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

  13. SSRS Hide results table if emptyhttps://joellipman.com/component/content/article/ssrs-hide-results-table-if-empty.html?catid=75&Itemid=165

    added the equipment info on the system), it just showed the heading "Equipment". Iteration in T-SQL? Unlike good old MySQL where you can do iteration within the query (SELECT @ncount:=@ncount+1), we're stuck with T-SQL. Ask Google how to iterate in...

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

  14. Returning Oracle Stored Procedure Resultset in SSRShttps://joellipman.com/component/content/article/returning-oracle-stored-procedure-resultset-in-ssrs.html?catid=75&Itemid=165

    the student ID based on the inputted parameter SELECT student_accounts.student_id INTO p_STUDENT_REF FROM student_accounts WHERE student_accounts.student_username = p_STUDENT_ADNAME; -- opening cursor for the select query that I want to display in SSRS...

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

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

    INT(4)) AS FinancialYear FROM [dbo].[XML_EVENTS] -- Returns attribute "financialyear" of CURRENT_EMPLOYEE (eg. "2014") In a WHERE clause To select records matching a value for the XML field: SELECT * FROM [dbo].[XML_EVENTS] WHERE CAST(Event_XML AS...

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

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

    double the number of columns. My Solution SELECT title, intro FROM ( SELECT `title`, `introtext` intro FROM `jos_content` a WHERE a.state=1 UNION ALL SELECT `name` AS title, `description` AS intro FROM `jos_hp_items` b WHERE b.published=1 ) t1 Resulting...

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

  17. Licence GNU/GPLhttps://joellipman.com/component/content/article/licence-gnugpl.html?catid=50&Itemid=165

    the software. The systematic pattern of such abuse occurs in the area of products for individuals to use, which is precisely where it is most unacceptable. Therefore, we have designed this version of the GPL to prohibit the practice for those products....

    • Type: Article
    • Author: Joel Lipman
    • Category: Static Items
    • Language: *

  18. Zoho Deluge - Update Creator from CRMhttps://joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-update-creator-from-crm.html

    workflow written in a Deluge Script held in ZohoCRM. Why? I've also started this article to document an issue we encountered where our code was as per the documentation provided, and the responses returned as successful, but the target fields did not...

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

  19. Zoho CRM: Get Unique Values of a Text Fieldhttps://joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-get-unique-values-of-a-field.html

    how to return a list of unique values in a particular field in a CRM module. Why? My use-case is a data-migration where the records exist in a staging module in CRM but I want to transform/translate one of the column values into the target How? So this...

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

  20. ZohoCRM: Import Attachmentshttps://joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-import-attachments.html

    fields were mapped. Amazing but not as useful as it is interesting: Then you're into the penultimate step of the migration where you watch another but different progress animation which is possibly all your data being mapped, associated, and imported......

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
Results 21 - 40 of 228