Day: March 12, 2012

Web

JavaScript case insensitive string match

Code: SELECT * FROM [SessionProfile].[dbo].[ReadableSessions] (nolock) where application like ‘%gmmev9%’ select u.userprincipalname, sp.stagename, sp.tmst from StageProgress sp (nolock) inner join ServerProfile servp (nolock) on sp.SessionId = servp.ProfileId inner join [User] u (nolock) on u.id = servp.UserId where sp.tmst > DATEADD("MINUTE", -5, getdate()) and u.userprincipalname like ‘%gmmob002%’ order by sp.tmst desc, u.userprincipalname     Output:

Read more
Web

JavaScript String Operations

Code: <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml">     <body>         <script type="text/javascript">             var wshShell = new ActiveXObject("WScript.Shell")             var sComputerName = wshShell.ExpandEnvironmentStrings("%COMPUTERNAME%")             var text_match = "GOVARDHAN"                         if(sComputerName.match(text_match))             //if(sComputerName.match("govardhan"))             {                 document.write("[" + sComputerName + "] String matched criteria: [" + text_match + "]");             } else {                 document.write("String Match failed");                 //document.write("<br /><br />Would you like to try again?<br /><br />");             }         </script>     </body> </html>     Output:

Read more
Server

Fix Error: Windows Could not search for new updates

  Windows Update error 80072ee2 If you receive Windows Update error 80072ee2 while checking for updates, you might need to add the website addresses from which Windows Update downloads updates to your firewall exceptions or "allow" list. Windows Firewall ships with this version of Windows and should already include these sites in the exceptions list. If you use a different firewall, check the information that came with the software to see how to add these websites to your firewall exceptions list: http://*.update.microsoft.com https://*.update.microsoft.com http://download.windowsupdate.com For more information on firewalls, see What is a firewall? or Understanding Windows Firewall settings. If […]

Read more