cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Marcel <emmpee...@gmail.com>
Subject Re: NamedQuery parameters
Date Mon, 24 Jul 2006 15:17:19 GMT

Ta (thanks, in case that's an Australian word) - that was my conclusion 
after some more investigation. I'll roll my own SelectQuery with 
expressions instead.

Marcel

Andrus Adamchik wrote:
> Parameters are *arbitrary* "variables" that start with a "$" sign. 
> They do not have to match the attribute names. You would define them 
> in CayenneModeler for the query. For SelectQuery this would be the 
> part of the qualifier string, i.e. "loginid = $id" . In SQLTemplate 
> they are defined in the SQL (SELECT * FROM X WHERE T = $myP).
>
> Andrus
>
>
> On Jul 24, 2006, at 10:46 AM, Marcel wrote:
>
>>
>> Hi all,
>>
>> The following is from the wiki[1]:
>>
>> ---------------
>> String[] keys = new String[] {"loginid", "password"};
>> Object[] values = new String[] {"joe", "secret"};
>>
>> NamedQuery query = new NamedQuery("Login", keys, values);
>>
>> List matchingUsers = context.performQuery(query);
>> ---------------
>>
>> I had presumed that this executes the query Login finding users where 
>> loginid = "joe" and password = "secret.
>>
>> Do the parameters need to be defined in the query beforehand? If so, 
>> how? If not, are they object attribute names or database attribute 
>> names?
>>
>> Cheers,
>>
>> Marcel
>>
>> [1] http://cwiki.apache.org/CAYDOC/namedquery.html
>>
>
>

Mime
View raw message