Mailing-List: contact torque-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Apache Torque Users List" <torque-user@db.apache.org>
Received-SPF: pass (herse.apache.org: local policy)
Content-Class: urn:content-classes:message
MIME-Version: 1.0
Subject: RE: doUpdate() problem in torque 3.2
Date: Mon, 11 Jun 2007 14:51:20 -0400
Message-ID: <DD010EBC85F76E40BCE279B40E0860C0358785@CBCMAIL.cbc.local>
Thread-topic: doUpdate() problem in torque 3.2
Thread-Index: AceoT/73feNTPzL7RKqPQT4sPhE6BAECSt0g
References: <DD010EBC85F76E40BCE279B40E0860C0358430@CBCMAIL.cbc.local>
From: "Neelima Yadla" <Neelima.Yadla@CBC-Companies.com>
To: "Apache Torque Users List" <torque-user@db.apache.org>
Content-Type: text/plain;
 charset=us-ascii
Content-Transfer-Encoding: quoted-printable

I figured out the problem where it is happening. I have a question with
village, Is village is not support for editing primary key fields???
Oracle allows me to update a primary key field in a table but when I try
to update through my web screen torque (basically village) returns me
the error that it is a key field. How to provide a user to change the
primary key field also???

-----Original Message-----
From: Neelima Yadla=20
Sent: Wednesday, June 06, 2007 11:33 AM
To: Apache Torque Users List
Subject: doUpdate() problem in torque 3.2

I have upgraded torque from 3.0 to 3.2 and also tdk from 2.2 to 2.3, the
doUpdate() is always giving me error " ... is a key value cannot be
updated".

=20

ValidOptionPeer.doUpdate(selectCriteria, criteria);

=20

Where my criteria is as follows,

=20

=20

if ((validOptionName !=3D null) && (validOptionName.length() > 0))

                    criteria.add(ValidOptionPeer.OPTION_NAME, (Object)
validOptionName, Criteria.LIKE);

                if ((validOptionDescription !=3D null) &&
(validOptionDescription.length() > 0))

                    criteria.add(ValidOptionPeer.OPTION_DESCRIPTION,
(Object) validOptionDescription, Criteria.LIKE);

=20

OPTION_NAME is the primary key in my table. As per torque document, we
have to give only set values in criteria but I didn't get how the above
is to be work in torque 3.0. If I remove the Option_name from
criteria.add it works fine but not getting any error message if user
tries to modify the option_name.

=20

Also, how to handle multiple primary key fields in
doUpdate(selectCriteria, criteria);

=20

I appreciate any help.

=20

Thanks,

=20

Neelima

=20

=20

=20

Neelima Yadla

Programmer/Analyst - Score Group

Office : (614) 273-4680

=20


---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org