Wrox Home  
Search P2P Archive for: Go

  Return to Index  

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"






  Return to Index