Virtuemart E-Commerce

Sudah lama juga nih nggak ng-update blog. Sehubungan dengan kesibukan akhir-akhir ini yang makin menyita waktu. Meskipun sibuk, harus tetap semangat. Betul ? Bermula...

Hitung hari antara 2 tanggal (minus tgl merah)

procedure TForm1.Button1Click(Sender: TObject);var tglmerah,sabtu, minggu,jml:integer; jumlah:variant; tgl1,tgl2:tdatetime;begin tglmerah:=3; tgl1:=encodedate(2010,04,01); tgl2:=encodedate(2010,04,30); jml:=0; while tgl1<=tgl2...

Query Mengambil Bulan dan Tahun dalam Field Datetime

Mengambil Bulan dan Tahun dalam Field Datetime pada MSSQLSELECT *FROM aksesWHERE (THSMS = N'20091') AND (DATEPART(month, tgltransaksi) = 06) AND (DATEPART(month, tgltransaksi) = 2010) ORDER BY N...

Instalasi zkemkeeper_TLB.pas (Component Read Log Fingerprint)

It has 2 method:1,download stand alone SDKs from zk website and copy these sdks to system32 directory. use "regsvr32 zkemkeeper.dll" in the run window. or you install the access control and T&A software, it will auto-install...

Getdate() In SQL Server

Be Careful That You Know What Getdate() Returnsby Les SmithBe careful when using getdate() in SQL Server as a Start or End date for a sql statement or Stored Procedure. This is fairly elementary for most developers, but...