Classic ASP Discussion - Microsoft JET Database Engine (0x80040E14

Print Page | Close Window

Microsoft JET Database Engine (0x80040E14

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=7323
Printed Date: 01 April 2026 at 1:00am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Microsoft JET Database Engine (0x80040E14

Posted By: ngaisteve1
Subject: Microsoft JET Database Engine (0x80040E14
Date Posted: 16 November 2003 at 9:44pm

May I know what went wrong with this sql statement? It says

Microsoft JET Database Engine (0x80040E14)
Syntax error in UPDATE statement.

SQL = "UPDATE reservationdetails, reservation SET (Quantity) = '" & qty & "' " _
& "WHERE ReservationDetails.ReservationID = Reservation.ReservationID AND status = 'temp' "

Thanks.

Replies:

Posted By: MorningZ
Date Posted: 17 November 2003 at 6:34am

UPDATE reservationdetails, reservation SET

the format for an update statement is:

UPDATE tablename SET col1 = val1, col2 = val2, col3 = val3 WHERE where clause

-------------
Contribute to the working anarchy we fondly call the Internet