Take a look at the "db:" prefix.
http://objectstyle.org/cayenne/userguide/expressions/common.html
----- Original Message -----
From: "Lothar Krenzien" <lkrenzie..eb.de>
To: <cayenne-use..bjectstyle.org>
Sent: Friday, November 25, 2005 8:20 AM
Subject: primary column in select query
>
> Hi there,
>
> I have a table which uses a character column with country codes as primary
key. Now I want to use this column in a select query. First I tried it this
way:
>
> ExpressionFactory.matchExp("toTblAddress.toTblCountry.countryCode",
searchCriteria.getCountry())
>
> This didn't worked because the column is a primary key and not defined in
the mapping file. Of course I can define a new (integer) column as primary
key, but I would like to know is there a way to use the existing column in a
query.
>
> Thanks, Lothar
> ______________________________________________________________
> Verschicken Sie romantische, coole und witzige Bilder per SMS!
> Jetzt bei WEB.DE FreeMail: http://f.web.de/?mc=021193
>
This archive was generated by hypermail 2.0.0 : Fri Nov 25 2005 - 09:01:34 EST