<div>
Below is what I have before my IF stmt and I can't see anything wrong.<br />
<br />
Dim rsItems<br />
&nbsp; Dim blnNew<br />
&nbsp; Set rsItems = Server.CreateObject(&quot;ADODB<wbr />.Recordset<wbr />&quot;)<br />
&nbsp; rsItems.Open &quot;tbl1&quot;, objConn, adOpenForwardOnly, adLockOptimistic, adCmdTable
</div>


Below is what I have before my IF stmt and I can't see anything wrong.

Dim rsItems
  Dim blnNew
  Set rsItems = Server.CreateObject("ADODB.Recordset")
  rsItems.Open "tbl1", objConn, adOpenForwardOnly, adLockOptimistic, adCmdTable

<div>
<div class="content wysiwyg-content">
Greeting,<br />
I got error &quot;Multiple-step OLE DB operation generated errors.&quot; when using the following asp to insert/update the table.<br />
If Request(&quot;num&quot;) = &quot;&quot;&nbsp;Then<br />
&nbsp; &nbsp; &nbsp; blnNew = True<br />
&nbsp; &nbsp; &nbsp;rsItems.AddNew<br />
&nbsp; &nbsp; Else<br />
&nbsp; &nbsp; &nbsp;rsItems.Filter = &quot;shop = &quot;&nbsp;&amp; Request(&quot;num&quot;)<br />
<br />
<br />
&nbsp; &nbsp;End If<br />
&nbsp; &nbsp; rsItems(&quot;shop&quot;) = Request.Form(&quot;shop&quot;)<br />
&nbsp; &nbsp; rsItems(&quot;phone&quot;) = Request.Form(&quot;phone&quot;) &nbsp; &nbsp;<br />
&nbsp; &nbsp; rsItem.Update<br />
&nbsp; &nbsp; rsItems.Close<br />
&nbsp; &nbsp; Set rsItems = Nothing
</div>
</div>


Greeting,
I got error "Multiple-step OLE DB operation generated errors." when using the following asp to insert/update the table.
If Request("num") = "" Then
      blnNew = True
     rsItems.AddNew
    Else
     rsItems.Filter = "shop = " & Request("num")


   End If
    rsItems("shop") = Request.Form("shop")
    rsItems("phone") = Request.Form("phone")    
    rsItem.Update
    rsItems.Close
    Set rsItems = Nothing

Inset/update Oracle database

Active Server Pages (ASP) is Microsoft’s first server-side engine for dynamic web pages. ASP’s support of the Component Object Model (COM) enables it to access and use compiled libraries such as DLLs. It has been superseded by ASP.NET, but will be supported by Internet Information Services (IIS) through at least 2022.

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.