Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

ASP and ORACLE BLOB question

Posted on 2004-04-06
6
Medium Priority
?
176 Views
Last Modified: 2010-04-06
I am getting an error

Error Type:
Microsoft Cursor Engine (0x80004005)
Key column information is insufficient or incorrect. Too many rows were affected by update.

In an ASP page,  on this line it is trying to assign a value to a variable from ORACLE database
and the datatype of column is BLOB.

Its urgent could anyone please reply.

Thanks
0
Comment
Question by:Preetexpexc
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
6 Comments
 
LVL 7

Expert Comment

by:ramesh12
ID: 10770118
This kind of error usually occurs when you try to update duplicate records.

Finrst find in your table if you have duplicate records
0
 

Author Comment

by:Preetexpexc
ID: 10776921
Hi Ramesh,
0
 

Author Comment

by:Preetexpexc
ID: 10776963
Hi Ramesh,
     I already tried that.
     Its just one row.
     like this
     strqry = select one, two from table where fields = ABC (this 'fields ' is Primary Key)
     objrs.open strQry, objConn, adOpenDynamic, adLockPessimistic, adCmdText
     then extract these two values in two variables.(one variable is NUMBER and two variable is   BLOB).ONE Number is incremented by 1 and BLOB is extracted to a variable and nothing else done
then

objRS.UPDATE ----- This is where I get the error

All Help would be appreciated.

Thanks
 
0
 

Author Comment

by:Preetexpexc
ID: 10777226
OK........ I found the answer all I had to do was select the primary_key of the table in select statement and it works.

Thanks doe everyone's help
0
 

Accepted Solution

by:
PashaMod earned 0 total points
ID: 11006929
PAQed, with points refunded (100)

PashaMod
Community Support Moderator
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Preface This is the third article about the EE Collaborative Login Project. A Better Website Login System (http://www.experts-exchange.com/A_2902.html) introduces the Login System and shows how to implement a login page. The EE Collaborative Logi…
Without even knowing it, most of us are using web applications on a daily basis.  In fact, Gmail and Yahoo email, Twitter, Facebook, and eBay are used by most of us daily—and they are web applications. We generally confuse these web applications to…
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…
The viewer will learn the basics of jQuery including how to code hide show and toggles. Reference your jQuery libraries: (CODE) Include your new external js/jQuery file: (CODE) Write your first lines of code to setup your site for jQuery…

704 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question