I have even tried using list($1, $2... ) and bind the values. But it threw exception.
"only Literals and Keywords(nil and undefined) can be used." -----Original Message----- From: Alexey A. Efimov [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 15, 2002 12:19 AM To: [EMAIL PROTECTED] Subject: Re: [castor-dev] LIST operator Yes, I have mistake, pardon... apostrof only for char symbol. try use: list($1, $2, $3 ....) and query.bind for all. generate query in loop. -----Original Message----- From: Satish Cattamanchi [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 15, 2002 1:01 AM To: [EMAIL PROTECTED] Subject: Re: [castor-dev] LIST operator Here's what I have already tried. values are in the format xxxxx-xxxxx-xxxxx..... >>>list("value1", "value2", "value3") is converted to sql syntax >>>..in(''value1'', ''value2'', ''value3'') >>>list('value1', 'value2', 'value3'), I get following exception org.exolab.castor.jdo.oql.InvalidCharException: Character literals may only contain a single character or escape sequence. Position: 470 >>>list(value1, value2, value3), I get following exception [Default] WARN [RMI TCP Connection(13)-192.168.2.129] <classname> - Unable to find collection of entities in database ROOT[An incorrect token type was found near - (18, need 26]: org.exolab.castor.jdo.oql.OQLSyntaxException: An incorrect token type was found near - (18, need 26 at org.exolab.castor.jdo.oql.Parser.match(Parser.java:144) here what EBNF for OQL syntax says. charLiteral ::= 'character' stringLiteral ::= "{character}" thanks for your response. ----------------------------------------------------------- If you wish to unsubscribe from this mailing, send mail to [EMAIL PROTECTED] with a subject of: unsubscribe castor-dev ----------------------------------------------------------- If you wish to unsubscribe from this mailing, send mail to [EMAIL PROTECTED] with a subject of: unsubscribe castor-dev ----------------------------------------------------------- If you wish to unsubscribe from this mailing, send mail to [EMAIL PROTECTED] with a subject of: unsubscribe castor-dev
