You can use SqlFunctionProjection together with GreaterThan. Is that clear?
Tuna Toksöz http://tunatoksoz.com http://turkiyealt.net http://twitter.com/tehlike Typos included to enhance the readers attention! On Mon, Mar 2, 2009 at 3:05 PM, Colin Ramsay <[email protected]> wrote: > > Hi all, > > Given this data: > > Feed includedFeed = new Feed { > LastUploaded = DateTime.Now.AddHours(-6), > UploadFrequencyInHours = 5 > }; > > Feed excludedFeed = new Feed { > LastUploaded = DateTime.Now, > UploadFrequencyInHours = 5 > }; > > I would like to query the database using the criteria API to get > "pending feeds", ie. ones which have not been uploaded within the > UploadFrequencyInHours window. Something like this in SQL: > > WHERE (DateDiff(hh, LastUploaded, getdate()) >= > UploadFrequencyInHours) > > Is there a method of doing this with Criteria? > > Thanks, > Colin. > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/nhusers?hl=en -~----------~----~----~----~------~----~------~--~---
