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 { $string_formatted = str_replace( $mystring, ''.$mystring.'', $string_formatted); } } Replace all $wordpart1_wordpart2 (allow underscores) Convert: Hello $New_World » Hello $New_World $string_formatted = preg_replace( '/\$[a-z_]+/i','$0',...

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

T-SQL concatenate an incremental row numberhttps://www.joellipman.com/articles/database/t-sql/t-sql-concatenate-an-incremental-row-number.html

24 May 2013 an error which can only be seen when using more records and more employees. PARTITION BY So a sort of "group" action will allow this if we add "PARTITION BY" to the ROW_NUMBER() statement: SELECT q.Employee AS EmployeeNo, RIGHT('000' + CAST(q.Employee...

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

Client Services: Website Development Agreementhttps://www.joellipman.com/static-items/client-services-website-development-agreement.html

15 November 2013 me how long it took to setup a website previously, and will plan the same again). My 15 years of web-development experience allow me to reduce the risk of nasty surprises and also allows me not have to Google search every solution. As an IT developer, I...

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

JComments 2.3.0 with ReCaptcha in Joomla 2.5.xhttps://www.joellipman.com/articles/cms/joomla/jcomments-2-3-0-with-recaptcha-in-joomla-2-5-x.html

20 March 2014 > Captcha - ReCaptcha Check "Public Key" contains your key. STEP #3: Enable admin option dropdown This is a code change to allow the admin to select recaptcha. Open the file \administrator\components\com_jcomments\admin.jcomments.php (line 1066) Replace...

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

ReCaptcha alternative: Integrate PlayThru in JComments 2.3 for Joomla 2.5https://www.joellipman.com/articles/cms/joomla/recaptcha-alternative-integrate-playthru-in-jcomments-for-joomla.html

24 March 2014 Upload the files to \components\com_jcomments\libraries\ayah STEP #3: Enable admin option dropdown This is a code change to allow the admin to select PlayThru. Open the file \administrator\components\com_jcomments\admin.jcomments.php (line 1066) Replace...

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

ReCaptcha alternative: Integrate PlayThru in JComments 3.0 for Joomla 3.2https://www.joellipman.com/articles/cms/joomla/recaptcha-alternative-integrate-playthru-in-jcomments-3-0-for-joomla-3-2.html

27 April 2014 Upload the files to \components\com_jcomments\libraries\ayah STEP #3: Enable admin option dropdown This is a code change to allow the admin to select PlayThru. Open the file \administrator\components\com_jcomments\models\forms\settings.xml (line 398)...

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

A quick run through of setting up an export process in SITShttps://www.joellipman.com/articles/web-development/xml/a-quick-run-through-of-setting-up-an-export-process-in-sits.html

21 August 2014 up the Stu-Talk Message Group (SMG) This should be done before continuing as the remaining screens will refer to this and allow you to specify the related SMG Run SMG from the menu system Enter a CODE (in our demo "CAPCHG") Enter a Short Name (unsure of...

• Type: Article
• Author: Joel Lipman
• Category: Extensible Markup Language
• Language: *

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

24 October 2014 data from api.openweathermap.org and the flight restriction details from api.joellipman.com (my own personal website). This allows me to continually add data to the api of my own website without needing to redistribute or update this app....

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

Android: Replace return key with done, go, send...https://www.joellipman.com/articles/google/androidos/android-replace-return-key-with-done-go-send.html

03 November 2014 // um... textPhonetic // text that will sound like number // changes keyboard to numeric numberDecimal // allow a decimal number phone // enter a phone number datetime // enter a date and time date // selectable date time // selectable time...

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

Android: Function to let user take photo or choose existinghttps://www.joellipman.com/articles/google/androidos/android-function-to-let-user-take-photo-or-choose-existing.html

04 November 2014 A quick article on a function to allow the user to take a photo using their built-in camera or to choose an existing photo from their gallery. Why? I wanted both options to be available to the user and for it to replace a displayed image in an...

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

Google Authentication - OAuth 2.0 using PHP/cURLhttps://www.joellipman.com/articles/google/google-authentication-oauth-2-0-using-php-curl.html

31 October 2018 This is an article which lists the functions necessary to process Google Authentication using OAuth2.0. These functions allow a script to simply be loaded and to either create a token file, or use the existing one as long as it hasn't expired. Update...

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

Excel - Check a column for values found in another columnhttps://www.joellipman.com/articles/microsoft/excel/excel-check-a-column-for-values-found-in-another-column.html

14 February 2019 following: A B --------------- --------------- seize spell fence total thank fight noise terms thigh tasty light swarm shelf allow unity press board wreck shake decay Sheet2 contains the following:: A --------------- warm noise term wreck The formula to...

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

CSS Printing - Page Break Inside with Headers and Footershttps://www.joellipman.com/articles/web-development/css/css-printing-page-break-inside-with-headers-and-footers.html

22 February 2019 How? By spending a lot of time spinning on my chair and twiddling my thumbs... Firstly, set the page CSS: This will allow 3cm from the top for a header and 2cm from the bottom for a footer. @page { size: A4; margin: 3cm 1cm 2cm 1cm; } @page :first {...

• Type: Article
• Author: Joel Lipman
• Category: Cascading Stylesheets
• Language: *

Zoho Deluge: Get Image Uploaded in Creator Formhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-get-image-uploaded-in-creator-form.html

14 July 2020 Note Just as a note to do the reverse: upload an image given a URL to an image field (prerequisite: enable the field to allow Image as "Link" not just "Local Computer" or "Camera"): for each r_Image in m_Product.get("images") {...

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

Windows 10: Shortcut Apps to Settingshttps://www.joellipman.com/articles/microsoft/windows-os/windows-10-shortcut-apps-to-settings.html

30 July 2020 can be run from the command-line in an AutoHotkey app to open the notifications page of the Windows 10 Settings panel to allow users to enable/disable notifications. Why write this article when there's a perfectly ok post on the Microsoft website? Well...

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

Zoho Creator: Create a Widget which uses JavaScripthttps://www.joellipman.com/articles/crm/zoho/zoho-creator-create-a-widget-which-uses-javascript.html

24 October 2020 as well as other JavaScript functionality. Why? Quite simply that at time of print (2020-10-24), Zoho Creator does not allow you to use JavaScript anywhere in its app. HTML and CSS are mostly allowed but JavaScript automatically gets removed from any of...

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

Zoho People: Reject an Application for Leave in Deluge based on Criteriahttps://www.joellipman.com/articles/crm/zoho/zoho-people-reject-an-application-for-leave-in-deluge.html

10 December 2020 the brief, and having written many custom functions for other Zoho apps, it would stand to reason that the process would be: allow a user to apply for leave, then on save/submit, auto approve/reject the application based on a custom function that could...

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

Zoho Projects: Add a Time Log to an Issue using Delugehttps://www.joellipman.com/articles/crm/zoho/zoho-projects-add-a-time-log-to-an-issue-using-deluge.html

30 April 2021 Zoho refer to Issues as "Bugs". Why? At time of this article (Apr-2021), we could not find a working example that could allow us to do this. I have provided some links at the end of this article for you which we tried to use but only helped us out about...

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

Zoho Deluge: Zoho Bookings Get Available Slotshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-zoho-bookings-get-available-slots.html

23 June 2021 from within Creator. This one focuses on getting the available slots. Why? This is for a Creator app which had a form to allow customers to make a booking based on the configuration and appointments in a ZohoBookings instance. How? The getAvailableSlots...

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

Zoho Creator: Prevent Endless Loops On User Input of a Fieldhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-prevent-endless-loops-on-user-input-of-a-field.html

19 September 2021 Then I would tell Audit_Change to only trigger the workflow if it had waited about 5 seconds till after this datetime to allow auto-updates to happen. This method is fine for 1 or 2 fields and if your workflows only trigger when the form first loads...

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