Problem inserting auto id into my table

[uttamkumarbagch]

I can't insert auto id into my table generating error on line 20:

<%
  Option Explicit
  dim cn 
  Dim rs
  Dim sq
  Dim i
 
  Set cn = Server.CreateObject("ADODB.Connection")
  Set rs = Server.CreateObject("ADODB.Recordset")
  cn.Open "DSN=B;UID=;PWD=;Database=Goldenlife"
 
%>
 
 
<%
 
 
 For i=10001 To 99999
 
   If rs.BOF  Then
 
 
      sq="insert into Test(id,code,Date"
      sq=sq & " VALUES "
      sq=sq & "('" & Request.Form("id") & "',"
      sq=sq & "'" & Request.Form("C") & "',"
      sq=sq & "'" & Request.Form("D") & "')"
      cn.Execute sq,recaffected
    Else
 
      Do While Not (rs.Eof)
 
      Loop
    End If
  next
%>

[jhardman]

You shouldn't ever insert an auto-id. Skip that field and it should work.

Jared