Advance Shell Command – Remove .svn folders in Windows.

If you are using subversion source control, you should know that there are hidden folders named .svn inside your project. If you need to deploy the apps to the server, you should consider to remove all the .svn folder first.

Thanks to Jon Galloway. I found out the easiest way to do that.

Step 1. Copy below code, put it into the file and name it to whatever.reg

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Folder\shell\DeleteSVN]
@="Delete SVN Folders"

[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Folder\shell\DeleteSVN\command]
@="cmd.exe /c \"TITLE Removing SVN Folders in %1 && COLOR 9A && FOR /r \"%1\" %%f IN (.svn) DO RD /s /q \"%%f\" \""

Step 2. Right click the file and merge.

(more…)

Posted in :Else:, Programming, Tips & Tricks | No Comments »

Error handling in AutoIt

In my post here , I write about connecting to MS-SQL Server. One of my reader/googler ask me about how to handle if let say the password or username are wrong.

Here is the way how to handle it. I think there are another way to do it but personally I find that, this is the easiest way to do it.

#include <ie.au3>
_IEErrorHandlerRegister()

$conn = ObjCreate( "ADODB.Connection" )
$DSN = "DRIVER={SQL Server};SERVER=MySvr;DATABASE=MyDB;UID=MyUser;PWD=MyPwd;"
$conn.Open($DSN)
if @Error Then
        MsgBox(0,"Error",$IEComErrorDescription)
Else
        $rs = ObjCreate( "ADODB.RecordSet" )
        $rs.Open( "SELECT @@VERSION AS myVersion", $conn )
        MsgBox(0, "AutoIT-SQL Result", "Value = " & $rs.Fields( "myVersion" ).Value )
EndIf
if IsObj($conn) Then $conn.close

That’s it. Till then..happy coding.

Posted in AutoIt, Tips & Tricks | No Comments »

How to connect to Internet using your Laptop with BlackBerry device

First, you need to have BlackBerry Desktop Manager, connect your BlackBerry to your laptop and go to IP Modem menu.

(more…)

Posted in BlackBerry, Tips & Tricks | 4 Comments »

Drop table if Exists in Oracle

In MySQL, we can easily drop table and check whether it is exist or not using this statement.

DROP TABLE IF EXISTS MyTable

In Oracle, you can’t do that.

Solution that I found is to create a procedure and execute it.

As for my reference and others (if any) here is the script to create that procedure.

(more…)

Posted in Database, Tips & Tricks | No Comments »

How to export VCF file to BlackBerry

VCF or vCard file is a file format standard for electronic business card. Below are the way how I used to export it to my BlackBerry.

1. Combine all the vcf file into one file. If you are in windows environment you can use below command. Make sure your working directory is correct.

type * > all_contacts.vcf

2. Download and install ABC Amber vCard converter. This software can convert vcf file to ipd file which is recognized by BlackBerry. Click BlackBerry icon to convert the selected contact.

(more…)

Posted in BlackBerry, Tips & Tricks | No Comments »