Counting the occurence of a word within a string: Benchmarkhttps://www.joellipman.com/articles/web-development/php/counting-the-occurence-of-a-word-within-a-string-benchmark.html

06 September 2009 Storyteller" went and carried out a benchmark test on the most popular ways of counting the occurrence of a specific word within a string of text. Source: http://hasin.wordpress.com/2007/04/30/c … functions And the result is First Run Count by...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: *

Link to a Joomla article from within another articlehttps://www.joellipman.com/articles/cms/joomla/link-to-a-joomla-article-from-within-another-article.html

04 December 2012 What? Quick article here as googling/binging for how to refer to Joomla articles after versions 1.5.x wasn't obvious. This article is to demonstrate how to write the webaddress for a Joomla article even when you have Search-engine-friendly website...

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

A for loop within a for loop in MS-DOShttps://www.joellipman.com/articles/automation/ms-dos/a-for-loop-within-a-for-loop-in-ms-dos.html

03 October 2013 What? A quick note for myself as I'd forgotten how to do this (we're talking technology belonging to the 90s - MS-DOS v6.22). The example wants to loop through a directory and then loop through the line it finds. Why? I use another technology for...

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

Accessing a MySQL Database with Business Intelligence Development Studiohttps://www.joellipman.com/articles/database/mysql/accessing-a-mysql-database-with-business-intelligence-development-studio.html

05 January 2011 wondering what was I trying to achieve? I've written this article because this is how I connected to a MySQL database from within the Business Intelligence Development Studio (BIDS) IDE from Microsoft. Required: Windows XP (ODBC Data Source...

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

Regular Expression Basic Usage Exampleshttps://www.joellipman.com/articles/web-development/regular-expression-basic-usage-examples.html

28 October 2013 match: aa Interval — Between Count You use the between-count interval operator to search for a number of occurrences within a specified range. For example, to find where 'a' occurs at least 3 times and no more than 5 times, you use the following...

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

XML Schema Referencehttps://www.joellipman.com/articles/web-development/xml/xml-schema-reference.html

13 August 2014 to be used in complex type definitions choice Allows only one of the elements contained in the declaration to be present within the containing element complexContent Defines extensions or restrictions on a complex type that contains mixed content or...

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

T-SQL Record Separatorhttps://www.joellipman.com/articles/database/t-sql/t-sql-record-separator.html

11 October 2011 like the record separator in Oracle SQL*Plus where a row of data (blank or made of symbols) separates two sets of data from within the same select query based on a column that's different. So for example, I have data like the following: SELECT...

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

Quadcopter App with Flight Restrictions (JQA)https://www.joellipman.com/component/content/article/quadcopter-app.html?catid=40

24 October 2014 Flight Regulations API v0.9 version 0.9: Last Modified 2014-11-05 12:08:42 ccTLD is assigned from an entry within searched location (db must return at least 1 zone to know what country it is in - future development will be separate: convert lat/lng to...

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

ZohoCRM: Daily Follow Up and Remind Record Owner to Convert Leadhttps://www.joellipman.com/articles/crm/zoho/zohocrm-follow-up-and-remind-record-owner-to-convert-lead.html

14 May 2024 ensure I never spend this long on such a request again. The brief is: "Follow up when a lead is created and not converted within 1 day send an email and notification to sales person everyday for 3 days then escalate to a specified user". Why? Sorry...

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

Create Read-Only Database User in SQL Serverhttps://www.joellipman.com/articles/database/create-read-only-database-user-in-sql-server.html

09 November 2010 a database. db_denydatareader Members of the db_denydatareader fixed database role cannot read any data in the user tables within a database. db_denydatawriter Members of the db_denydatawriter fixed database role cannot add, modify, or delete any data...

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

PHP & MySQL Search Enginehttps://www.joellipman.com/articles/web-development/php/php-a-mysql-search-engine.html

09 March 2011 $str = str_replace(' ', ' ', $str); // replace any double-spaces with a single-space return $str; } # highlight terms within search results function search_highlight($text, $terms_rx){ $start = '(^|)'; $end = '($|)'; return preg_replace(...

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

SSRS Hide results table if emptyhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-hide-results-table-if-empty.html

29 March 2011 ask is the data value reliable if it's blank? The long way of doing this I would have called this article "Iteration within SQL Server Reporting Services Business Intelligence Development Studio (BIDS) version 2008 through combining Transact-SQL and MDX...

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

SSRS Parameters in Oracle Stored Procedurehttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-parameters-in-oracle-stored-procedure.html

02 September 2011 a workaround. So this is regarding an error when trying to add parameters to a Stored Procedure of an Oracle database from within Microsoft SQL Server Reporting Services. The Error ORA-00911: invalid character ORA-06512: at "SYS.DBMS_UTILITY", line 114...

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

SSRS External Images don't displayhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-external-images-dont-display.html

19 September 2011 Reporting Server (SSRS) running on Windows Server 2003 Team Foundation Server 2010 (TFS) Problem #1: Image does not appear within SSRS When previewing the report in BIDS, the photo appears fine. If we deploy the report to our Reporting Server and...

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

Basic Oracle Stored Procedure Structurehttps://www.joellipman.com/articles/database/pl-sql/basic-oracle-stored-procedure-structure.html

16 January 2012 stored procedure, I'd imagine you just get rid of the cursor. Why A standalone query is faster in the eyes of SSRS, however within SSRS we don't have the capability to run standard PL/SQL commands... unless they're run from within a stored procedure....

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

Prefix Line Numbers in a Text Filehttps://www.joellipman.com/articles/automation/ms-dos/prefix-line-numbers-to-a-text-file.html

18 July 2012 need is one command-line. Why? Working with programming languages, I often need to write the accompanying documentation. Within the documentation, I may want to refer to a line of code within a text file. I also find myself copying amounts of code into...

• Type: Article
• Author: Joel Lipman
• Category: MS-DOS
• Language: *

Licence GNU/GPLhttps://www.joellipman.com/static-items/licence-gnugpl.html

03 April 2009 impose on those licensors and authors. All other non-permissive additional terms are considered “further restrictions” within the meaning of section 10. If the Program as you received it, or any part of it, contains a notice stating that it is governed...

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

Zoho Deluge - Get Refresh/Access Token API v2https://www.joellipman.com/articles/crm/zoho/zoho-deluge-get-refresh-access-token.html

17 July 2019 A sorta quick article to note how I can generate refresh tokens and access tokens using Zoho Deluge code (so within Zoho Creator, CRM or Books) without XML calls. Why? I find myself using this more and more now that API v1 is on the way out and Zoho...

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

Zoho Creator: Radio group into Calendar Carouselhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-radio-group-into-calendar-carousel.html

09 March 2022 div.zc-Calendar_Day_Select .choice-table-cell span label:nth-child(3){width:75px;} Then I format the value within the span to make the date more prominent: div.zc-Calendar_Day_Select .choice-table-cell span label:nth-child(3)...

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

Zoho Books: Generate Bank Text File for Downloadhttps://www.joellipman.com/articles/crm/zoho/zoho-books-generate-bank-text-file-for-download.html

02 October 2023 (as in browser downloads it to the computer immediately) and then removed from wherever it was downloaded from... All within ZohoBooks without using any other apps or software. How? Here's how to use it: Staff member clicks on button File downloads to...

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