Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 Other Topics
 Mysterious error in INSERT statement

Author  Topic 

graz
Chief SQLTeam Crack Dealer

4149 Posts

Posted - 2000-08-03 : 00:00:00
say writes I'm currently admining a site that integrates content tightly with an MDB database through an SQL server, using ASP. Lately, I've been working on a system for vote registration, and it culminates with the following sql string:

INSERT INTO Votes (DeltakerID, IP, RegisterCount, Game1, Game2, Music, Graphix, Demo, Design, Timestamp) VALUES (1, '195.204.149.30', 1, 'None', 'None', 'None', 'None', 'None', 'None', '03-08-00 09:30:33');

This creates the following error: Syntax error in INSERT INTO statement.

Why?? I just can't see that there is any obvious syntax errors in this statement. All the datatypes are correct, too.
   

- Advertisement -