DD開発ROOM

2017年12月6日水曜日

mod_fcgid: can't apply process slot for

mod_fcgid エラー

[Wed Nov 15 10:52:54.770061 2017] [fcgid:warn] [pid 3784:tid 804] [client fe80::91cc:b8c9:52ed:2904:60525] mod_fcgid: can't apply process slot for C:/php7/php-cgi.exe, referer: http://...;

結論的には ThumbGen.exe (プログラム) が 0 バイトになっており、cmd.exe が実行終了しなかった、ことが原因でした。
プログラムの破壊はウィルス対策ソフトの不具合によるものか。
ThumbGen の再インストールで、対応。

ちなみに process slot は 1024 ございます。

/* Increase it if necessary */
#define FCGID_MAX_APPLICATION (1024)

/* FCGID_MAX_APPLICATION + 4 list headers */
#define FCGID_PROC_TABLE_SIZE (FCGID_MAX_APPLICATION+4)

2017年10月31日火曜日

MS-OXPROPS のプロパティ一覧を JSON 形式にしました

OXPROPS.json
https://drive.google.com/file/d/0Bygl-em20CSKVHlBWmtxVEdtbG8/view?usp=sharing

PidTagAttachLongFilename など JSON 形式で利用できるようにしました：

"PidTagAttachLongFilename": {
    "Canonical name": "PidTagAttachLongFilename",
    "Description": "Contains the full filename and extension of the Attachment object.",
    "Property ID": "0x3707",
    "Data type": "PtypString, 0x001F",
    "Area": "Message Attachment Properties",
    "Defining reference": "[MS-OXCMSG] section 2.2.2.10",
    "Consuming references": "[MS-OXCICAL], [MS-OXOSMMS], [MS-OXRTFEX], [MS-OXCMAIL], [MSOXMSG], [MS-OXORMMS], [MS-OXOSMIME], [MS-OXODOC], [MS-OXOUM], [MS-OXTNEF]",
    "Alternate names": "PR_ATTACH_LONG_FILENAME, PR_ATTACH_LONG_FILENAME_A,"
},

2017年10月18日水曜日

ASP.NET Web Forms に ASP.NET MVC を中途半端に合成したら、Web Forms の方でエラーが…

Event code: 3005 
Event message: ハンドルされていない例外が発生しました。 
Event time: 2017/10/18 10:54:35 
Event time (UTC): 2017/10/18 1:54:35 
Event ID: 8fd9c0557f114ba9a319136e4feed3dc 
Event sequence: 30 
Event occurrence: 3 
Event detail code: 0 
 
Application information: 
    Application domain: /LM/W3SVC/3/ROOT/toiawa-5-131527646223016368 
    Trust level: Full 
    Application Virtual Path: /toiawa 
    Application Path: C:\inetpub.543\wwwroot\toiawa\ 
    Machine name: DD7 
 
Process information: 
    Process ID: 10024 
    Process name: w3wp.exe 
    Account name: IIS APPPOOL\.NET v4.5 
 
Exception information: 
    Exception type: InvalidOperationException 
    Exception message: WebForms UnobtrusiveValidationMode には、'jquery' の ScriptResourceMapping が必要です。jquery (大文字と小文字が区別されます) という名前の ScriptResourceMapping を追加してください。
   場所 System.Web.UI.ClientScriptManager.EnsureJqueryRegistered()
   場所 System.Web.UI.WebControls.BaseValidator.RegisterUnobtrusiveScript()
   場所 System.Web.UI.WebControls.BaseValidator.OnPreRender(EventArgs e)
   場所 System.Web.UI.Control.PreRenderRecursiveInternal()
   場所 System.Web.UI.Control.PreRenderRecursiveInternal()
   場所 System.Web.UI.Control.PreRenderRecursiveInternal()
   場所 System.Web.UI.Control.PreRenderRecursiveInternal()
   場所 System.Web.UI.Control.PreRenderRecursiveInternal()
   場所 System.Web.UI.Control.PreRenderRecursiveInternal()
   場所 System.Web.UI.Control.PreRenderRecursiveInternal()
   場所 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

 
 
Request information: 
    Request URL: http://192.168.2.181:543/toiawa/Edit.aspx 
    Request path: /toiawa/Edit.aspx 
    User host address: 192.168.2.111 
    User:  
    Is authenticated: False 
    Authentication Type:  
    Thread account name: IIS APPPOOL\.NET v4.5 
 
