CharIndex Reverse - find occurrence starting from end of string in TSQLhttps://joellipman.com/articles/database/t-sql/charindex-reverse-find-occurrence-starting-from-end-of-string-in-tsql.html

28 January 2013 SQL for a SQL Server instance only and not filtered by other code. Why? I have a string such as the following (column positions added for demo purposes): String1.String2.String3.String4 1 5 10 15 20 25 30 -> length = 31 I'd like to end up with just the...

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

Convert to Proper Case in T-SQLhttps://joellipman.com/articles/database/t-sql/convert-to-proper-case-in-t-sql.html

04 June 2014 @i, @CaseLen) -- replace it in the original text SET @Ret = REPLACE(@Ret, ' '+@CaseValue+' ', ' '+@CaseValue+' ') -- get position of next word SET @i = CHARINDEX(',', @CaseExceptions, @i+@CaseLen) +1 END -- remove any leading and trailing spaces SET...

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

CSS Center an iFrame Horizontally and Verticallyhttps://joellipman.com/articles/web-development/css/css-center-an-iframe-horizontally-and-vertically.html

23 September 2019 this case, also works on iframes: HTML: Horizontally and Vertically Centered Iframe CSS: body { background:red; } iframe { position: fixed; top: 50%; left:50%; transform: translate(-50%, -50%); } DEMO: See my JSFiddle demo:...

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

Zoho Creator: info/alert/modal/popup notification for any userhttps://joellipman.com/articles/crm/zoho/zoho-creator-info-alert-modal-popup-notification-for-any-user.html

06 November 2020 .zc-pb-tile-card{padding: 0px 20px 10px;} /* optional: move the close button to the top right of the modal */ .popupClose{position:relative !important;z-index:1000;top:28px;right:46px !important;} .fa.fa-close::before,.fa.fa-close::after{background:#999...

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

Zoho Creator: Change Radio into Tabshttps://joellipman.com/articles/crm/zoho/zoho-creator-change-radio-into-tabs.html

22 October 2021 to embed the form on to a page, you would be free to use some reserved CSS attributes on the page style rather such as position: absolute. Because I'm doing this inline and via code, Zoho automatically removes these. So instead, I am going to use...

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

Zoho CRM/Deluge: Get TimeZone Based on GeoCoded Address (Lat/Lng)https://joellipman.com/articles/crm/zoho/zoho-crm-deluge-get-timezone-based-on-geocoded-address-lat-lng.html

15 December 2021 l_Params.add("lat=" + r_GeoCode.get("latitude")); l_Params.add("lng=" + r_GeoCode.get("longitude")); l_Params.add("by=position"); } // // query with a GET method r_Timezone = getUrl("http://api.timezonedb.com/v2.1/get-time-zone?" +...

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

Zoho Analytics: Create a Monitoring System with Imageshttps://joellipman.com/articles/crm/zoho/zoho-analytics-create-a-monitoring-system-with-images.html

25 July 2024 displayed label to a constant text set to "CRM Account Data": I then click on the "image" sub tab and change the "Image Position" so that the image is under the text (personal preference here and completely optional): So now I can go back to my query...

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

Joomla banners not rotatinghttps://joellipman.com/articles/cms/joomla/joomla-banners-not-rotating.html

20 October 2009 horizontal and square banners. This means that you can have 3 modules each displaying banners from each category and position these as appropriate.

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

Gavick - How to add a navigation menu to Image Showhttps://joellipman.com/articles/cms/joomla/gavick-how-to-add-a-navigation-menu-to-image-show.html

07 April 2010 the menu/browsing interface button panel (well i had). This is how to make sure it shows on the template style and how to position it on the image slide show module that comes bundled with the extension.{youtube}qOWGxgyoqA4{/youtube}

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