RE: [JBoss-user] EJBQL = for dates
Or... you didn't notice that I flipped x and y around in the righthand side... -- Danny Yates -Original Message- From: Marcin Gryszkalis [mailto:[EMAIL PROTECTED] Sent: 29 June 2003 16:28 To: [EMAIL PROTECTED] Subject: Re: [JBoss-user] EJBQL = for dates On 2003-06-25 15:03, [EMAIL PROTECTED] wrote: Another option would be to reverse the sense of your comparison: (x = y) == (y x) Then you can use the standard operator. You're wrong (or just made mistake), it should be: (x = y) = (NOT x y) regards Marcin --- This SF.Net email sponsored by: Free pre-built ASP.NET sites including Data Reports, E-commerce, Portals, and Forums are available now. Download today and enter to win an XBOX or Visual Studio .NET. http://aspnet.click-url.com/go/psa0016ave/direct;at.asp_061203_01/01 ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user _ Notice to recipient: The information in this internet e-mail and any attachments is confidential and may be privileged. It is intended solely for the addressee. If you are not the intended addressee please notify the sender immediately by telephone. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. When addressed to external clients any opinions or advice contained in this internet e-mail are subject to the terms and conditions expressed in any applicable governing terms of business or client engagement letter issued by the pertinent Bank of America group entity. If this email originates from the U.K. please note that Bank of America, N.A., London Branch, Banc of America Securities Limited and Banc of America Futures Incorporated are regulated by the Financial Services Authority. _ --- This SF.Net email sponsored by: Free pre-built ASP.NET sites including Data Reports, E-commerce, Portals, and Forums are available now. Download today and enter to win an XBOX or Visual Studio .NET. http://aspnet.click-url.com/go/psa0016ave/direct;at.asp_061203_01/01 ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
RE: [JBoss-user] EJBQL = for dates
Ooops... that's not right is it?! Oh well, you get the general idea! :-) -- Danny Yates -Original Message- From: Yates, Danny Sent: 30 June 2003 10:01 To: [EMAIL PROTECTED] Subject: RE: [JBoss-user] EJBQL = for dates Or... you didn't notice that I flipped x and y around in the righthand side... -- Danny Yates -Original Message- From: Marcin Gryszkalis [mailto:[EMAIL PROTECTED] Sent: 29 June 2003 16:28 To: [EMAIL PROTECTED] Subject: Re: [JBoss-user] EJBQL = for dates On 2003-06-25 15:03, [EMAIL PROTECTED] wrote: Another option would be to reverse the sense of your comparison: (x = y) == (y x) Then you can use the standard operator. You're wrong (or just made mistake), it should be: (x = y) = (NOT x y) regards Marcin --- This SF.Net email sponsored by: Free pre-built ASP.NET sites including Data Reports, E-commerce, Portals, and Forums are available now. Download today and enter to win an XBOX or Visual Studio .NET. http://aspnet.click-url.com/go/psa0016ave/direct;at.asp_061203_01/01 ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user _ Notice to recipient: The information in this internet e-mail and any attachments is confidential and may be privileged. It is intended solely for the addressee. If you are not the intended addressee please notify the sender immediately by telephone. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. When addressed to external clients any opinions or advice contained in this internet e-mail are subject to the terms and conditions expressed in any applicable governing terms of business or client engagement letter issued by the pertinent Bank of America group entity. If this email originates from the U.K. please note that Bank of America, N.A., London Branch, Banc of America Securities Limited and Banc of America Futures Incorporated are regulated by the Financial Services Authority. _ --- This SF.Net email sponsored by: Free pre-built ASP.NET sites including Data Reports, E-commerce, Portals, and Forums are available now. Download today and enter to win an XBOX or Visual Studio .NET. http://aspnet.click-url.com/go/psa0016ave/direct;at.asp_061203_01/01 ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user _ Notice to recipient: The information in this internet e-mail and any attachments is confidential and may be privileged. It is intended solely for the addressee. If you are not the intended addressee please notify the sender immediately by telephone. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. When addressed to external clients any opinions or advice contained in this internet e-mail are subject to the terms and conditions expressed in any applicable governing terms of business or client engagement letter issued by the pertinent Bank of America group entity. If this email originates from the U.K. please note that Bank of America, N.A., London Branch, Banc of America Securities Limited and Banc of America Futures Incorporated are regulated by the Financial Services Authority. _ --- This SF.Net email sponsored by: Free pre-built ASP.NET sites including Data Reports, E-commerce, Portals, and Forums are available now. Download today and enter to win an XBOX or Visual Studio .NET. http://aspnet.click-url.com/go/psa0016ave/direct;at.asp_061203_01/01 ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
Re: [JBoss-user] EJBQL = for dates
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 GermanyPGP-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
RE: [JBoss-user] EJBQL = for dates
Another option would be to reverse the sense of your comparison: (x = y) == (y x) Then you can use the standard operator. Dan. -- Danny Yates -Original Message- From: Simone Milani [mailto:[EMAIL PROTECTED] Sent: 25 June 2003 13:42 To: [EMAIL PROTECTED] Subject: Re: [JBoss-user] EJBQL = for dates 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 GermanyPGP-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 _ Notice to recipient: The information in this internet e-mail and any attachments is confidential and may be privileged. It is intended solely for the addressee. If you are not the intended addressee please notify the sender immediately by telephone. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. When addressed to external clients any opinions or advice contained in this internet e-mail are subject to the terms and conditions expressed in any applicable governing terms of business or client engagement letter issued by the pertinent Bank of America group entity. If this email originates from the U.K. please note that Bank of America, N.A., London Branch, Banc of America Securities Limited and Banc of America Futures Incorporated are regulated by the Financial Services Authority. _ --- 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