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

28 October 2013 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 the...

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

Migrate JComments from Joomla 1.5.x to Joomla 2.5.xhttps://www.joellipman.com/articles/cms/joomla/migrate-jcomments-from-joomla-15x-to-joomla-25x.html

07 June 2012 (at time of print: Jcomments v2.3.0 on Joomla v2.5.4) Copy the below script to a text file Change the database names to match your setup Change the table name prefixes to match your setup Run the modified SQL script against your database. Note: It is...

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

Mootools - How to contain a menu sidebar between header and footerhttps://www.joellipman.com/articles/web-development/mootools/mootools-how-to-contain-a-menu-sidebar-between-header-and-footer.html

10 August 2012 component_top = $('jdo_overall').getCoordinates().top; var component_height = $('jdo_overall').getCoordinates().height; var match_lowest_y = component_height + component_top - menu_height; var match_highest_y = menu_highest_top + (component_top -...

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

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 … functions And the result is First Run Count by Split+Count took : 0.44112181663513 Seconds Count by Preg_Match+Count took : 0.46423101425171 Seconds Count by str_replace took : 0.23512482643127 Seconds Count By str_ireplace took : 0.39766597747803...

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

Preg_Replace all strings between two tagshttps://www.joellipman.com/articles/web-development/php/preg-replace-all-strings-between-two-tags.html

07 February 2013 » Hello @World $string_formatted = preg_replace( '/@[a-z]+/i','$0', $string_original); -- METHOD #2: equivalent using preg_match_all $matches = null; preg_match_all('/(?!\b)(@\w+\b)/',$string_original,$matches); foreach ($matches as $match) { foreach...

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

Migrating from Joomla 2.5.x to 3.4.xhttps://www.joellipman.com/articles/cms/joomla/migrating-from-joomla-2-5-x-to-3-4-x.html

12 September 2015 on its contents or embedded code specific to the template. Copy over Users: Rename the Admin ID in the new v34 system to match your v25 system. Check your usergroups are the same in both systems. Import new ones. Copy all users except the v25 admin to...

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

List all cron jobs for all usershttps://www.joellipman.com/articles/linux/list-all-cron-jobs-for-all-users.html

04 May 2011 spaces from the # beginning of each line. function clean_cron_lines() { while read line ; do echo "${line}" | egrep --invert-match '^($|\s*#|\s*[[:alnum:]_]+=)' | sed --regexp-extended "s/\s+/ /g" | sed --regexp-extended "s/^ //" done; } # Given a...

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

SSIS Script: convert UPPERCASE to Mixed-Case using TitleCasehttps://www.joellipman.com/articles/microsoft/ssis/ssis-script-convert-uppercase-to-mixed-case-using-titlecase.html

04 October 2013 I'm writing this article because other solutions on the net were either incomplete, did not work for me or simply did not match the requirements (do they ever?). The script must be able to be copied into other SSIS packages. Need the option to merely...

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

ZohoCRM to ZohoBooks API: Rounding the cents or pennies when creating an invoicehttps://www.joellipman.com/articles/crm/zoho/zohocrm-to-zohobooks-api-half-a-cent-or-penny-off-when-creating-an-invoice.html

20 March 2025 VAT / Tax, inclusive /exclusive, but in this case it is the rate that gets rounded. The numbers at the end still need to match what's in CRM and with ZohoBooks rounding differently can make cent/penny errors into 100s of dollar/pound errors. Zoho CRM...

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

Keyboard and mouse shortcuts in Google Chromehttps://www.joellipman.com/articles/google/keyboard-and-mouse-shortcuts-in-google-chrome.html

23 September 2009 your current page. Esc Stops the loading of your current page. Ctrl+F Opens the find bar. Ctrl+G or F3 Finds the next match for your input in the find bar. Ctrl+Shift+G, Shift+F3, or Shift+Enter Finds the previous match for your input in the find bar....

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

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

09 March 2011 '\\\$1', $string); } # function to list terms into list of regular expressions # eg. search for 'foo' matches 'a foo a' but not 'a food a'. function search_db_escape_terms($terms){ $out = array(); foreach($terms as $term){ $out[] = '[[::]]'; } return...

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

SSRS Dropdown parameter cannot be blank!https://www.joellipman.com/articles/microsoft/ssrs/ssrs-dropdown-to-allow-blank-values.html

14 December 2011 the label rather than the value field) to make this all work. Notes: My convert part of my SQL query is because I had to match the datatype used by our reporting server for the ItemID field which is some sort of hexadecimal ID value that Microsoft are...

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

Search a database for a value and count matching rowshttps://www.joellipman.com/articles/database/search-a-database-for-a-value-and-count-matching-rows.html

05 November 2012 We have a datawarehouse and we want to be able to count all the records in any table of the database that match on a particular warehouse load. This is a column value where the column is called "WarehouseLoadKey" and the value we want to search on is...

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

Warning: Save failed. Another menu item has the same aliashttps://www.joellipman.com/articles/cms/joomla/warning-save-failed-another-menu-item-has-the-same-alias.html

13 March 2015 alias "about_new") Login to your database and browse to the #__menu table Search for any values in the `alias` column that match the term (eg. for "about" do SELECT * FROM #__menu WHERE alias LIKE '%about%' where #_ is the table prefix) Instead of...

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

Zoho CRM/Creator - Common Errors & Gotchashttps://www.joellipman.com/articles/crm/zoho/zoho-crm-creator-common-errors-gotchas.html

06 February 2020 happen when trying to setup an OAuth connection: ERROR_Invalid_Redirect_URI Solution: The redirect URI in your app does not match the redirect used in the authorization request. They need to match in both irrespective of the value. Consider trying to...

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

Joel's Reference to MidJourney v4 Promptshttps://www.joellipman.com/graphic-design/joel-s-guide-to-midjourney-prompts.html

11 February 2023 to instruct the Midjourney Bot (or any other AI text-2-image generator) which the bot can break down into "tokens" and then match with its training data to generate the image. Quick recap on how to first start using the MidJourney Bot Signup to...

• Type: Article
• Author: Joel Lipman
• Category: Graphic Design
• Language: *

Zoho CRM: Change System Field Lengthhttps://www.joellipman.com/articles/crm/zoho/zoho-crm-change-system-field-length.html

19 June 2023 to an opportunity (or Deal) record. If you are using custom fields, then just ensure that the data type and field lengths match. In this case, they are system fields for the Postal Code which out-of-the-box differ in length so they do not list the...

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

Zoho Creator: Input Color Pickerhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-input-color-picker.html

14 October 2024 !important;}"; v_CssStyle = v_CssStyle + ".zc-Color_Picker .customRadio+label{display:none !important;}"; // make button match other inputs on the form v_CssStyle = v_CssStyle + ".zc-Color_Picker...

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

Anti-Spam override for all submitted datahttps://www.joellipman.com/articles/cms/joomla/anti-spam-override-for-all-submitted-data.html

03 February 2010 by Joomlaworks but if you did the sound version, it didn't work properly. I found that sometimes the captcha wouldn't even match what you typed and what it displayed!!! I have written this article to be another one of those programmer's tweaks. This is...

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

Running Internet Explorer 6, 7, 8 as standaloneshttps://www.joellipman.com/articles/microsoft/windows-os/running-internet-explorer-6-7-8-as-standalones.html

18 May 2010 Internet Explorer 7 As you can tell, not the most up-to-date but unfortunately I need to stay near to my customer base and match their setups as closely as possible. Objective My aim is to have IE 8 installed as my Windows browser (I wanted IE7 and the...

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: *