I needed to write a SQL command that will populate a new column that has just been introduced into a table but spent quite some time figuring how to do that using the INSERT INTO SQL statement. Instead of thinking about INSERT INTO, what was needed in this scenario is the UPDATE syntax.
[Read more…]
Download Microsoft Surface SDK
The Microsoft Surface team announced the broad availability of the Microsoft Surface Software Development Kit (SDK) Workstation Edition at Microsoft’s Professional Developers Conference 2009 (PDC09). Developers interested in the Microsoft Surface can now easily download the SDK software at no cost on the Microsoft Download Center (144.2MB) although developers still need to have the actual Microsoft Surface (hardware) to test their applications.
[Read more…]
How To Detect Web Visitors Geographic IP Country Location
Knowing which country your visitors are from is important when you’re promoting affiliate marketing offers as some offers will only allow you to promote to certain countries. There are at least 3 solutions which I’ve came across.
[Read more…]
Develop Remote PHP Application With Netbeans IDE
Netbeans IDE has been making lots of progress and it’s currently top of the list in building any any kind of desktop/web applications that you can imagine, Java, C/C++, PHP, Python, Ruby, HTMl, CSS, Javascript etc (minus .NET though). However, there’s strangely one deadly missing feature within the Netbeans IDE: you can’t browse, edit and upload files located remotely from your computer.
[Read more…]
List All Users and Roles From An Oracle Database
The following sql queries will return all users and roles of a oracle database.
[Read more…]
CakePHP: How To Code Custom Paginate Parameters In Controller’s Action
If you have just came across the paginate helper in the Cake Docs, it seems that you can only define a general var $paginate array at the top of your controller. Unless all your actions are going to paginate the same results the same way, defining a general var $paginate is not going to get you very far. Here’s how you can get more control of by defining how each of a controller’s action is going to paginate.
[Read more…]
Dot Net How To Copy Files + Exception Message
I was refering to the Visual Studio 2008 MSDN Documentation and found that there was a mistake in the documentation titled: How to: Copy Files with a Specific Pattern to a Directory in Visual Basic which would lead to a “The given path’s format is not supported” error if followed blindly.
[Read more…]
How To Kill A Process/Task From Command Prompt + .NET
I needed a way to kill a windows process/task programatically and wondered what could be the best way to do so. By process/task, I mean an entry that can be found under “task manager” (through CTRL-ALT-DEL). Don’t confuse that with services which are different things that you can see by running services.msc.
[Read more…]
Migrate Access, SQL Server, MySQL and Sybase Databases to Oracle
Now that is progress by Oracle. Oracle SQL Developer incorporates migration support by including redeveloped features and greatly extending the functionality and usability offered by the original Oracle Migration Workbench to migrate Microsoft Access, Microsoft SQL Server, MySQL and Sybase databases to Oracle.
[Read more…]
Download Opera 10 Final, Fastest Web Browser
Opera 10, formerly codenamed Peregrine, features an improved user interface, increased web standards support, bug fixes, performance improvements, and new tools for web developers (particularly opera dragonfly, sort of like firebug on opera). Opera 10 Final includes Opera Turbo, the new bandwidth-booster for slow Internet connections, and a revamped Opera Mail, its built-in e-mail client. Opera claims that version 10 of its desktop browser will be significantly faster on resource intensive pages such as Gmail and Facebook, deeming it more than 40% faster overall than Opera 9.6.
[Read more…]