Thread information: 
    Thread ID: 45 
    Thread account name: IIS APPPOOL\.NET v4.5 
    Is impersonating: False 
    Stack trace:    場所 System.Web.UI.ClientScriptManager.EnsureJqueryRegistered()
   場所 System.Web.UI.WebControls.BaseValidator.RegisterUnobtrusiveScript()
   場所 System.Web.UI.WebControls.BaseValidator.OnPreRender(EventArgs e)
   場所 System.Web.UI.Control.PreRenderRecursiveInternal()
   場所 System.Web.UI.Control.PreRenderRecursiveInternal()
   場所 System.Web.UI.Control.PreRenderRecursiveInternal()
   場所 System.Web.UI.Control.PreRenderRecursiveInternal()
   場所 System.Web.UI.Control.PreRenderRecursiveInternal()
   場所 System.Web.UI.Control.PreRenderRecursiveInternal()
   場所 System.Web.UI.Control.PreRenderRecursiveInternal()
   場所 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
 
 
Custom event details:

対策：

修正方法
https://www.ipentec.com/document/document.aspx?page=asp-net-error-required-jquery-script-resource-mapping

回避策
http://zero-config.com/dotnet/aspnet_0001.html

2017年10月4日水曜日

System.Drawing.Imaging.ImageCodecInfo のリスト

ImageCodecInfo.GetImageDecoders()

[
  {
    "Clsid": "557cf400-1a04-11d3-9a73-0000f81ef32e",
    "FormatID": "b96b3cab-0728-11d3-9d7b-0000f81ef32e",
    "CodecName": "Built-in BMP Codec",
    "DllName": null,
    "FormatDescription": "BMP",
    "FilenameExtension": "*.BMP;*.DIB;*.RLE",
    "MimeType": "image/bmp",
    "Flags": 65543,
    "Version": 1,
    "SignaturePatterns": [
      "Qk0="
    ],
    "SignatureMasks": [
      "//8="
    ]
  },
  {
    "Clsid": "557cf401-1a04-11d3-9a73-0000f81ef32e",
    "FormatID": "b96b3cae-0728-11d3-9d7b-0000f81ef32e",
    "CodecName": "Built-in JPEG Codec",
    "DllName": null,
    "FormatDescription": "JPEG",
    "FilenameExtension": "*.JPG;*.JPEG;*.JPE;*.JFIF",
    "MimeType": "image/jpeg",
    "Flags": 65543,
    "Version": 1,
    "SignaturePatterns": [
      "/9g="
    ],
    "SignatureMasks": [
      "//8="
    ]
  },
  {
    "Clsid": "557cf402-1a04-11d3-9a73-0000f81ef32e",
    "FormatID": "b96b3cb0-0728-11d3-9d7b-0000f81ef32e",
    "CodecName": "Built-in GIF Codec",
    "DllName": null,
    "FormatDescription": "GIF",
    "FilenameExtension": "*.GIF",
    "MimeType": "image/gif",
    "Flags": 65543,
    "Version": 1,
    "SignaturePatterns": [
      "R0lGODlh",
      "R0lGODdh"
    ],
    "SignatureMasks": [
      "////////",
      "////////"
    ]
  },
  {
    "Clsid": "557cf403-1a04-11d3-9a73-0000f81ef32e",
    "FormatID": "b96b3cac-0728-11d3-9d7b-0000f81ef32e",
    "CodecName": "Built-in EMF Codec",
    "DllName": null,
    "FormatDescription": "EMF",
    "FilenameExtension": "*.EMF",
    "MimeType": "image/x-emf",
    "Flags": 65542,
    "Version": 1,
    "SignaturePatterns": [
      "AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAACBFTUY="
    ],
    "SignatureMasks": [
      "AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAP////8="
    ]
  },
  {
    "Clsid": "557cf404-1a04-11d3-9a73-0000f81ef32e",
    "FormatID": "b96b3cad-0728-11d3-9d7b-0000f81ef32e",
    "CodecName": "Built-in WMF Codec",
    "DllName": null,
    "FormatDescription": "WMF",
    "FilenameExtension": "*.WMF",
    "MimeType": "image/x-wmf",
    "Flags": 65542,
    "Version": 1,
    "SignaturePatterns": [
      "183Gmg=="
    ],
    "SignatureMasks": [
      "/////w=="
    ]
  },
  {
    "Clsid": "557cf405-1a04-11d3-9a73-0000f81ef32e",
    "FormatID": "b96b3cb1-0728-11d3-9d7b-0000f81ef32e",
    "CodecName": "Built-in TIFF Codec",
    "DllName": null,
    "FormatDescription": "TIFF",
    "FilenameExtension": "*.TIF;*.TIFF",
    "MimeType": "image/tiff",
    "Flags": 65543,
    "Version": 1,
    "SignaturePatterns": [
      "SUk=",
      "TU0="
    ],
    "SignatureMasks": [
      "//8=",
      "//8="
    ]
  },
  {
    "Clsid": "557cf406-1a04-11d3-9a73-0000f81ef32e",
    "FormatID": "b96b3caf-0728-11d3-9d7b-0000f81ef32e",
    "CodecName": "Built-in PNG Codec",
    "DllName": null,
    "FormatDescription": "PNG",
    "FilenameExtension": "*.PNG",
    "MimeType": "image/png",
    "Flags": 65543,
    "Version": 1,
    "SignaturePatterns": [
      "iVBORw0KGgo="
    ],
    "SignatureMasks": [
      "//////////8="
    ]
  },
  {
    "Clsid": "557cf407-1a04-11d3-9a73-0000f81ef32e",
    "FormatID": "b96b3cb5-0728-11d3-9d7b-0000f81ef32e",
    "CodecName": "Built-in ICO Codec",
    "DllName": null,
    "FormatDescription": "ICO",
    "FilenameExtension": "*.ICO",
    "MimeType": "image/x-icon",
    "Flags": 65542,
    "Version": 1,
    "SignaturePatterns": [
      "AAABAA=="
    ],
    "SignatureMasks": [
      "/////w=="
    ]
  }
]

