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(SupplierInvoice.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.
