In trying to simplify the query in order not to confuse the community, I overdid it, because it would appear that the solution would be a simple:
Calendar cal = Calendar.getInstance(); cal.add(Calendar.DATE, 5); cr.add(SubscribersPeer.END_OF_SUBSCRIPTION_DATE, cal.getTime()); However, the problem I am facing is because in reality I am not comparing to a constant (5) but rather to a field from another table. The actual query is: SELECT user_id FROM details d, subscribers s WHERE s.app_id = d.app_id AND TO_DAYS(s.end_of_subscription_date) - TO_DAYS(SYSDATE()) = d.end_warning Given that the number of days until expiration varies from application to application, I want to get this as a dynamic value. I know a solution would be to do several queries (one for each application), but with a query such as the one presented above, I could do all of it in a single step. So executeQuery could also do the trick, but I would like to avoid it in order to obtain DB independence. Thanks for any help. Ruy --- Ruy Diaz Jara <[EMAIL PROTECTED]> wrote: > 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] > > __________________________________ 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]
