Mailing-List: contact torque-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Apache Torque Users List" <torque-user@db.apache.org>
Received-SPF: pass (hermes.apache.org: local policy)
Message-ID: <429DAC2B.5060500@reea.net>
Date: Wed, 01 Jun 2005 15:38:03 +0300
From: Andras Balogh <andras@reea.net>
User-Agent: Mozilla Thunderbird 0.8 (Windows/20040913)
MIME-Version: 1.0
To: Apache Torque Users List <torque-user@db.apache.org>
Subject: Re: Help With Criteria for Special SQL
References: <429DA1A4.5040406@fox5.co.za>
In-Reply-To: <429DA1A4.5040406@fox5.co.za>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Hello,

    This should be possible with Criteria.CUSTOM, check here:
http://db.apache.org/torque/criteria-howto.html
    I think in your case it would be something like:
crit.add(CategoryPeer.CODE ,(Object)"Category.CODE + '%' LIKE '1' 
",Criteria.CUSTOM);


Best regards,
Andras.

Trevor Miller wrote:

> Hi,
>
> Is it possible to do the following select statement using a Criteria? 
> I can't seem to figure out how to do it.
>
> SQL:
> SELECT * FROM Category, ExtraCategoryInfo WHERE Category.CODE + '%' 
> LIKE '1';
>
> It seems strange but it actually works.
>
> Any help would be greatly appreciated.
>
> PS, any developers reading, keep up the good work, torque is excellent 
> ;o)
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org
>


---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org