Thanks Christopher for the answer, but how can I convert the parameter enumeration to an array inside the sitemap?! Can I use the RequestParamAction action?!
Thanks in advance, Carlos Dias ----- Original Message ----- From: "Christopher Painter-Wakefield" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, April 07, 2004 8:03 PM Subject: Re: Sql type for request parameter with multiple values > > > > > I think you'll have to convert the request parameter enumeration to an > array, and then you should be able to use jdbc's setArray() > (<esql:parameter type="array">...). But I've never tried this, so YMMV. > > -Christopher > > > > > |---------+----------------------------> > | | "Carlos Dias" | > | | <[EMAIL PROTECTED]>| > | | | > | | 04/07/2004 01:07 | > | | PM | > | | Please respond to| > | | users | > | | | > |---------+----------------------------> > >--------------------------------------------------------------------------- -----------------------------------| > | | > | To: <[EMAIL PROTECTED]> | > | cc: | > | Subject: Sql type for request parameter with multiple values | > >--------------------------------------------------------------------------- -----------------------------------| > > > > > Hi, > Here is my problem: > I want to pass a request parameter to an SQL Statement, but my problem is > that this parameter contains more that one value. > I want to know what is the sql type to use (the database is Oracle) in this > case. Can I use the ARRAY type?! > > Thanks in advance, > Carlos Dias > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
