HI,
try like below
Map<String, Object> params = new HashMap<String, Object>();
params.put("firstdate", fromdate);
params.put("enddate", todate);
params.put("id", pocId );
Query q = pm1.newQuery(PocVacationSchedule.class, " pocId ==id &&
startDate>=:firstdate && endDate<=:enddate");
>
>
>
>
>
>
>
> On Tue, Dec 28, 2010 at 10:26 AM, Vik <[email protected]> wrote:
>
>> any updates on this please?
>>
>> Thankx and Regards
>>
>> Vik
>> Founder
>> www.sakshum.com
>> www.sakshum.blogspot.com
>>
>>
>> On Sun, Dec 26, 2010 at 8:40 PM, Vik <[email protected]> wrote:
>>
>>> Hie
>>>
>>> This is what I get using getTime.
>>>
>>>
>>> Problem with query <SELECT FROM
>>> vik.sakshum.sakshumweb.server.jdo.PocVacationSchedule WHERE pocId == 0 &&
>>> startDate.getTime()=="61251379200000" &&
>>> endDate.getTime()=="61251638400000">: Unsupported method <getTime> while
>>> parsing expression:
>>> InvokeExpression{[PrimaryExpression{startDate}].getTime(<none>)}
>>>
>>> Thankx and Regards
>>>
>>> Vik
>>> Founder
>>> www.sakshum.com
>>> www.sakshum.blogspot.com
>>>
>>>
>>> On Sat, Dec 25, 2010 at 11:12 PM, John <[email protected]> wrote:
>>>
>>>> As a wild guess (considering that there's no indication of the API or
>>>> the status that's encountered when the attempted code 'fails'), try using
>>>> startFrom.getTime() & endFrom.getTime(). This code concatenates
>>>> Date#toString() formatted date strings into the query.
>>>>
>>>> Really, it's important to use parameterized queries. Looking at this
>>>> style of code causes me to assume the app will be subject to attack in the
>>>> 'SQL'-injection style. (Acknowledging that what would be injected would
>>>> have
>>>> to be something other than SQL.)
>>>> --
>>>> You received this message because you are subscribed to the Google
>>>> Groups "Google App Engine for Java" group.
>>>> To post to this group, send email to
>>>> [email protected].
>>>> To unsubscribe from this group, send email to
>>>> [email protected]<google-appengine-java%[email protected]>
>>>> .
>>>> For more options, visit this group at
>>>> http://groups.google.com/group/google-appengine-java?hl=en.
>>>>
>>>
>>>
>> --
>> You received this message because you are subscribed to the Google Groups
>> "Google App Engine for Java" group.
>> To post to this group, send email to
>> [email protected].
>> To unsubscribe from this group, send email to
>> [email protected]<google-appengine-java%[email protected]>
>> .
>> For more options, visit this group at
>> http://groups.google.com/group/google-appengine-java?hl=en.
>>
>
>
--
You received this message because you are subscribed to the Google Groups
"Google App Engine for Java" 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/google-appengine-java?hl=en.
