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]

Reply via email to