Monday, July 30, 2012

Win 7 ODBC


In case drivers are not there in 64 bit ODBC
Control Panel\System and Security\Administrative Tools\Data Sources (ODBC)


try 32 bit
%windir%\SysWOW64\odbcad32.exe


http://support.microsoft.com/kb/2721825/EN-US

Share Article : Win 7 ODBC
Share/Save/Bookmark

Friday, July 27, 2012

Embedding image in html email



<img src="data:image/jpg;base64,/*base64-data-string here*/" />

Share Article : Embedding image in html email
Share/Save/Bookmark

Tuesday, July 24, 2012

AUTO LOG WITH TRIGGER



create
TRIGGER TRIG_MYTBL_LOG AFTER
  UPDATE ON  MYTBL  FOR EACH ROW BEGIN
  INSERT
  INTO  MYTBL_LOG
    (
      ITEM_CODE,
      GTIN,
      REGID,
      REGIP,
      REGDATE
    )
    VALUES
    (
      :OLD.ITEM_CODE,
      :OLD.GTIN,
      :OLD.REGID,
      :OLD.REGIP,
      :OLD.REGDATE
    );
END;

Share Article : AUTO LOG WITH TRIGGER
Share/Save/Bookmark

Tuesday, July 17, 2012

How to Delete all .svn folders using Windows Command Prompt



You can use the following command to delete all .svn folders in curent directory recursively.

FOR /R . %f IN (.svn) DO RD /s /q %f

Share Article : How to Delete all .svn folders using Windows Command Prompt
Share/Save/Bookmark

Saturday, July 14, 2012

Recursive Permission




Share Article : Recursive Permission
Share/Save/Bookmark