# Hi, insert into table error with asp code?

**URL:** https://forum.kirupa.com/t/hi-insert-into-table-error-with-asp-code/93400
**Category:** Uncategorized
**Created:** [October 30, 2003, 11:25am UTC](https://forum.kirupa.com/t/hi-insert-into-table-error-with-asp-code/93400 "2003-10-30T11:25:20Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![SBUH](https://avatars.discourse-cdn.com/v4/letter/s/4bbf92/32.png) [@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/93400/1 "2003-10-30T11:25:20Z")

</div>

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