《保留字》
| 当你制作ASP动态网站出现莫名其妙的错误时——ASP中常见保留字大名单 参考http://www.egzcn.com/article/webbc/asp/2005-1-12/old175.html 保留字在ASP中有特殊的含义，它们是语言语法的一部分，不可以用作变量名、函数名、对象名、数据库名、数据表名等。 许多人在编写ASP动态网站程序时由于贪图方便，不小心使用了ASP程序的保留字，结果程序明明在语法上没有错，就是无法正常执行。有的朋友看到这里可能会说：“我现在的ASP网页中就正在使用某个保留字，怎么没见出错呢？”我劝大家不要有这种侥幸心理，你的程序现在没出错，不一定永远都不出错！这是由任何一种语言的解释程序的结构所决定。一但养成了这种不顾及保留字的不良编程习惯，将会有许多莫名其妙怪事来骚扰你哦！ 你知道有哪些常见的保留字吗？请看下表： 一、Microsoft Access方面 ADD ALL Alphanumeric ALTER AND ANY Application AS ASC Assistant AUTOINCREMENT Avg BETWEEN BINARY BIT BOOLEAN BY BYTE CHAR, CHARACTER COLUMN CompactDatabase CONSTRAINT Container Count COUNTER CREATE CreateDatabase CreateField CreateGroup CreateIndex CreateObject CreateProperty CreateRelation CreateTableDef CreateUser CreateWorkspace CURRENCY CurrentUser DATABASE DATE DATETIME DELETE DESC Description DISALLOW DISTINCT DISTINCTROW Document DOUBLE DROP Echo Else End Eqv Error EXISTS Exit FALSE Field, Fields FillCache FLOAT, FLOAT4, FLOAT8 FOREIGN Form, Forms FROM Full FUNCTION GENERAL GetObject GetOption GotoPage GROUP GROUP BY GUID HAVING Idle IEEEDOUBLE, IEEESINGLE If IGNORE Imp IN, In INDEX Index, Indexes INNER INSERT InsertText INT, INTEGER, INTEGER1, INTEGER2, INTEGER4 INTO IS, Is JOIN KEY LEFT Level Like LOGICAL, LOGICAL1 LONG, LONGBINARY, LONGTEXT Macro Match Max, Min, Mod MEMO Module MONEY Move NAME NewPassword NO Not NULL NUMBER, NUMERIC Object OLEOBJECT OFF ON OpenRecordset OPTION OR, Or ORDER Outer OWNERACCESS Parameter PARAMETERS Partial PERCENT PIVOT PRIMARY PROCEDURE Property Queries Query Quit REAL Recalc Recordset REFERENCES Refresh RefreshLink RegisterDatabase Relation Repaint RepairDatabase Report Reports Requery RIGHT SCREEN SECTION SELECT) SET SetFocus SetOption SHORT SINGLE SMALLINT SOME SQL StDev, StDevP STRING Sum TABLE TableDef, TableDefs TableID TEXT TIME, TIMESTAMP TOP TRANSFORM TRUE Type UNION UNIQUE UPDATE User user VALUE VALUES Var, VarP VARBINARY, VARCHAR WHERE WITH Workspace Xor Year YES YESNO 二、MySQL方面 ADD ALL ALTER ANALYZE AND AS ASC AUTO_INCREMENT BDB BERKELEYDB BETWEEN BIGINT BINARY BLOB BOTH BY CASCADE CASE CHANGE CHAR CHARACTER COLUMN COLUMNS CONSTRAINT CREATE CROSS CURRENT_DATE CURRENT_TIME CURRENT_TIMESTAMP DATABASE DATABASES DAY_HOUR DAY_MINUTE DAY_SECOND DEC DECIMAL DEFAULT DELAYED DELETE DESC DESCRIBE DISTINCT DISTINCTROW DOUBLE DROP ELSE ENCLOSED ESCAPED EXISTS EXPLAIN FIELDS FLOAT FOR FOREIGN FROM FULLTEXT FUNCTION GRANT GROUP HAVING HIGH_PRIORITY HOUR_MINUTE HOUR_SECOND IF IGNORE IN INDEX INFILE INNER INNODB INSERT INT INTEGER INTERVAL INTO IS JOIN KEY KEYS KILL LEADING LEFT LIKE LIMIT LINES LOAD LOCK LONG LONGBLOB LONGTEXT LOW_PRIORITY MASTER_SERVER_ID MATCH MEDIUMBLOB MEDIUMINT MEDIUMTEXT MIDDLEINT MINUTE_SECOND MRG_MYISAM NATURAL NOT NULL NUMERIC ON OPTIMIZE OPTION OPTIONALLY OR ORDER OUTER OUTFILE PARTIAL PRECISION PRIMARY PRIVILEGES PROCEDURE PURGE READ REAL REFERENCES REGEXP RENAME REPLACE REQUIRE RESTRICT RETURNS REVOKE RIGHT RLIKE SELECT SET SHOW SMALLINT SONAME SQL_BIG_RESULT SQL_CALC_FOUND_ROWS SQL_SMALL_RESULT SSL STARTING STRAIGHT_JOIN STRIPED TABLE TABLES TERMINATED THEN TINYBLOB TINYINT TINYTEXT TO TRAILING UNION UNIQUE UNLOCK UNSIGNED UPDATE USAGE USE USER_RESOURCES USING VALUES VARBINARY VARCHAR VARYING WHEN WHERE WITH WRITE XOR YEAR_MONTH ZEROFILL （大名单完） ________________________________________ 相关链接 javascript的保留字_武老师工作室http://club.heima.com/show_topic.aspx?forumid=300953&topicid=1471477 ASP动态网站如何通过自定义连接字符串与Access数据库建立连接_武老师工作室http://sangelc.unibbs.cn/show_topic.aspx?forumid=300953&topicid=1382247 |