Missing quotes. It should read: sNewCallBackSQLINSERT INTO CallBacks (LearnerID,CallDate,CallTime) VALUES (2113 , '01/01/2002' , '0:00')
> -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, December 03, 2002 9:41 AM > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: Trying2insert Date2table > > > Hi, > > I am trying to insert the following value to a Date/Time > field in SQLServer7 table. > > Here is the Line values Im tring to execute > > sNewCallBackSQLINSERT INTO CallBacks > (LearnerID,CallDate,CallTime) VALUES (2113 , 01/01/2002 , 0:00) > > > Here is the statement: > > sNewCallBackSQL = "INSERT INTO CallBacks > (LearnerID,CallDate,CallTime) VALUES (" & ExLearnerID & " , > " & sCallBackDate & " , " & sCallBackTime & ")" > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php