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

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.