• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 205
  • Last Modified:

Inset/update Oracle database

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
0
mrong
Asked:
mrong
2 Solutions
 
George K.Commented:
Have you checked that you use the appropriate  datatypes?
Also check in case you have null values.
0
 
ajexpertCommented:
I agree with georgekl

This error occurs when values doesnt match with datatypes or it could be NULL

Check this link

http://databases.aspfaq.com/database/what-is-this-multiple-step-ole-db-error.html
0
 
mrongAuthor Commented:
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
0

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now