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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
