Hi all, Probably a silly question: but how do I grab the magnolia-generated URL of a page? request.getPathURI() pulls the actual file path; but I want the re-written URL that appears to to the client.
Do I have to recreate it via the magnolia API functions? Thanks in advance! Mike D. Jones > -----Original Message----- > From: [email protected] [mailto:[EMAIL PROTECTED] > Sent: Tuesday, November 06, 2007 3:35 AM > To: [email protected] > Subject: Re: [magnolia-user] JCR SQL Query on date? > > This seems to be complicated since nobody has answered so far. So I > dug a bit deeper: > > select * from nt:base where date >= '2007-11-04T23:59:59' > -> finds everything > > tried this: http://www.mail-archive.com/[EMAIL PROTECTED]/ > msg01519.html > select * from nt:base where date >= TIMESTAMP '2007-11-04T23:59:59' > -> finds nothing, throws exception > > select * from nt:base where date >= TIMESTAMP '2007-11-01T00:00:00.000 > +01:00' > -> WORKS! > > So the time zone info seems to be crucial! > > Regards, > Will > > On 05.11.2007, at 18:30, Will Scheidegger wrote: > > > List > > > > Could someone please give me a pointer on how to search on dates in > > JCR SQL queries? The documentation in the JSR170 specification is a > > bit slim... > > On page 101 I found the operators that are accepted and under > > 6.2.5.1 it tells you how to format a date. But when I try this: > > > > SELECT * FROM nt:base WHERE date >= '2007-11-04T23:59:59' order by > > date > > > > I get way to many records. And this: > > > > SELECT * FROM nt:base WHERE date >= 2007-11-04T23:59:59 order by date > > > > leads to an exception. So any help is warmly appreciated! > > Thanks! > > > > -Will > > > > ---------------------------------------------------------------- > > for list details see > > http://documentation.magnolia.info/docs/en/editor/stayupdated.html > > ---------------------------------------------------------------- > > > ---------------------------------------------------------------- > for list details see > http://documentation.magnolia.info/docs/en/editor/stayupdated.html > ---------------------------------------------------------------- ---------------------------------------------------------------- for list details see http://documentation.magnolia.info/docs/en/editor/stayupdated.html ----------------------------------------------------------------
