Hi Sambit!
What is r_date? Is it the name of your property? Then it should be in square
brackets in SQL2, so
select * from [nt:base] where ISDESCENDANTNODE([/MyData/]) and cast([r_date] as
date) > cast('2014-11-12T00:00:00.000+02:00' as date) and cast([r_date] as
date) > cast('2014-11-18T00:00:00.000+02:00' as date);
I forgot to add the brackets in the original reply.
Regards,
Jozef.
----- Original Message -----
From: "Sambit Pani (via Magnolia Forums)" <[email protected]>
To: "Magnolia User List" <[email protected]>
Sent: Thursday, November 27, 2014 7:49:33 AM
Subject: [magnolia-user] Re: Help in Magnolia SQL Query
hi Jozef,
many thanks for your quick response.
But still i am getting an error as
Query:
select * from [nt] where ISDESCENDANTNODE([/MyData/]) and cast(r_date(*) as
date) > cast('2014-11-12T00:00:00.000+02:00' as date) and cast(r_date as date)
> cast('2014-11-18T00:00:00.000+02:00' as date);
expected: LENGTH, NAME, LOCALNAME, SCORE, LOWER, UPPER, or CAST
its showing error near to r_date.
Sambit
--
Context is everything:
http://forum.magnolia-cms.com/forum/thread.html?threadId=b34cbea9-2d14-4263-8e6a-ad518b8c79e4
----------------------------------------------------------------
For list details, see http://www.magnolia-cms.com/community/mailing-lists.html
Alternatively, use our forums: http://forum.magnolia-cms.com/
To unsubscribe, E-mail to: <[email protected]>
----------------------------------------------------------------
----------------------------------------------------------------
For list details, see http://www.magnolia-cms.com/community/mailing-lists.html
Alternatively, use our forums: http://forum.magnolia-cms.com/
To unsubscribe, E-mail to: <[email protected]>
----------------------------------------------------------------
