SQL query is failing

theknight

A Database Error Occurred
Error Number:

The statement has been terminated.

INSERT INTO WebsiteSessions (session_key, account_id, timestamp) VALUES ('50a668a56909b0e23e550cdc4aa77417a2943928', 170, 1316199189)

Only column I have not specified in the primary key column, which is ID. Shouldn't it autoincrement automatically, I am using MSSQL.

awbrowni30

Not sure but give this a try...


Missing single qoutes

INSERT INTO WebsiteSessions (session_key, account_id, timestamp) VALUES ('50a668a56909b0e23e550cdc4aa77417a2943928', 170, 1316199189)


Added single qoutes

INSERT INTO WebsiteSessions (session_key, account_id, timestamp) VALUES ('50a668a56909b0e23e550cdc4aa77417a2943928', '170', '1316199189')

bradgrafelman

awbrowni30;10987902 wrote:

Not sure but give this a try...


Missing single qoutes

INSERT INTO WebsiteSessions (session_key, account_id, timestamp) VALUES ('50a668a56909b0e23e550cdc4aa77417a2943928', 170, 1316199189)


Added single qoutes

INSERT INTO WebsiteSessions (session_key, account_id, timestamp) VALUES ('50a668a56909b0e23e550cdc4aa77417a2943928', '170', '1316199189')

Numeric data should not be surrounded by quotes (although I don't think "timestamp" should be a numeric field, considering there should be more specific column types for that).

johanafm

theknight;10987869 wrote:

The statement has been terminated.
[/quote]
To get any useful information out of SQL Server, you'd need to know the error message before the incredibly informative and useful message seen above. So, what happens when you execute the query directly where you can see both error messages instead of just the last one?


[QUOTE=theknight;10987869]
the primary key column, which is ID. Shouldn't it autoincrement
[/QUOTE]
You tell us. We didn't define the schema, nor do we know what it looks like.