asp_databases thread: Date and error "80040e14"
Message #1 by "Eric Van Camp" <eric@a...> on Tue, 19 Jun 2001 10:30:53 +0200
|
|
i insert here my sql query
INSERT INTO
USERS(CoyID,UserID,EMAIL,Password,UserFirstName,UserLastName,Rights,Creat
edt) VALUES
('UBIZEN','UBIZEN','ubizen','ubizen','ubizen','ubizen',3,#19/06/01
02:54:31#)
I insert the value of the date with "now"
Met Vriendelijke groet,
Eric Van Camp
Atmilestone BVBA
Trolieberg 74
3010 Kessel-lo
Tel:016/35.69.99
Fax:016/35.57.90
eric@a... <mailto:eric@a...>
<http://www.atmilestone.be/>
Message #2 by "Ken Schaefer" <ken@a...> on Tue, 19 Jun 2001 20:08:13 +1000
|
|
http://www.adopenstatic.com/faq/80040e14.asp
The problem is not your date - it's your field names.
Cheers
Ken
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
----- Original Message -----
From: "Eric Van Camp" <eric@a...>
To: "ASP Databases" <asp_databases@p...>
Sent: Tuesday, June 19, 2001 6:30 PM
Subject: [asp_databases] Date and error "80040e14"
i insert here my sql query
INSERT INTO
USERS(CoyID,UserID,EMAIL,Password,UserFirstName,UserLastName,Rights,Createdt
) VALUES ('UBIZEN','UBIZEN','ubizen','ubizen','ubizen','ubizen',3,#19/06/01
02:54:31#)
I insert the value of the date with "now"
|