While working on a problem recently, I needed to enable the MS SQL extensions in WAMP. It turned out to be more complicated than simply hitting the checkbox in the Extensions menu… I found this great post which explained the process.. http://forum.ragezone.com/f724/get-wamp-work-mssql-673301/ The basic Idea is; Download ntwdblib.dll: HERE Click on the WAMP icon -> [...]
I regularly export table data from MySQL using PHP, however a question on StackOverflow.com came up where the user wanted to export data from MS SQL rather than MySQL.Handily, PHP has support for many of the same functions for MS SQL as it does for MySQL. So with a bit of reworking I was able [...]
While developing a shopping cart function for a client, I needed to restrict the user to entering numbers only in an Input fieldI came across this handy post;http://www.itjungles.com/javascript/how-to-use-javascript-to-force-numeric-value-in-textboxBasically, we need to add the following function to the JavaScript section; function isNumericKey(evt){ var charCode = (evt.which) ? evt.which : event.keyCode if (charCode > 31 && (charCode [...]
In order to validate an email address, use the following function; Public Function IsValidEmailAddress(ByVal EmailAddress As String) As Boolean Dim Expression As New System.Text.RegularExpressions.Regex("S+@S+.S+") If EmailAddress = "" Then Return True Else Return Expression.IsMatch(EmailAddress) End If End Function
For security reasons, Apache hosts enforce that, for a directory and it’s contents to be accessible from the web, the directory must contain an index.htm page. This can be overridden by adding a .htaccess file with the following lines included; ErrorDocument 401 "Unauthorized"DirectoryIndex index.php index.shtml index.html publish.htm publish.html