我快要疯掉了，微软是不是SB：asp+access插入日期/时间类型，出了问题，在这个版块也查了，可是大家都说得很乱，我都快被搞糊涂了。

[gois]

我快要疯掉了，微软是不是SB：
asp+access插入日期/时间类型，出了问题，在这个版块也查了，可是大家都说得很乱，我都快被搞糊涂了。

下面这9段哪段是对了，为什么我一个都不行，应该怎样写这个串？

exec = "insert into guestbook(Username,Email,Tel,Datetime,IP,Content)" & _
"values('" & sUsername & "','" & sEmail & "','" & sTel & "'," & _
getDate() & _
",'" & Request.ServerVariables("Remote_ADDR") & "','" & sContent & "')"

exec = "insert into guestbook(Username,Email,Tel,Datetime,IP,Content)" & _
"values('" & sUsername & "','" & sEmail & "','" & sTel & "',#" & _
getDate() & _
"#,'" & Request.ServerVariables("Remote_ADDR") & "','" & sContent & "')"

exec = "insert into guestbook(Username,Email,Tel,Datetime,IP,Content)" & _
"values('" & sUsername & "','" & sEmail & "','" & sTel & "','" & _
getDate() & _
"','" & Request.ServerVariables("Remote_ADDR") & "','" & sContent & "')"


exec = "insert into guestbook(Username,Email,Tel,Datetime,IP,Content)" & _
"values('" & sUsername & "','" & sEmail & "','" & sTel & "'," & _
now() & _
",'" & Request.ServerVariables("Remote_ADDR") & "','" & sContent & "')"

exec = "insert into guestbook(Username,Email,Tel,Datetime,IP,Content)" & _
"values('" & sUsername & "','" & sEmail & "','" & sTel & "',#" & _
now() & _
"#,'" & Request.ServerVariables("Remote_ADDR") & "','" & sContent & "')"

exec = "insert into guestbook(Username,Email,Tel,Datetime,IP,Content)" & _
"values('" & sUsername & "','" & sEmail & "','" & sTel & "','" & _
now() & _
"','" & Request.ServerVariables("Remote_ADDR") & "','" & sContent & "')"


exec = "insert into guestbook(Username,Email,Tel,Datetime,IP,Content)" & _
"values('" & sUsername & "','" & sEmail & "','" & sTel & "'," & _
now & _
",'" & Request.ServerVariables("Remote_ADDR") & "','" & sContent & "')"

exec = "insert into guestbook(Username,Email,Tel,Datetime,IP,Content)" & _
"values('" & sUsername & "','" & sEmail & "','" & sTel & "',#" & _
now & _
"#,'" & Request.ServerVariables("Remote_ADDR") & "','" & sContent & "')"

exec = "insert into guestbook(Username,Email,Tel,Datetime,IP,Content)" & _
"values('" & sUsername & "','" & sEmail & "','" & sTel & "','" & _
now & _
"','" & Request.ServerVariables("Remote_ADDR") & "','" & sContent & "')"


另外，在这个SQL语句里，now 与 now()　有什么区别　它们与 getDate() 又是什么关系呢？

[gois]

当然我ACCESS数据库里的datetime字段用的是日期/时间型

[dgm8]

加两个单引号吧

[gois]

哪里加两个单引号，整个SQL语句应该怎样？

[是是非非]

exec = "insert into guestbook(Username,Email,Tel,Datetime,IP,Content)" & _
"values('" & sUsername & "','" & sEmail & "','" & sTel & "',Now(),'" & _
Request.ServerVariables("Remote_ADDR") & "','" & sContent & "')"

[gois]

TO;回复人： eglic(圪圪) ( ) 信誉：103

Microsoft JET Database Engine (0x80040E14)
INSERT INTO 语句的语法错误。
/csj/gb_save.asp, 第 13 行

[madpolice]

exec = "insert into guestbook (Username,Email,Tel,[Datetime],IP,Content)" & _
" values ('" & sUsername & "','" & sEmail & "','" & sTel & "','" & _
now() & _
"','" & Request.ServerVariables("Remote_ADDR") & "','" & sContent & "')"

[madpolice]

如果我写错了，我给你200分

[gois]

To:madpolice() ( ) 信誉：100

这位大哥，
[Datetime]里的[]是什么意思?

[aassdd]

呵呵~~我就不看你那些语句了。
给你提个意见，这些普通的SQL语句既然知道要用到ACCESS数据库里，为什么就不先在数据库里测试完了再那到程序里呢。具体怎么测就不用说了吧。

[madpolice]

SQL 保留字
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

下表包含了 Microsoft Jet 数据库引擎保留用于 SQL 语句所有保留单词。列表中没有全部采用大写字母的单词也是其他应用程序的保留字。所以，这些保留字的各个帮助主题提供一般性说明，而不只是着重说明 SQL 用法。

注释 后面带有星号 (*) 的保留字是为以后保留的，但当前在 Microsoft® Jet SQL 语句的上下文中没有意义（例如，Level 和 TableID）。不加下划线的保留字没有链接的解释。

A

ABSOLUTE ANY
ADD ARE
ADMINDB AS
全部 ASC
Alphanumeric — 请参阅 TEXT ASSERTION
ALTER AUTHORIZATION
ALTER TABLE AUTOINCREMENT — 请参阅 COUNTER
And Avg
AS


B-C

BEGIN COLLATION
Between COLUMN
BINARY COMMIT
BIT COMP, COMPRESSION
BIT_LENGTH CONNECT
BOOLEAN — 请参阅 BIT CONNECTION
BOTH CONSTRAINT, CONSTRAINTS
BY CONTAINER
BYTE CONTAINS
CASCADE CONVERT
CATALOG 计数
CHAR, CHARACTER — 请参阅 TEXT COUNTER
CHAR_LENGTH CREATE
CHARACTER_LENGTH CURRENCY
CHECK CURRENT_DATE
CLOSE CURRENT_TIME
CLUSTERED CURRENT_TIMESTAMP
COALESCE CURRENT_USER
COLLATE CURSOR


D

DATABASE DISALLOW
DATE — 请参阅 DATETIME DISCONNECT
DATETIME DISTINCT
DAY DISTINCTROW
DEC, DECIMAL DOMAIN
DECLARE DOUBLE
Delete DROP
DESC


E-H

Eqv FOREIGN
EXCLUSIVECONNECT FROM
EXEC, EXECUTE FROM Clause
EXISTS GENERAL — 请参阅 LONGBINARY
EXTRACT GRANT
FALSE GROUP
FETCH GUID
FIRST HAVING
FLOAT, FLOAT8 — 请参阅 DOUBLE HOUR
FLOAT4 — 请参阅 SINGLE


I

IDENTITY INPUT
IEEEDOUBLE — 请参阅 DOUBLE INSENSITIVE
IEEESINGLE — 请参阅 SINGLE INSERT
IGNORE INSERT INTO
IMAGE INT, INTEGER, INTEGER4 — 请参阅 LONG
Imp INTEGER1 — 请参阅 BYTE
In INTEGER2 — 请参阅 SHORT
IN INTERVAL
INDEX INTO
INDEXCREATEDB Is
INNER ISOLATION


J-M

JOIN LONGTEXT
KEY LOWER
LANGUAGE MATCH
LAST 最大
LEFT MEMO — 请参阅 LONGTEXT
Level* 最小
Like MINUTE
LOGICAL, LOGICAL1 — 请参阅 BIT Mod
LONG MONEY — 请参阅 CURRENCY
LONGBINARY MONTH
LONGCHAR


N-P

NATIONAL Outer*
NCHAR OUTPUT
NONCLUSTERED OWNERACCESS
Not PAD
NTEXT PARAMETERS
NULL PARTIAL
NUMBER — 请参阅 DOUBLE PASSWORD
NUMERIC — 请参阅 DECIMAL PERCENT
NVARCHAR PIVOT
OCTET_LENGTH POSITION
OLEOBJECT — 请参阅 LONGBINARY PRECISION
ON PREPARE
OPEN PRIMARY
OPTION PRIVILEGES
或 PROC, PROCEDURE
ORDER PUBLIC


Q-S

REAL — 请参阅 SINGLE SMALLDATETIME
REFERENCES SMALLINT — 请参阅 SHORT
RESTRICT SMALLMONEY
REVOKE SOME
RIGHT SPACE
ROLLBACK SQL
SCHEMA SQLCODE, SQLERROR, SQLSTATE
SECOND StDev
SELECT StDevP
SELECTSCHEMA STRING — 请参阅 TEXT
SELECTSECURITY SUBSTRING
SET 合计
SHORT SYSNAME
SINGLE SYSTEM_USER
SIZE


T-Z

TABLE UPDATEOWNER
TableID* UPDATESECURITY
TEMPORARY UPPER
TEXT USAGE
TIME — 请参阅 DATETIME USER
TIMESTAMP USING
TIMEZONE_HOUR VALUE
TIMEZONE_MINUTE VALUES
TINYINT Var
TO VARBINARY — 请参阅 BINARY
TOP VARCHAR — 请参阅 TEXT
TRAILING VarP
TRANSACTION VARYING
TRANSFORM VIEW
TRANSLATE WHEN
TRANSLATION WHENEVER
TRIM WHERE
TRUE WITH
UNION WORK
UNIQUE Xor
UNIQUEIDENTIFIER YEAR
UNKNOWN YESNO — 请参阅 BIT
UPDATE ZONE
UPDATEIDENTITY

[gois]

晕
原来把
DateTime
重利用了！