Assuming all is required, the following 342 results were found.
-
What? A ridiculously quick article on resolving a zoho.crm.getRelatedRecords() combined with a zoho.crm.bulkUpdate issue. Why? Trying to be clever and reducing the API calls to go through a few thousand records and to update the related records. I was...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
What? More for others than for myself, but this article is for those who do not have development/test environments of their Joomla website. I have been doing this for years and still come across clients who have the one version of their website. They...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
Applies to: Microsoft Business Intelligence Development Studio (BIDS) Visual Studio 2008 Microsoft Windows 7 Microsoft .NET Framework 3.5 Microsoft Visual C# 2008 What? So like lots of people on the net, I've been given a datasource with names and...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
What? 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...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
Are you getting a lot of spam, or junk messages sent via your Joomla site? I know certain components of Joomla let you put banned words but I know of even more that don't. If you find all your forms need extra plugins and captchas (such as...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
If you need to remove files which are simply the converted versions of music or video files, then this tool asks which folder has the files it will keep and which ones it will send to the Recycle Bin. TESTED ON: - Windows XP, Windows 7 SCREENSHOTS:...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
What? This is an article to document the migration of a Joomla! CMS running version 2.5.11 to an instance of Joomla! CMS version 3.4.1. I would consider the below instructions an ALPHA version as it is considered unstable for official use... Saying that...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
Why? I've recently written a report for SQL Server Reporting Services 2008 R2 (SSRS) which will compare up to 4 reports and will compare the time taken for each one. The breakdown or what I was able to measure with the default installation are the times...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
What? I have created an SSRS report which can compare 4 reports side by side and brings up their latest execution times to the nearest millisecond. The report has 4 parameters. Each parameter is a dropdown populated by a list of all available reports....
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
So I'm starting to get the impression that I no longer tender for brand new projects competing with time and cost in order to win the bids. Recently, more and more people have been asking if I can take over a project that has been abandoned by its...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
What? A quick reminder on basic regular expressions. Match Any Character — Dot The dot operator '.' matches any single character in the current character set. For example, to find the sequence--'a', followed by any character, followed by 'c'--use...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
The Situation I have a Microsoft Excel 2007 file that connects to a SQL Server 2008 R2 database. The Excel file pulls data using lookup tables and displays the data in an Excel Spreadsheet. The Problem We can select all cells and set row height to be 30...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
Typographyhttps://joellipman.com/articles/else/e-commerce/woocommerce/typography.html
H1 Heading example A wonderful serenity has taken possession of my entire soul, like these sweet mornings of spring which I enjoy with my whole heart. I am alone, and feel the charm of existence in this spot, which was created for the bliss of souls...
- Type: Article
- Category: Uncategorised
- Language: *
-
What? This is an article to serve as a guide in terms of styling a radio group into a group of Tabs. This is only a guide or reference which was applied for one client but would need adapting to match the colors or style the next client wants. Why? The...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
What? There are other sources on the web which show you how to deduplicate a contact but usually involve entering a customer name or other key to check if there are already records in the system with that key. I can't sit there entering one customer at...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
What? This is a quick article on generating a file with the Zoho Deluge function .toFile() and uploading it to a file upload field within Zoho Creator. Why? The use-case here is that we want a file to be hosted within Zoho Creator for use by a JS widget...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
What? An article for me or for whoever dares to upgrade their Joomla CMS from version 3 to version 5. Disclaimer: I'm used to doing this without any third-party extensions. I strongly recommend you do a backup beforehand of the database and of all your...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
Thought I'd put something here as a lot of my clients and friends are all surprised by the Aero features and weren't aware that these existed in Windows Vista (and originally from Linux variants). Sometimes you may only have partial Aero effects. This...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: en-GB
-
In standard SQL we can combine the contents of two tables with a CROSS JOIN, (BTW these are not instructions to create some table I'll never use again unlike the rest of the solutions I found on the web). In MySQL, I only know how to do this with a...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
What? 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...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *