Hi,
I'm trying to familiarize myself with Torque and so far I've been having some
trouble porting SQL statements to Criteria. Currently, what I am attempting to
do is to get the following query (originally MySQL 4.0):
SELECT user_id
FROM subscribers s
WHERE to_days(s.end_of_subscription_date) - to_days(SYSDATE()) = 5
The query extracts a list of users whose subscriptions to a service will end in
5 days. How can I add a Criterion with a mathematical expression? Is it
possible or do I have to use BasePeer.executeQuery()?
Regards
Ruy
__________________________________
Do you Yahoo!?
Meet the all-new My Yahoo! - Try it today!
http://my.yahoo.com
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
