2010年5月28日 星期五

Coldfusion 系統保留單字

Coldfusion 與一般程式相同都有特定的保留字,由於這些是系統使用的單字,所以在設計Coldfusion文件時請勿使用,以免發生錯誤。

設計表單(FORM)時,底下列舉的單字請勿使用
  • _integer
  • _float
  • _range
  • _date
  • _time
  • _eurodate
  • _required



在SQL查詢內的單字請勿使用下列列表單字當作"變數"名稱

ABSOLUTEACTIONADDALLALLOCATE
ALTERANDANYAREAS
ASCASSERTIONATAUTHORIZATIONAVG
BEGINBETWEENBITBIT_LENGTHBOTH
BYCASCADECASCADEDCASECAST
CATALOGCHARCHARACTERCHARACTER_
LENGTH
CHAR_LENGTH
CHECKCLOSECOALESCECOLLATECOLLATION
COLUMNCOMMITCONNECTCONNECTIONCONSTRAINT
CONSTRAINTSCONTINUECONVERTCORRESPONDINGCOUNT
CREATECROSSCURRENTCURRENT_DATECURRENT_TIME
CURRENT_
TIMESTAMP
CURRENT_
USER
CURSORDATEDAY
DEALLOCATEDECDECIMALDECLAREDEFAULT
DEFERRABLEDEFERREDDELETEDESCDESCRIBE
DESCRIPTORDIAGNOSTICSDISCONNECTDISTINCTDOMAIN
DOUBLEDROPELSEENDEND-EXEC
ESCAPEEXCEPTEXCEPTIONEXECEXECUTE
EXISTSEXTERNALEXTRACTFALSEFETCH
FIRSTFLOATFORFOREIGNFOUND
FROMFULLGETGLOBALGO
GOTOGRANTGROUPHAVINGHOUR
IDENTITYIMMEDIATEININDICATORINITIALLY
INNERINPUTINSENSITIVEINSERTINT
INTEGERINTERSECTINTERVALINTOIS
ISOLATIONJOINKEYLANGUAGELAST
LEADINGLEFTLEVELLIKELOCAL
LOWERMATCHMAXMINMINUTE
MODULEMONTHNAMESNATIONALNATURAL
NCHARNEXTNONOTNULL
NULLIFNUMERICOCTET_LENGTHOFON
ONLYOPENOPTIONORORDER
OUTEROUTPUTOVERLAPSPADPARTIAL
POSITIONPRECISIONPREPAREPRESERVEPRIMARY
PRIORPRIVILEGESPROCEDUREPUBLICREAD
REALREFERENCESRELATIVERESTRICTREVOKE
RIGHTROLLBACKROWSSCHEMASCROLL
SECONDSECTIONSELECTSESSIONSESSION_USER
SETSIZESMALLINTSOMESPACE
SQLSQLCODESQLERRORSQLSTATESUBSTRING
SUMSYSTEM_USERTABLETEMPORARYTHEN
TIMETIMESTAMPTIMEZONE_
HOUR
TIMEZONE_
MINUTE
TO
TRAILINGTRANSACTIONTRANSLATETRANSLATIONTRIM
TRUEUNIONUNIQUEUNKNOWNUPDATE
UPPERUSAGEUSERUSINGVALUE
VALUESVARCHARVARYINGVIEWWHEN
WHENEVERWHEREWITHWORKWRITE
YEARZONE


0 個回應: