Preetexpexc
asked on
ASP and ORACLE BLOB question
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
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
ASKER
Hi Ramesh,
ASKER
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
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
ASKER
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
Thanks doe everyone's help
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Finrst find in your table if you have duplicate records