sql insert problem in asp

gilgalbiblewhee · #1 (**permalink**) 09-17-04, 22:03

On my first attempt to run the query I get this:

Quote:

INSERT INTO results SELECT * FROM bible WHERE text_data LIKE '%ezra%' AND text_data LIKE '%%' AND text_data LIKE '%%'
ADODB.Recordset error '800a0e78'

Operation is not allowed when the object is closed.

/kjvresp.asp, line 277

277 is

Code:

If Not RS.Eof Then

On my second run I get:

Quote:

INSERT INTO results SELECT * FROM bible WHERE text_data LIKE '%ezra%' AND text_data LIKE '%%' AND text_data LIKE '%%'
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC Microsoft Access Driver] The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again.

/kjvresp.asp, line 272

The insertion was found in the table but the output to the ASP page is somehow blocked.