[Rife-users] postgres query using CAST and INTERVAL ... vs. .getCountQuery()

2007-03-01 Thread David HM Spector
I'm ttrying to use the ContentQueryManager to find out the rate of change of entries into one of my tables... I am using the following query: private ContentQueryManagerVenue mVenueManager = new ContentQueryManagerVenue(mDatasource, Venue.class); NewVenuesThisWeek =

Re: [Rife-users] postgres query using CAST and INTERVAL ... vs. .getCountQuery()

2007-03-01 Thread Geert Bevin
Just write it as a full where statement: .where(creation_dt CAST ('1 week' AS INTERVAL)) Otherwise the second argument will be auto-escape as a protection against SQL injection On 01 Mar 2007, at 15:32, David HM Spector wrote: I'm ttrying to use the ContentQueryManager to find out the rate

Re: [Rife-users] postgres query using CAST and INTERVAL ... vs. .getCountQuery()

2007-03-01 Thread Geert Bevin
no problem :-) On 01 Mar 2007, at 15:44, David HM Spector wrote: homer DOH! /homer :) ok.. this is why I probably should not stay up so late. ...thank you. David -- Geert Bevin Uwyn Use what you need - http://uwyn.com RIFE Java application framework - http://rifers.org Music and words -