Information

 Steps to Upgrade the .net Framework to 4.7.2 OR 4.8 1. First Download the .NET Framework from https://dotnet.microsoft.com/download/dotnet-framework   2. Install on the Server. 3. Login to the Plesk and go to "Tools & Settings" > "Server Components" and refresh the components using the refresh button 4. After update, it will reflect in "Web Script" section at the server component page. All done!!!

We can use Case and   CHARINDEX  to split column with delimiter into two columns in SQL Server select case when CHARINDEX ( '_' , name )> 0 then SUBSTRING ( name , 1 , CHARINDEX ( '_' , name ) -1 ) else name end firstname, CASE WHEN CHARINDEX ( '_' , name )> 0 THEN SUBSTRING ( name , CHARINDEX ( '_' , name )+ 1 , len ( name )) ELSE NULL END as lastname from emp you can use CASE command to control is last name available. MS SQL Server : Query 1 : declare @t table ( id int , name varchar ( 50 )) insert into @t ( id , name ) values ( 1 , 'abc_rao' ) insert into @t ( id , name ) values ( 2 , 'nani' ) insert into @t ( id , name ) values ( 3 , 'hari_babu' ) insert into @t ( id , name ) values ( 4 , 'kalibabu' ) insert into @t ( id , name ) values ( 5 , 'ab_tan' ) select case when CHARINDEX ( '_' ...

Cancel a Pro (paid) subscription Sign in to the Zoom web portal. Click Account Management, then click Billing. Under the Current Plans tab, find the plan you want to cancel and click Cancel Subscription to stop your subscription's automatic renewal. Confirm your request by selecting Cancel Subscription. Choose why you would no longer like to renew your subscription. Once complete, click Submit. Your plan status will now be updated to Canceled. You will still have use of your paid plan for the remainder of your subscription term. (Optional) If you would no longer like to have the plan canceled, you will be able to reactivate your plan by selecting Reactivate Plan on the Current Plans page. Note: If it says Contact Sales instead of Cancel Subscription, you will need to contact our sales team or your Account Executive to have the plan canceled

In order to force a secure connection on our website, it is necessary to set up a certain HTTP/HTTPS redirection rule. This way, anyone who enters your site using a link like “domain.com” will be redirected to “https://domain.com” or “https://www.domain.com” (depending on your choice) making the traffic encrypted between the server and the client side. Steps to setup an IIS HTTPS redirect: Download and install the URL Rewrite module. Open the IIS Manager console and select the website you would like to apply the redirection to in the left-side menu: Double-click on the URL Rewrite icon. Click Add Rule(s) in the right-side menu. Select Blank Rule in the Inbound section, then press OK. Enter any rule name you wish. In the Match URL section: Select Matches the Pattern in the Requested URL drop-down menu Select Regular Expressions in the Using drop-down menu Enter the following pattern in the Match URL section: (.*) Check ...

Add password protection to your online store You can add password protection to your online store. Steps: From your Shopify admin, go to  Online Store  >  Preferences . Scroll to the  Password protection  area, and check  Enable password . In  Password , enter the password that you'll give to the customers who you want to be able to access your online store. Don't use the same password that you use to log into your admin. In  Message for your visitors , enter the message that you want to show on the password page. If you don't want to show a message, then leave this field blank. Click  Save .   Edit your password page settings You can edit the content that shows on your password page, such as the text, colors, and typography.   From your Shopify admin, go to  Online Store  >  Themes . Find the theme that you want to edit and click  Customize . Select  Password page  from the to...

In a web service, while converting a Base64 string to file, it is sometimes giving error  - "A generic error occurred in GDI+ while creating image from Base64 string". Solution: I have used the below code and problem resolved. [ HttpPost] public ActionResult UploadSignatureTwo(String imageString){          var bytes = Convert.FromBase64String(imageString);      using (var imageFile = new FileStream(Path.Combine(path,"test.jpeg"), FileMode.Create))      {          imageFile.Write(bytes, 0, bytes.Length);          imageFile.Flush();      } }

Cannot upload SVG files in WordPress When we upload the SVG file, we recieve the notification  “Sorry, this file type is not permitted for security reasons.” To Resolve this issue, we need to add the below function in the functions.php files function cc_mime_types($mimes) { $mimes['svg'] = 'image/svg+xml'; return $mimes; } add_filter('upload_mimes', 'cc_mime_types'); This will resolve the issue.

Wordpress, Gravity form - Remove space between currency symbol and amount Remove space between currency symbol and amount Please use the below WordPress in the theme Function (functions.php) file add_filter('gform_currencies', 'update_currency'); function update_currency($currencies) {     $currencies['GBP'] = array(         'name' => __('Pound', 'gravityforms'),         'symbol_left' => '£',         'symbol_right' => '',         'symbol_padding' => '',         'thousand_separator' => ',',         'decimal_separator' => '.',         'decimals' => 2);     return $currencies; } Change Currency symbol from left to right Please use the below WordPress in the theme Function (functions.php) file: add_filter('gform_currencies', 'update_currency'); function update...

WordPress Yoast, Change breadcrumb trail from  to page Please use the below WordPress in the theme Function (functions.php) file add_filter('wpseo_breadcrumb_links', 'wpse_post_breadcrumbs'); // $links are the current breadcrumbs function wpse_post_breadcrumbs($links) {     // Use is_singular($post_type) to identify a single CPT     // This assumes your CPT is called "post" - change it as needed  if(is_singular('post')) {         // The first item in $links ($links[0]) is Home, so skip it         // The second item in $links is Projects - we want to change that         $links[1] = array('text' => 'News', 'url' => '/news/', 'allow_html' => 1);     }     // Even if we didn't change anything, always return the breadcrumbs     return $links; }

htaccess 301 redirect from one pages to another page 301 Redirect from page1 to page2 please use the below code in the htaccess file: RewriteEngine On Redirect 301 /page1/ /page2/ RewriteBase / RewriteRule ^index\.php$ - [L] RewriteCond %{REQUEST_FILENAME} !-f RewriteCond %{REQUEST_FILENAME} !-d RewriteRule . /index.php [L]