2017年4月13日 星期四

check tomot

https://social.msdn.microsoft.com/Forums/zh-TW/3a960e44-4afc-40a1-b17e-a7465a1c04be/postgresql-connection-?forum=236

http://www.blueshop.com.tw/board/FUM20041006161839LRJ/BRD20121210214021YIC.html

http://www.blueshop.com.tw/board/FUM20041006152735ZFS/BRD20100429153313E4D.html

http://www.blueshop.com.tw/board/FUM20041006152735ZFS/BRD20080618201818PVA.html

2016年7月4日 星期一

user macros

https://confluence.atlassian.com/display/DISC/Shared+User+Macros

2016年6月30日 星期四

comment command for confluence


select a.creationdate,a.lastmoddate,b.username from content a ,user_mapping b where a.contenttype='COMMENT' and a.creator=b.user_key and a.creationdate between '2015/9/30' and '2015/10/1'

select count(*),b.username from content a ,user_mapping b where a.contenttype='COMMENT' and a.creator=b.user_key and a.creationdate between '2015/9/30' and '2015/10/1' group by b.username

2016年6月18日 星期六

confluence-comment by author

select a.creationdate,b.username from content a,user_mapping b where a.contenttype='COMMENT' and a.creator=b.user_key and a.creationdate between '2016/4/1' and '2016/4/20' order by creationdate desc

2016年4月28日 星期四

phpBB3


"Sorry but this board is currently unavailable." on each link. What should I do now?

-->Delete or rename your /install directory on the server.

ldap setting

2016年4月26日 星期二

information

http://www.programmableweb.com/news/63-translation-apis-bing-google-translate-and-google-ajax-language/2013/01/15

https://ctrlq.org/code/19909-google-translate-api

http://www.oxforddictionaries.com/us/

http://www.macmillandictionaries.com/dictionary-online/

http://www.programmableweb.com/category/dictionary/api

2016年2月18日 星期四

sql全文檢索的使用說明

--移除全文檢索
USE ServerLog;
GO
EXEC sp_fulltext_table 'tmp', 'drop';
GO
--建立全文檢索資訊
USE ServerLog;
GO
EXEC sp_fulltext_table 'tmp', 'create', 'tmp', 'PK_100and10';
--Add some columns
EXEC sp_fulltext_column 'tmp','MsgText','add';
-- Activate the full-text index
EXEC sp_fulltext_table 'tmp','activate';
GO
--重建索引資料匣
USE ServerLog;
GO
EXEC sp_fulltext_catalog 'full28', 'rebuild';
GO
--索引狀態確認
USE ServerLog;
GO
EXEC sp_fulltext_table 'tmp', 'Start_change_tracking';
EXEC sp_fulltext_table 'tmp', 'Start_background_updateindex';
GO