Thanks,
I guess another option would be to use JBoss-QL. Am I correct?
Thanks
Simone
----- Original Message -----
From: "Ingo Bruell" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, June 25, 2003 11:08 AM
Subject: AW: [JBoss-user] EJBQL >= for dates
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Hi,
>
> you can not use '>=' or '<=' with attributes of type date only '=', '<',
'>'
> and
> '<>' are allowed like the message said. If you need such behavior, you
could
> combine them with an 'or' or 'and' operator.
>
> > I am trying to use >= and <= in my EJB-QL and I get the following
error:
> > org.jboss.deployment.DeploymentException: Error compiling EJB-QL
statement
> > 'SELECT OBJECT(o) FROM MDSKeyVector o WHERE o.className = ?1
> > AND o.currency = ?2 AND o.instance = ?3 AND o.process = ?4 AND
o.location =
> > ?5 AND o.businessArea = ?6 AND o.name = ?7 AND o.asOfDate
> > >= ?8 AND o.asOfDate <= ?9'; - nested throwable:
> > (org.jboss.ejb.plugins.cmp.ejbql.ParseException: Encountered ">=" at
line 1,
> > column 19
> > 5.
> > Was expecting one of:
> > ">" ...
> > "<" ...
> > "=" ...
> > "<>" ...
> > )
> >
> > Is it not leagl EJB-QL? Also note that the above works with just < and
>
>
>
> best regards
>
> Ingo Bruell
>
> - - - ---
> <[EMAIL PROTECTED]>
> <ICQ# 40377720>
> Oldenburg PGP-Fingerprint: CB01 AE12 B359 87C4 BF1C 953C 8FE7 C648 169E
E5FC
> Germany PGP-Public-Key available at pgpkeys.mit.edu
>
> -----BEGIN PGP SIGNATURE-----
> Version: PGPfreeware 6.5.8 for non-commercial use <http://www.pgp.com>
>
> iQA/AwUBPvlmbI/nxkgWnuX8EQLWNACbBcdIbEFtnuotkm0H43NyfgLK2wAAoPjJ
> Nui6g8t+gdvS1cnYC6kCNBa5
> =yI/E
> -----END PGP SIGNATURE-----
>
>
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by: INetU
> Attention Web Developers & Consultants: Become An INetU Hosting Partner.
> Refer Dedicated Servers. We Manage Them. You Get 10% Monthly Commission!
> INetU Dedicated Managed Hosting http://www.inetu.net/partner/index.php
> _______________________________________________
> JBoss-user mailing list
> [EMAIL PROTECTED]
> https://lists.sourceforge.net/lists/listinfo/jboss-user
>
-------------------------------------------------------
This SF.Net email is sponsored by: INetU
Attention Web Developers & Consultants: Become An INetU Hosting Partner.
Refer Dedicated Servers. We Manage Them. You Get 10% Monthly Commission!
INetU Dedicated Managed Hosting http://www.inetu.net/partner/index.php
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
