I'd start with changing the SQL statement to

Code: Select all

SQL4 = "select * FROM oitems"

to see if the problem is with the query.

I don't personally use this syntax for opening a recordset

Code: Select all

Set RS4 = Server.CreateObject("ADODB.Recordset") 
RS4.open SQL4, site_content_conn, 3, 3, 1

so maybe someone else will notice if there's a problem with it.

I generally do it with

Code: Select all

set RS4 = site_content_conn.execute(SQL4,,1)