Re: .NET Data Newbie question

["Mark Allen" <scprideandms@xxxxxxxxx>]

PERFECT!!!!

On 5/16/07, Peter Dow (ML) <maillist@xxxxxxxxxxxxxxx> wrote:
> Hi Mark,
>
> This one
>
> %IF (V_RSGNAA >= "1021001" && V_RSGJAA = "PHD")
>        INTERDISCIPLINARY STUDIES
> %ENDIF
>
>
> looks right except for the single =.  In a condition test, you should
> use double =, i.e.== or
>
> %IF (V_RSGNAA >= "1021001" && V_RSGJAA == "PHD")
>        INTERDISCIPLINARY STUDIES
> %ENDIF
>
> hth,
>
> *Peter Dow* /
> Dow Software Services, Inc.
> 909 793-9050
> pdow@xxxxxxxxxxxxxxx <mailto:pdow@xxxxxxxxxxxxxxx> /
>
> Mark Allen wrote:
> > I inherited this from our previous "web" guy, so I get to maintain/fix
> > this stuff until we get a replacement.  The code that is currently
> > executing that I need to add to is:
> >
> >                                %IF (V_Degree != "")
> >                                         - $(V_Degree)&nbsp;
> >                                         %IF (V_RSGNAA >= "1021001")
> >                                                IN INTERDISCIPLINARY STUDIES
> >                                         %ENDIF
> >                                %ENDIF
> >
> > What I need to do is have an AND condition so that the  IN
> > INTERDISCIPLINARY STUDIES piece is only appened if the field V_RSGJAA
> > = "PHD" (I know hard coded junk but....).  From what the previous guy
> > told me the V_ means the field comes from a file and the RSGNAA and
> > the RSGJAA fields are from the same data file and are both in the SQL
> > select statements retrieveng data from the file.
> >
> > I have tried every combo I can think of and searched all other macros,
> > IBM info center for .net Data and cannot get it to work.
> >
> > Things I tried (some of them that I can remember right now are lsited
> > below) either gave me a script error or tacked on the V_RSGJAA = "PHD"
> > into the V_Degree and the  IN INTERDISCIPLINARY STUDIES
> >
> > %IF (V_RSGNAA >= "1021001") && (V_RSGJAA = "PHD")
> >        INTERDISCIPLINARY STUDIES
> > %ENDIF
> >
> > %IF (V_RSGNAA >= "1021001" && V_RSGJAA = "PHD")
> >        INTERDISCIPLINARY STUDIES
> > %ENDIF
> >
> > tried AND instead of && for both, and at least 3 other variations
> >
> > Hope this makes sense......
> >
> --
> This is the Web Enabling the AS400 / iSeries (WEB400) mailing list
> To post a message email: WEB400@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/web400
> or email: WEB400-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/web400.