Re: How to handle relationship properties?
Re: How to handle relationship properties?
- Subject: Re: How to handle relationship properties?
- From: Art Isbell <email@hidden>
- Date: Tue, 3 Jan 2006 16:17:50 -1000
On Jan 3, 2006, at 12:38 PM, Miguel Arroz wrote:
NSMutableArray args = new NSMutableArray();
//args.addObject(EOUtilities.primaryKeyForObject(context,
user).objectForKey("userID"));
args.addObject(user);
EOQualifier userQualifier =
EOQualifier.qualifierWithQualifierFormat("userID = %@", args);
args.removeAllObjects();
//args.addObject(EOUtilities.primaryKeyForObject(context,
account).objectForKey("accountID"));
args.addObject(account);
EOQualifier accountQualifier =
EOQualifier.qualifierWithQualifierFormat("accountID = %@", args);
Reason:
EvaluateExpression failed:
<com.webobjects.jdbcadaptor.PostgresqlExpression: "SELECT
t0.account_id, t0.user_id, t0.user_type FROM account_user t0 WHERE
(t0.user_id = ?::int8 AND t0.account_id = ?::int8)" withBindings: 1:
{values = {lastName = "Arroz"; status = 1; firstName = "Miguel";
email = "email@hidden"; registrationDate = 2006-01-02 14:13:08
Etc/GMT; language = "English"; timezone = "GMT"; password =
"FQrObUivnL2YCbNY+6pieSV7Co8="; activationKey = "8b76da91-
c0a8-02c9-00a4-835a0b87b8c5"; accountUsers = ("<AccountUser 83a95d
_EOVectorKeyGlobalID[AccountUser (java.lang.Integer)3,
(java.lang.Integer)2]>"); }; this = "<User d3cae0
_EOIntegralKeyGlobalID[User (java.lang.Integer)2]>"; }(userID), 2:
{values = {accountUsers =
"<com.webobjects.eocontrol._EOCheapCopyMutableArray d227f
(<EOAccessArrayFaultHandler accountUsers _EOIntegralKeyGlobalID
[Account (java.lang.Integer)3]>)>"; survey =
"<com.webobjects.eocontrol._EOCheapCopyMutableArray 3ecbfc
(<EOAccessArrayFaultHandler survey _EOIntegralKeyGlobalID[Account
(java.lang.Integer)3]>)>"; name = "Miguel's Account"; }; this =
"<Account 8ad183 _EOIntegralKeyGlobalID[Account (java.lang.Integer)
3]>"; }(accountID)>: Next exception:SQL State:22023 -- error code:
0 -- msg: No value specified for parameter 1.
Look at the values for parameters 1. and 2.; they're user and
account objects instead of userID and accountID. That's because
you're still creating qualifiers with userID and accountID for keys
and user and account objects for values. Do as others recommended:
create qualifiers with user and account as keys.
Aloha,
Art
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden