IE 檢視原始碼

預設值是空白

地址sql

    sql.append("(select addr.addrName from SYSCA_Addr as addr where 1=1 and addr.addrKind ='1' and addr.addrID = person.homeAddr1) as ihomeAddr1, ").append("\n");
    sql.append("(select addr.addrName from SYSCA_Addr as addr where 1=1 and addr.addrKind ='2' and addr.addrID = person.homeAddr2) as ihomeAddr2, ").append("\n");
    sql.append("(select addr.addrName from SYSCA_Addr as addr where 1=1 and addr.addrKind ='3' and addr.addrID = person.homeAddr3) as ihomeAddr3, ").append("\n");



select addr.addrName from SYSCA_Addr as addr where 1=1 and addr.addrKind ='1' and addr.addrID = person.homeAddr1) as ihomeAddr1, 
select addr.addrName from SYSCA_Addr as addr where 1=1 and addr.addrKind ='2' and addr.addrID = person.homeAddr2) as ihomeAddr2,
select addr.addrName from SYSCA_Addr as addr where 1=1 and addr.addrKind ='3' and addr.addrID = person.homeAddr3) as ihomeAddr3,

【SQL】函數coalesce()

coalesce(欄位名, '')
當欄位名的值為null，null轉成''


使用時機：某欄位當條件時，該欄位的值，有null、有空值

在word、excel下，點擊滑鼠右鍵，閃一下就消失了？！

元兇是Babylon增益集元件，取消勾選，即可正常使用。

HTML DOM Event Object

StringBuffer

• 清空目前存在StringBuffer的字串

StringBuffer.setLength(0);

也可重新

new StringBuffer();