Re: .NET Data Newbie question

["Peter Dow (ML)" <maillist@xxxxxxxxxxxxxxx>]

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......
>