Thank you Tuna!
On Mar 2, 1:34 pm, Tuna Toksoz <[email protected]> wrote:
> 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özhttp://tunatoksoz.comhttp://turkiyealt.nethttp://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
-~----------~----~----~----~------~----~------~--~---
