Google Charts - GeoMap vs GeoChart
GeoMap - The map is rendered in the browser using an embedded Flash player.GeoChart - Rendered using SVG
I noticed the GeoChart loads faster (at least in Chrome).
GeoChart - Rendered using SVG
I noticed the GeoChart loads faster (at least in Chrome).
"Object date(2012,10,4) has no method 'getTimezoneOffset'" Google Charts
This error was caused by not lowercase date in date(2012,10,4). It should be Date(2012,10,4).Sizeof() vs Count() in PHP
http://php.net/manual/en/function.sizeof.phpThey're the same. According to the link above: the sizeof function is an alias of: count().
PHP Date Variables
http://php.about.com/od/learnphp/ss/php_functions_3.htmThat's a helpful post for controlling the output of PHP's date().
Difference Between Echo and Print In PHP
http://stackoverflow.com/questions/3615679/what-is-basic-difference-echo-vs-print"echo can print more than 1 argument, print can only print 1 argument."
Triple Equals Sign In Php
http://stackoverflow.com/questions/80646/how-do-the-equality-double-equals-and-identity-triple-equals-comparisSince PHP uses $ to declare variables (and not int, etc), one can run into issues with an if statement being unintentionally true.
For example, 0 == null.
The triple equals sign (===) allows you to prevent these cases by only returning true if the two inputs are not the same type.
So, 0 === null is not true. Also, 0 === "0" is not true either.
SQLSRV30.EXE is not a valid Win32 application
If you want to install the PDO drivers for PHP 5.4, you will need to extract SQLSRV30.EXE with Winrar.Since I was using EasyPHP, I needed to extract the files into the following directory (there's also another php directory in EasyPHP, not sure why, but it's worth adding the files under "ext" there too): C:\Program Files\EasyPHP-12.1\php\php546x120827090829\ext
You will also need to add the following lines to your PHP.ini file under PHPExt:
extension=php_pdo_sqlsrv_54_ts.dll
extension=php_sqlsrv_54_ts.dll
Managing SQL Server 2008 with Management Studio 2005
When you google "SQL Management Studio", one of the first things that comes up is this (the 2005 version): http://www.microsoft.com/en-us/download/details.aspx?id=8961I recommend not installing 2005 if you have SQL Server 2008 Express installed! You will not be able to manage your 2008 server, and you will need to uninstall management studio to install the 2008 version here: http://www.microsoft.com/en-us/download/details.aspx?id=22985
Find Values With VBA
http://www.rondebruin.nl/find.htmThe above website has some great snippets of code which can:
Get Folder Path From User Input
This is some very useful code from Stack Overflow which allows the user to select a folder in VBA and reads the folder path into a variable. I'm currently making a macro which opens several XML files in a folder, and this will help users to input the folder where those XML files are located:
Sub SelectFolder()
Dim diaFolder As FileDialog
' Open the file dialog
Set diaFolder = Application.FileDialog(msoFileDialogFolderPicker)
diaFolder.AllowMultiSelect = False
diaFolder.Show
MsgBox diaFolder.SelectedItems(1)
Set diaFolder = Nothing
End Sub