Re: Sql type for request parameter with multiple values

[Christopher Painter-Wakefield]

I doubt it.  If you are doing this using SQL actions or the like, you'll
probably have to write your own action to do the conversion.  Otherwise,
consider using XSP+ESQL or XSP+SQL Transformer.  However you cut it, it
looks like you'll have to write some Java code.

-Christopher



|---------+---------------------------->
|         |           "Carlos Dias"    |
|         |           <[EMAIL PROTECTED]>|
|         |                            |
|         |           04/13/2004 02:26 |
|         |           PM               |
|         |           Please respond to|
|         |           users            |
|         |                            |
|---------+---------------------------->
  
>--------------------------------------------------------------------------------------------------------------|
  |                                                                                    
                          |
  |       To:       <[EMAIL PROTECTED]>                                                
                    |
  |       cc:                                                                          
                          |
  |       Subject:  Re: Sql type for request parameter with multiple values            
                          |
  
>--------------------------------------------------------------------------------------------------------------|




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]





---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]