Solved

ASP and ORACLE BLOB question

Posted on 2004-04-06
6
173 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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

Shoutout to Emily Plummer (http://www.experts-exchange.com/members/eplummer26.html) for giving me this article! She did most of it, I just finished it up and posted it for her :)    Introduction In a previous article (http://www.experts-exchang…
Introduction Since I wrote the original article about Handling Date and Time in PHP and MySQL several years ago, it seemed like now was a good time to update it for object-oriented PHP.  This article does that, replacing as much as possible the pr…
Viewers will learn about arithmetic and Boolean expressions in Java and the logical operators used to create Boolean expressions. We will cover the symbols used for arithmetic expressions and define each logical operator and how to use them in Boole…
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…

751 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