No Money No Honey

Releasing mail from the quarantine - queue files

For the purposes of this, I’m assuming you have set up a single (safe!) postfix instance, with messages going to the HOLD queue, before being processed by MailScanner and sent to the INCOMING queue. You also need to be saving whole messages as queue files.

In MailScanner.conf ensure that you have

# When you quarantine an entire message, do you want to store it as
# raw mail queue files (so you can easily send them onto users) or
# as human-readable files (header then body in 1 file)?
Quarantine Whole Messages As Queue Files = yes 

Quarantined emails are by default kept in /var/spool/MailScanner/quarantine and sorted into subdirectories by date. With any luck it will be dead easy to find, as MailScanner will have sent a message including text along the lines of either:

A: If it’s a quarantined virus, or other dangerous content.

“Note to Help Desk: Look on the <Your text> in /var/spool/MailScanner/quarantine/20050309 (message
6BC5E368497.3C3A6).” 

MailScanner keeps such quarantined emails in their own directories, thus the directory containing the quarantined message will be (in this example): /var/spool/MailScanner/quarantine/20050309/6BC5E368497.3C3A6. In this directory, you should see the original queue file, named as a 10 digit hex number matching the name of the directory. There should also be copies of any attachments that may have been picked up by the virus scanning engine or file filtering.

印度的1919乘法（補充說明）

想到之前台灣不是叫小學生連99乘法表都不要背了嗎...？

當台灣媽媽因為小朋友會背99乘法高興的同時...

印度小孩已經在被1919乘法了！

難怪近幾年印度進步得那麼快！

DELPHI 7 使用ADO元件寫入資料庫強制四捨五入小數到第四位問題

parameters.parambyname('tmpprice').datatype：=ftFloat;   <==寫入資料前先將欄位設定成 Float 型態即可解決此問題。

參考:http://jzinfo.javaeye.com/blog/432853

1. var   
2.     adoquery1:Tadoquery;   
3. begin   
4.     adoquery1:=Tadoquery.create(nil);   
5.     try   
6.        if not DM.adonconnection1.connected then   
7.            DM.adoconnection1.connected:=true;   
8.        adoquery1.connection:=DM.adoconnection1;   
9.        adoquery1.enableBCD:=False;       //禁用bcd类型   
10.        with adoquery1 do   
11.        begin   
12.            close;   
13.            sql.clear;   
14.            sql.add('insert into materialInfo values(:tmppno,:tmpvendor,:tmpdesc,:tmpprice)');   
15.            parameters.parambyname('tmppno').value:=trim(edit1.text);   
16.            parameters.parambyname('tmpvendor').value:=trim(edit2.text);   
17.            parameters.parambyname('tmpdesc').value:=trim(edit3.text);   
18.            parameters.parambyname('tmpprice').datatype：=ftFloat;       //设置下数据类型   
19.            parameters.parambyname('tmpprice').value:=trim(edit4.text);   
20.            execsql;   
21.        end;   
22.     finally   
23.         adoquery1.free;   
24.     end;   
25. end;