Re: WebDB: multiple select?

Well, I found one way to support both single and multiple parameter values in a WebDB SQL-based report: in the SQL use "in" in the where clause.

Jlewis_at_spamstop.org wrote:

>When a WebDB report is created using the "Query Wizard", the resulting
>parameter screen includes a field for selecting the operator( =, >,
>in, not in, etc) to be used with the parameter value(s) specified.
>This makes it possible to use a "multiple select" widget to show and
>allow the specification of multiple values for a given parameter. In
>such a case, the operator "in" can be selected so the multiple
>parameter values can be included in the resulting SQL statement.
 

>But, how can this be done when the report is created not with the
>"Query Wizard", but based on an SQL statement that is directly
>composed and typed in? The parameter screen that results from this
>manner of building a report does not include the field for selecting
>the operator (such as "in") that would be needed to support multiple
>values for a given parameter -- even though you can still have a
>"multiple select" widget to display and allow the selection of
>multiple parameter values.
 

>Anyone know how an SQL-Based report can make use of multiple values
>for a given parameter?
    Received on Thu Jun 01 2000 - 00:00:00 CEST