JOEL LIPMAN Systems / Automation / AI

Knowledge base / Since 1999

Scripts, systems & field notes.

Practical solutions and technical notes from CRM platforms, workflow automation, APIs, databases and the systems around them.

Advanced search

477 entries / matching AI

Clear filters
Regular Expressions in SQL
Databases

Regular Expressions in SQL

Practice makes perfect. Or in my case, any practice is a start. This article serves as a quick note on how to use regular expressions within SQL statements: How? For the following examples, I am pretending to select rows from a table called `STUDENTS`.

Read note 25,362 hits
Joes Password Analyzer (JPA)
Product Documentation

Joes Password Analyzer (JPA)

What is Joe's Password Analyzer? Joe's Password Analyzer is an online tool that quickly checks any password you might want to try using and suggests variations on this. Simply type a word or phrase in the input field and let it do the rest. Background Joe's Password Analyzer is a Joomla 2.5.x component which simply dis...

Read note 25,633 hits
Generate a Timesheet in MySQL
MySQL

Generate a Timesheet in MySQL

This article is to remind me how to create a blank weekly timesheet which reads the duration of events from a database and auto-completes your timesheet.

Read note 34,642 hits
ReCaptcha disappears from Joomla 2.5 Registration
Joomla

ReCaptcha disappears from Joomla 2.5 Registration

This is an extract from a forum which solved our problem for why the ReCaptcha part disappears from the user registration form. We have Joomla 2.5.16 installed and no new updates for a plugin that comes with Joomla 2.5 install. How? Source: Joomla! • View topic - Cannot get recaptcha to display on registration form...

Read note 38,882 hits
SSRS Subscriptions cannot be created
SQL Server Reporting Services

SSRS Subscriptions cannot be created

This article describes solutions to the error: Subscriptions cannot be created because the credentials used to run the report are not stored, or if a linked report, the link is no longer valid. How?

Read note 35,639 hits
Problem creating SSRS report subscriptions
SQL Server Reporting Services

Problem creating SSRS report subscriptions

A quick article on if you are trying to create a new subscription to a SQL Server Reporting Server (SSRS) report and you are getting a warning message similar to the following: Message from webpage Subscriptions cannot be created because the credentials used to run the report are not stored, or if a linked report, the...

Read note 28,746 hits
Joomla Development: Possible XML Filters
Joomla

Joomla Development: Possible XML Filters

Applies to: Joomla! CMS 2.5.x Joomla Filter: Validation OnSave INT Forces the value to be an Integer UINT Forces the value to be an absolute number (-4.2 becomes 4.2) FLOAT Forces the value to be a floating point value BOOL Forces the value to be true or false WORD Strips anything that is not letters (including numbers...

Read note 21,522 hits

Working principle

Our Purpose

This site exists as a practical knowledge base built from real-world experience across systems, platforms, and technologies since 1999. Much of the content documents solutions, edge cases, and working patterns that were learned through investigation where documentation was incomplete or absent, and is shared to reduce the same friction for others.

27 Years in IT
1021 CRM clients
816 Site articles
30.0m+ Reads / hits

Knowledge base

Search notes

Find matching words in article titles and content.