Re: Conditional selects

Chris
Many thanks to you and others for the info on the use of [ ] to pass in
strings to a where clause - including the where and from.
I find that your suggestion woks fine for string formats using null and not
null operators:
        let $thisWhere = 'where fieldName is null'
        let $competeNullStr='tableX where fieldY is null'
        let $competeNotNullStr='tableX where fieldY is not null'

or a set of composites strings with at least on trailing space:
        let $tableName    =    'tableX '
        let $theWhere     =     'where '
        let $FieldName   =    'fieldY '
        let $operatorIs    =    'is '
        let $condition    =     'null'
...
so in the select statement these strings and compost string would be::
    from tableNameX [$thisWhere]
    from [$completeNullStr]
    from [completeNotNullStr]
    from [$tableName][$theWhere ][$fieldName][$operator][$condition]

****************************************************************
However, so far I have been unable to do the same using the operator =
    Substituting:
    let $value                =     'whatever'
    let $operatorEqual =     '= '
    let $equalWhere      =    'where fieldName = '
    $completeEqualStr =    'tableX where fieldY = ' | | $value

so in the select statement these strings and composite strings would be:
    from tableName [$equalWhere] [$value]
    from [$tablename] [$theWhere] [$operatorEqual] [$value]
    from [$completeEqualStr]

I have tried all sort of combination but seem to be unable to do the same
for the equal operator.
Am I missing something?

Although there is no problem passing variables to and equal operator that
is not what I need...
    I need to pass in both equal and null operators to the same where
clause.

Is the facility to pass in the equal operator as a string dependent on the
version of SQL?
    The version given by About:

            Which is all very odd - Any comments?

Any further suggestions would be most welcome...

Thanks.

Andrew
*******

----- Original Message -----
From: Wanko, Christopher G, CFCTR <apollo@ATT.COM>
To: <SQR-USERS@list.iex.net>
Sent: Wednesday, May 31, 2000 1:47 PM
Subject: Re: Conditional selects

> I hate Outlook.
>
> > let $selectedValue = 'valueSelected'
> > begin-select
> > field1
> > field2
> > field3
> > from tablename
> > where     field2 is null
> >           field2 = $selectedValue
> > end-select
>
> Try:
> if isnull($selectedValue)
>         let $thiswhere = 'and field2 is NULL'
> else
>         let $thiswhere = 'and field2 = ' || $selectedValue
> end-if
>
> Then:
> begin-select
> field1
> field2
> field3
> from tablethingie
> where something equals someThing
> [$thiswhere]
> and something else equals anotherThing
> order by 1,3,2
>
> -Chris