Archive for September, 2008

How to program Gambas with MySQL in Ubuntu

I’ve read a nice introduction to Gambas here.Gambas is a free development environment based on a Basic interpreter with object extensions.
Since installing Gambas in ubuntu is a piece of cake, I then decide to try to program using Gambas. I found quite a number of article to do a connection with MySQL but then it [...]

MSSQL - Date Manipulating

By default, result for select getdate() in MS-SQL will be something like below:
getdate()
————————-
2008-09-09 15:01:47.340

CONVERT function can be use to manipulate the date format as per our need.
Using CONVERT:
CONVERT ( data_type [ ( length ) ] , expression [ , style ] )

example:
select CONVERT(varchar(25),getdate(),100)
————————-
Sep 9 2008 3:04PM
Below are the lists of style/format for reference :

Generating a self signed SSL certificate in Ubuntu Hardy

There are a few way to generate a self signed SSL certificate . You can read it here,here and here .
This is the most inexpensive way to use a ssl connection because it’s totally FREE. From a cryptographic perspective, there is no difference in security whether you use a self signed SSL certificate or buy [...]

Simple DOS command..yet still saves my day.

My friend send me a bunch of files where it have a sql scripts for each table. I need to combine all those files into one and later will be use to reverse engineer and analyze the tables.
Below are simple steps that I use to combine all those files using command prompt.
Create an empty [...]


AWSOM Powered