Classic ASP Discussion - Syntax error in INSERT INTO statement.

Print Page | Close Window

Syntax error in INSERT INTO statement.

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=5772
Printed Date: 30 March 2026 at 11:41pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Syntax error in INSERT INTO statement.

Posted By: dhzen
Subject: Syntax error in INSERT INTO statement.
Date Posted: 15 September 2003 at 10:02pm

this is my asp script. i think there's nothing wrong with it but i still receive an error :
Microsoft JET Database Engine (0x80040E14)
Syntax error in INSERT INTO statement.

<%@ language="VBSCRIPT"%>
<% option explicit %>

<%
dim objconn,objrs
Set objConn = Server.CreateObject("ADODB.Connection")
objconn.Open strDB

Dim text1,maksud1,lanjut1,sql,rs
text1=trim(request.form("text"))
maksud1=trim(request.form("maksud"))
lanjut1=trim(request.form("lanjut"))

sql = "insert into kamus(text,maksud) values (12,21)"
objconn.execute sql
response.Redirect("add_kamus_1.asp?success=1")
%>

Replies:

Posted By: KCWebMonkey
Date Posted: 16 September 2003 at 7:07am

not sure...try this:

sql = "INSERT INTO kamus (text, maksud) VALUES ('12', '21')"