2014/12/23

Item	Maximum limit
Database size	The maximum OS file size limit -- (up to 64GB)
Text field size	32KB (storage); 32KB displayed in a view's column
Rich text field size	Limited only by available disk space up to 1GB
Response levels in a hierarchical view; number of documents per level	31 levels; 300,000 documents
Characters in names	Database Title: 96 bytes Filenames: On Windows^® and UNIX^® platforms minimum of 255 and/or OS limits; on local Macintosh workstation 31 Field names: 32 characters (32 bytes in SBCS, 64 bytes in DBCS) View names: 63 bytes per level, 127 total including one separator Form names: 63 bytes per level, 127 total including one separator Agent names: 63 bytes per level, 127 total including one separator
Fields in a database	~ 3000 (limited to ~ 64K total length for all field names). You can enable the database property "Allow more fields in database" to get up to 22,893 uniquely-named fields in the database.
Columns in a table	64
Rows in a table	255
Views in a database	No limit; however, as the number of views increases, the length of time to display other views also increases
Forms in a database	Limited only by database size.
Columns in a view	289 ten-character columns; dependent upon # or characters per column
Documents imported into a view	Documents totaling at least 350K
Cascading views in a database	200
Margin size (in inches)	46
Page cropping size (in inches)	46
Point size to select or print	250
Documents in a view	Up to the maximum size of the database
Documents that can be exported to tabular text	Limited only by available disk space
Entries in an Access Control List (ACL)	~950 names (ACL size is limited to 32767 bytes)
Roles in an Access Control List	75 Roles
ID password length	63 characters
Authorized users on a multiple password ID	8 users
Outline entries in an outline	~21,000 entries
Length limit for a macro language string literal	2048 bytes Note Strings in formula language are represented internally in the LMBCS character set, which uses one byte for an ASCII character, but may require up to 4 bytes for some non-ASCII characters.
Notes API objects when using Java^™	~104,800

2014/10/15

[Domino/Lotus Notes]單一類別視界

某套表有一欄位

並且在裡頭崁入了視界

需求希望可以用該欄位的資料來抓取視界的資料

崁入視界裡頭會有一個設定叫單一類別

這麼一來就可以利用視界尋找套表欄位裡頭的資料了

2014/10/12

[MIME] 匯出成Excel橫向列印

客戶需求要將Web上的報表下載成Excel並且要直接為横向列印

於是向G神許願後，就給了我這一個東西了

2014/10/08

[HTML/CSS]利用CSS進行凸排效果

我們在Word上進行排版的時候會時常使用到凸排這一個功能

這是許多做報告做論文必備的技能之一

在Word2003或稍早的版本，只要在段落裡面設定即可，輕而易舉

但在網頁上呈現該效果，就必須倚賴CSS來進行編排

要做到凸排的效果要使用
text-indent
margin-left
這兩個屬性來做凸排效果

[CKEditor]幾個常用編輯器設置(config.js)

為了方便尋找與使用，特地整理出來，日後還會再增加，目前大致上就這些吧

編輯器字型大小，預設為12px

config.fontSize_defaultLabel = '12px';

編輯器字體，預設字型為Arial

config.font_defaultLabel = 'Arial';

2014/08/24

[C#]利用迴圈取得流水號命名的控制項，並加以控制

參考：
在for迴圈中能把陣列變數的值, 依序放入不同控制項的text嗎? / ASP.NET / 程式設計俱樂部
http://www.programmer-club.com.tw/showsametitlen/aspdotnet/19968.html

living in my life (史蘭諾系統整合服務): [WinForm]使用 Controls.Find 取得/給予控制項資料
http://silanors.blogspot.tw/2011/01/winformcontrolsfind.html

2014/08/15

[PDFCreator]PDFCreator參數檔以及LotusScript的使用範例

撰寫PDF轉檔程式使用到PDFCreate該軟體

需要使用裡面的參數來控制PDFCreate的列印行為

原以為這些參數好像是憑空生出來的

後來持續追蹤之下

原來該軟體本身底下便有該參數

為方便查詢，特地在此列出來

2014/08/14

使用Lotus Notes的通訊錄選單

Lotus Notes本身有的功能，因為不常使用容易忘記，於是寫下這篇來預防日後不時之需

Step 1：

2014/08/06

不用Visual Studio也能寫程式－NET Fiddle！

最近發現到一個可以直接線上寫程式開發工具：

.NET Fiddle
http://dotnetfiddle.net/

2014/07/20

[CKEditor]從Word貼上CKEditor發生文字排版跑掉的問題

CKEditor 是一個強大的所見即所得 HTML 編輯器 (WYSIWYG HTML Editor)

在調整好工具列後將Word的內容貼到CKEditor上居然文字排面跑掉了！

WORD：

2014/07/13

[LotusScript]利用MIME產生WORD檔

某家的客戶需求要把簽核的公文印出來

看前人的Code的範例有Excel，但卻沒有Word

2014/07/11

[轉貼]Table of CGI variable names

Table of CGI variable names

IBM^® Lotus^® Domino^® captures the following CGI variables through a field or a LotusScript agent. You can also capture any CGI variable preceded by HTTP or HTTPS. For example, cookies are sent to the server by the browser as HTTP_Cookie.

For more information about CGI environment variables, see:

http://hoohoo.ncsa.uiuc.edu/cgi/env.html