Re: Réf. : Re: using functions with more than one parameters in a criteria or in the attributes

[Jakob Braeuchi]

hi matthieu,

afaik there's no download available so you'll have to get it from cvs head.

hth
jakob

[EMAIL PROTECTED] schrieb:

Hi,
where can i get it ?

Cordialement

Matthieu PATOU

DINQ/DSIN/SIDM/VNVO/VOIN
Téléphone 01 30 19 17 91  (29 17 91)

Jakob Braeuchi <[EMAIL PROTECTED] h> Pour OJB Users List 09/08/2005 22:14 <ojb-user@db.apache.org> cc Veuillez Objet répondre à Re: using functions with more than OJB Users List one parameters in a criteria or in <[EMAIL PROTECTED] the attributes che.org>

hi matthieu,

this is a known issue with ojb 1.0.x. have you tried it with ojb 1.1 ?

jakob

[EMAIL PROTECTED] schrieb:

Hello list,
i'm willing to use a function that needs 2 parameters (ie: concat).
If one parameter is not a column or an attribute OJB acheive to produce
correct code.
Example:
   public static void fooDAO(PersistenceBroker broker)
   {
       String[] attributs = {"CONCAT(char(max(purchaseDate)), 'bar')"};
       ReportQueryByCriteria query = new ReportQueryByCriteria(purchase.
class, attributs, null);
       Iterator iter = broker.getReportQueryIteratorByQuery(query);
   }

but if i put two parameters that are either attributes or column name

then

ojb failed to replace the attributes (if the two parameters are column
names of course it works but there is a side effect problem with the

table

alias).

Also: is there a way to get table alias or to set it in order to avoid

some

troubles when you use direct SQL ?

Cordialement

Matthieu PATOU

DINQ/DSIN/SIDM/VNVO/VOIN
Téléphone 01 30 19 17 91  (29 17 91)


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]




---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]