SQL Select Statement with Comma-Separated List Condition

I have one problem the other day; Why does my “SELECT * FROM tbl WHERE col IN (@list)” does not work? The col datatype is int, while the @list parameter is a comma-separated varchar. The Problem In a stored procedure, I’m composing a SELECT statement with a WHERE clause in which the column condition datatype is integer, […]

Guest-Host Connection in Vmware through Firestarter

Following my previous post on VPNC, after modifying the user-pre file in Firestarter, it somehow screws-up my guest-host connections in Vmware. The host, running on Ubuntu 8.04, no longer be able to connect to it guests, and vice-versa. The following is what I did to make the connection works. I had to post this up […]

VPN Connection in Ubuntu using VPNC

I’ve been using VPNC in my Ubuntu to access my company’s VPN from https://getmoreprivacy.com/ for quite some time now. The story is, I’ve tried using Cisco VPN, but it will only get me as far as connecting to the VPN server. When I’m trying to access the company’s intranet, I’ll get a “page not found” […]

Linksys WRT54G Wireless Router Firmware Upgrade

Recently I have a problem where my wireless connection sometimes getting dropped. My Linksys WRT54G Wireless Router having intermittent reboot, especially when there’s a lot of connections, like when BitTorrent is running on one of my machine. I’ve figured out that maybe it’s time to upgrade my router’s firmware. The current version is the initial […]

HTTP Request using cURL for Windows

There’s a variety of ways to perform http request without using your web browser, i.e. using your command prompt. We could use wget for most major Linux distributions, but what about Windows? Recently I’ve found out that cURL might get the job done. cURL is a command line tool for transferring files with URL syntax. […]