[Develop] Visual Studio 佈景

原文: CODING HORROR - Is Your IDE Hot or Not?

長時間看 Code 的話，還是用點技巧對自己多照顧點吧！

• Download Jeff's scheme (2kb)
• Download "Zenburn" scheme (2kb) (now with HTML, XML, and CSS properties by Geraldo Medrano)
• Download more schemes, and contribute your own, at the Is your IDE Hot or Not? site.

To import, use the Tools | Import and Export Settings menu in Visual Studio 2005. But be sure you have the necessary fonts installed first-- Consolas for the main font and Dina for the output console font.

Here's how to export your own IDE font and color settings:

• Tools | Import and Export Settings...
• Select Export
• Click the All Settings node to unselect everything in the tree
• Expand the tree to "All Settings, Options , Environment"
• Click the "Fonts and Colors" node
• Click next, name the file appropriately, and Finish.

[CodeIgniter] 變更 log 的副檔名

在 CodeIgniter 預設的 log 副檔名還是取 .php，所以在 PDT 中就會出現警告(因為不符 php 語法)，由於 CI 本身並沒有設定 log 副檔名的開關，所以如果想改的話，快一點就直接改 library/log.php
在 Line 89 行中，

$filepath = $this->log_path.'log-'.date('Y-m-d').EXT;

直接改成

$filepath = $this->log_path.'log-'.date('Y-m-d'). '.log';

[Develop] 安裝 Visual Studio 2008 Sp1 失敗~~

要用到 jquery ，所以一定要裝上 vs.net 2008 sp1，不過，下載回來安裝後卻失敗，失敗訊息為

C:\Users\ADMINI~1\AppData\Local\Temp\1\Microsoft Visual Studio 2008 SP1\VC_IA64Runtime.exe - Exe installer's log file/hint (%temp%\dd_VC_IA64Runtime*.txt|%temp%\..\dd_VC_IA64Runtime*.txt) does not exist or is invalid

Exe (C:\Users\ADMINI~1\AppData\Local\Temp\1\Microsoft Visual Studio 2008 SP1\dotnetfx35langpack_x64zh-CHT.exe) failed with 0x80070643 - Fatal error during installation

看了一下才發現是 langpack 沒有安裝....

[Develop]Top 10 PHP Frameworks

排名第一的是 Yii，這個framework 我還沒有用過，不過，現在正在用 CodeIgniter 排第二，呵！！




完整文章請至原文網站

[Develop]Top 10 PHP Frameworks

排名第一的是 Yii，這個framework 我還沒有用過，不過，現在正在用 CodeIgniter 排第二，呵！！

完整文章請至原文網站

[Database] ADO Data Types與數據庫值對應

嘿！有這個對應表的話，用程式來建立資料表就方便多了。

由於用 asp + oldeb for foxpro，所以要參考 Oledb 的部分。

ADO Data Types與數據庫值對應 http://www.zaoxue.com/article/tech-48473.htm

DataType Enum	Value	Access	SQLServer
adBigInt	20		BigInt (SQL Server 2000 +)
adBinary	128		Binary TimeStamp
adBoolean	11	YesNo	Bit
adChar	129		Char
adCurrency	6	Currency	Money SmallMoney
adDate	7	Date	DateTime
adDBTimeStamp	135	DateTime (Access 97 (ODBC))	DateTime SmallDateTime
adDecimal	14
adDouble	5	Double	Float
adGUID	72	ReplicationID (Access 97 (OLEDB)), (Access 2000 (OLEDB))	UniqueIdentifier (SQL Server 7.0 +)
adIDispatch	9
adInteger	3	AutoNumber Integer Long	Identity (SQL Server 6.5) Int
adLongVarBinary	205	OLEObject	Image
adLongVarChar	201	Memo (Access 97) Hyperlink (Access 97)	Text
adLongVarWChar	203	Memo (Access 2000 (OLEDB)) Hyperlink (Access 2000 (OLEDB))	NText (SQL Server 7.0 +)
adNumeric	131	Decimal (Access 2000 (OLEDB))	Decimal Numeric
adSingle	4	Single	Real
adSmallInt	2	Integer	SmallInt
adUnsignedTinyInt	17	Byte	TinyInt
adVarBinary	204	ReplicationID (Access 97)	VarBinary
adVarChar	200	Text (Access 97)	VarChar
adVarWChar	202	Text (Access 2000 (OLEDB))	NVarChar (SQL Server 7.0 +)

[DATABASE] 各種資料庫的欄位型態

下列的參考資料十分不錯，列出大部分用到的資料庫欄位型態，寫程式時還蠻有用的！

Databases - Field Types http://mc-computing.com/Databases/FieldTypes.html

ex:

Foxpro

Type	Size	Description
Character	1 to 254
Currency	8 bytes	18 significant figures, including 4 decimal places Not available in Database Explorer
Date	8 bytes	January 1st, 1 A.D to December 31st, 9999 A.D
DateTime	8 bytes
Logical	1 byte
Variant		Can hold any type of field
Double	8 bytes	+/-4.94065645841247E-324 to +/-8.9884656743115E307 13 significant figures This range does not make sense
Numeric	1 to 20 bytes	- .9999999999E+19 to .9999999999E+20 up to 10 significant figures (specified by the user), same as Float
Float	1 to 20 bytes	- .9999999999E+19 to .9999999999E+20 up to 10 significant figures (specified by the user), same as Numeric
Integer	4 bytes	-2,147,483,647 to 2,147,483,647
Integer (Autoinc)	4 bytes	Autoincrement field
General	4 bytes in table	Reference to an OLE object The type is OLE in Database Explorer
Memo	4 bytes in table	Values may be modified depending on the language mapping Database Explorer indicates that these are actually 10 bytes each
Memo (Binary)	4 bytes in table	Values are not modified When the code page changes

[ADO] Foxpro

建立資料表(TABLE)
EX: Create Table test( id char(10), bookname character(100), number int)

刪除資料表
EX: DROP TABLE test

新增記錄
EX1: INSERT INTO test VALUES ('111', 'Life is Sad', 100)
EX2: INSERT INTO test (id, bookname, number) VALUES ('111', 'Life is Sad', 100)

• foxpro 8.0 以後可以用 autoinc 型態來設定自動編號


• oledb for vfp 支援 autoinc 語法,
  ex: Create Table test( id int primary key autoinc, bookname character(100), number int)


• oledb for vfp 不支援 " CREATE DATABASE" 的語法

.NET Runtime Optimization error on SQL Server 2005

前一陣子 sql server 2005 突然出現下列錯誤訊息：

Source: .NET Runtime Optimization Service

EventID: 1101

.NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed to compile: Microsoft.ReportingServices.QueryDesigners, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 . Error code = 0x80070002

上網找了一下資料，解決方式如下：

重新啟動 .NET RuntimeOptimization 服務，或者，先暫時停用這個服務也可以，再不行的話，就重新開機試試吧！