I have no idea, it all depends on the functions, and its specific syntax. but in general, it should work, or i hope it will work.
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:33 PM, Colin Ramsay <[email protected]> wrote: > > Would that work even if I switched my config from SqlServer to MySQL - > i.e. does it depend on database-specific syntax? > > On Mar 2, 1:25 pm, Tuna Toksoz <[email protected]> wrote: > > You can use SqlFunctionProjection together with GreaterThan. > > Is that clear? > > > > Tuna Toksözhttp://tunatoksoz.comhttp://turkiyealt.nethttp:// > 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 -~----------~----~----~----~------~----~------~--~---
