# Hi, insert into table error with asp code?
**URL:** https://forum.kirupa.com/t/hi-insert-into-table-error-with-asp-code/34251
**Category:** Uncategorized
**Created:** [October 30, 2003, 11:25am UTC](https://forum.kirupa.com/t/hi-insert-into-table-error-with-asp-code/34251 "2003-10-30T11:25:20Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@SBUH](https://forum.kirupa.com/u/SBUH)
#### Post date: [October 30, 2003, 11:25am UTC](https://forum.kirupa.com/t/hi-insert-into-table-error-with-asp-code/34251/1 "2003-10-30T11:25:20Z")
Hello, I have one table in database have the columns
ID name price ordertime
And ID column is defined as auto increase number
But when I write asp code for insert into the table like
```php
Set conn=Server. createObject("ADODB.Connection")
conn.open "xxx"
conn.Execute "insert into order values('"&name&"','"&price&"','"getdate()"')"
conn.close
```
it give error message like
An explict value for the identity column in the table 'order ’ can only be specified when a column list is used and IDENTITY\_INSERT is on
I don’t know what does error message mean and how should I correct it then?
Does any one who can help? Thanks in advance!
And I am using MS sql server 2000
---
### Author:  [@system](https://forum.kirupa.com/u/system)
#### Post date: [October 30, 2003, 3:16pm UTC](https://forum.kirupa.com/t/hi-insert-into-table-error-with-asp-code/34251/2 "2003-10-30T15:16:36Z")
**order** is an SQL reserved word, you’ll need to rename your table.
[http://pacosdrivers.com/asp/reserved/](http://pacosdrivers.com/asp/reserved/)
---
### Author:  [@system](https://forum.kirupa.com/u/system)
#### Post date: [November 2, 2003, 1:46pm UTC](https://forum.kirupa.com/t/hi-insert-into-table-error-with-asp-code/34251/3 "2003-11-02T13:46:00Z")
Thanks for your answer. That is really the problem I met. Thanks for the useful link!!