ImageCodecInfo.GetImageEncoders()

[
  {
    "Clsid": "557cf400-1a04-11d3-9a73-0000f81ef32e",
    "FormatID": "b96b3cab-0728-11d3-9d7b-0000f81ef32e",
    "CodecName": "Built-in BMP Codec",
    "DllName": null,
    "FormatDescription": "BMP",
    "FilenameExtension": "*.BMP;*.DIB;*.RLE",
    "MimeType": "image/bmp",
    "Flags": 65543,
    "Version": 1,
    "SignaturePatterns": [
      "Qk0="
    ],
    "SignatureMasks": [
      "//8="
    ]
  },
  {
    "Clsid": "557cf401-1a04-11d3-9a73-0000f81ef32e",
    "FormatID": "b96b3cae-0728-11d3-9d7b-0000f81ef32e",
    "CodecName": "Built-in JPEG Codec",
    "DllName": null,
    "FormatDescription": "JPEG",
    "FilenameExtension": "*.JPG;*.JPEG;*.JPE;*.JFIF",
    "MimeType": "image/jpeg",
    "Flags": 65543,
    "Version": 1,
    "SignaturePatterns": [
      "/9g="
    ],
    "SignatureMasks": [
      "//8="
    ]
  },
  {
    "Clsid": "557cf402-1a04-11d3-9a73-0000f81ef32e",
    "FormatID": "b96b3cb0-0728-11d3-9d7b-0000f81ef32e",
    "CodecName": "Built-in GIF Codec",
    "DllName": null,
    "FormatDescription": "GIF",
    "FilenameExtension": "*.GIF",
    "MimeType": "image/gif",
    "Flags": 65543,
    "Version": 1,
    "SignaturePatterns": [
      "R0lGODlh",
      "R0lGODdh"
    ],
    "SignatureMasks": [
      "////////",
      "////////"
    ]
  },
  {
    "Clsid": "557cf405-1a04-11d3-9a73-0000f81ef32e",
    "FormatID": "b96b3cb1-0728-11d3-9d7b-0000f81ef32e",
    "CodecName": "Built-in TIFF Codec",
    "DllName": null,
    "FormatDescription": "TIFF",
    "FilenameExtension": "*.TIF;*.TIFF",
    "MimeType": "image/tiff",
    "Flags": 65543,
    "Version": 1,
    "SignaturePatterns": [
      "SUk=",
      "TU0="
    ],
    "SignatureMasks": [
      "//8=",
      "//8="
    ]
  },
  {
    "Clsid": "557cf406-1a04-11d3-9a73-0000f81ef32e",
    "FormatID": "b96b3caf-0728-11d3-9d7b-0000f81ef32e",
    "CodecName": "Built-in PNG Codec",
    "DllName": null,
    "FormatDescription": "PNG",
    "FilenameExtension": "*.PNG",
    "MimeType": "image/png",
    "Flags": 65543,
    "Version": 1,
    "SignaturePatterns": [
      "iVBORw0KGgo="
    ],
    "SignatureMasks": [
      "//////////8="
    ]
  }
]

2017年9月19日火曜日

ODBC--範囲外のデータです

