SQL-syntax error

Question

What is wrong with this SQL-syntax?

INSERT INTO chatt (user, msg, ip) VALUES('testUser', 'testMsg', '81.235.154.103')

The server is running some IIS with an unknown SQL version, but the files has to be in access 2000-format. The fields i've got are id, user, msg, ip, datum. 1st one is a counter, last one is a date/time and the rest are text fields. How do i insert into those three fields?

What is the error it gives?

anothershrubery
– anothershrubery

2011-02-14 14:14:20 +00:00
Commented Feb 14, 2011 at 14:14 — anothershrubery
– anothershrubery, Commented Feb 14, 2011 at 14:14

Mark Wilkins · Accepted Answer · 2011-02-14 14:14:41Z

4

user may be a reserved word. Try putting it in brackets [user]

answered Feb 14, 2011 at 14:14

Mark Wilkins

41.3k5 gold badges61 silver badges111 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Adam Robinson · Accepted Answer · 2011-02-14 14:18:10Z

2

Without the actual error message we can't really tell, but two obvious things jump out:

user is a reserved word; enclose it in square braces: [user]
Your datum field may be not null, which means you need to provide a value for it in your statement.

answered Feb 14, 2011 at 14:18

Adam Robinson

186k36 gold badges294 silver badges351 bronze badges

Collectives™ on Stack Overflow

SQL-syntax error

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related