ODBC リンクテーブルの場合、

DoCmd.SetParameter "日付", CDbl(日付)
DoCmd.OpenQuery "クエリー"

でどうでしょう…

VB6 用、日付に関する便利関数

Public Function 先月初日() As Date
    Dim 先月 As Date
    Let 先月 = DateSerial(Year(Now), Month(Now), 1) - 1
    先月初日 = DateSerial(Year(先月), Month(先月), 1)
End Function

Public Function 先月末日() As Date
    Dim 初日 As Date
    先月末日 = DateSerial(Year(Now), Month(Now), 1) - 1
End Function

Public Function 今月初日() As Date
    今月初日 = DateSerial(Year(Now), Month(Now), 1)
End Function

Public Function 今月末日() As Date
    Dim 来月 As Date
    Let 来月 = DateSerial(Year(Now), Month(Now), 1) + 31
    今月末日 = DateSerial(Year(来月), Month(来月), 1) - 1
End Function

2017年8月20日日曜日

XSLT XPath + MS 仕様リファレンス用

XPath 構文
XPath 式のコンテキスト 演算子および特殊文字 コレクション フィルターおよびフィルターパターン 論理式、比較式、およびセット式 比較 セット操作 位置のパス XPath の例

XPath の例
./author author first. name /bookstore //author book[/bookstore/@specialty=@style] author/first-name bookstore//title bookstore/*/title bookstore//book/excerpt//emph .//title author/* book/*/last-name */* *[@specialty] @style price/@exchange price/@exchange/total book[@style] book/@style @* ./first-name first-name author[1] author[first-name][3] my:book my:* @my:*
x/y[1] x/y[position() = 1] (x/y)[1] x[1]/y[2] book[last()] book/author[last()] (book/author)[last()] book[excerpt] book[excerpt]/title book[excerpt]/author[degree] book[author/degree] author[degree][award] author[degree and award] author[(degree or award) and publication] author[degree and not(publication)] author[not(degree or award) and publication] author[last-name = "Bob"] author[last-name[1] = "Bob"] author[last-name [position()=1]= "Bob"] degree[@from != "Harvard"] author[. = "Matthew Bob"] author[last-name = "Bob" and ../price > 50] book[position() <= 3] author[not(last-name = "Bob")] author[first-name = "Bob"] author[* = "Bob"] author[last-name = "Bob" and first-name = "Joe"] price[@intl = "Canada"] degree[position() < 3] p/text()[2] ancestor::book[1] ancestor::book[author][1] ancestor::author[parent::book][1]

軸
ancestor:: ancestor-or-self:: attribute:: child:: descendant:: descendant-or-self:: following:: following-sibling:: namespace:: parent:: preceding:: preceding-sibling:: self::

ノード型のテスト
comment() node() processing-instruction() text()

文字列関数 (XPath)
concat contains normalize-space starts-with String string-length substring substring-after substring-before translate

XML データ型リファレンス
string boolean decimal float double duration dateTime time date gYearMonth gYear gMonthDay gDay gMonth hexBinary base64Binary anyURI QName NOTATION normalizedString token language IDREFS ENTITIES NMTOKEN NMTOKENS Name NCName ID IDREF ENTITY integer nonPositiveInteger negativeInteger long int short byte nonNegativeInteger unsignedLong unsignedInt unsignedShort unsignedByte positiveInteger

XsltArgumentList.AddExtensionObject
.AddExtensionObject("urn:Link", link); xmlns:hxLink="urn:Link" exclude-result-prefixes="hxLink" <xsl:value-of select="concat(hxLink:LookupContentId(@NavigateUrl), '.html')"/>

<xsl:element> 要素
xsl:apply-imports xsl:apply-templates xsl:call-template xsl:choose xsl:copy xsl:copy-of xsl:element xsl:fallback xsl:for-each xsl:if xsl:message xsl:number xsl:otherwise xsl:param xsl:template xsl:text xsl:value-of xsl:variable xsl:when xsl:with-param

Node-Set 関数
count id last local-name name namespace-uri position

Microsoft XPath 拡張関数
ms:type-is ms:type-local-name ([node-set]) ms:type-namespace-uri ([node-set]) ms:schema-info-available ms:string-compare ms:utc ms:namespace-uri ms:local-name ms:number ms:format-date ms:format-time

$ は変数

<xsl:variable> 要素

{} は属性値テンプレート

7.6.2 属性値テンプレート
XSLT variable into the curly braces
{} 波かっこ内の評価結果を string に変換してくれる?

登録: 投稿 (Atom)