Hey Listers,
I'm not positive what I'm trying to do is even possible, but
here's what I'm working on. I'm doing an import of users from source X.
Problem is X isn't completely reliable and some records are missing $Login$,
also I want all logins to be lowercase if they do exist. I'm setting
missing logins to "No Login" so I can fire notifications. Here is my
mapping statement.
STMT|IF $Login$ is NULL THEN
VALUE = "No Login"
ELSE
VALUE = function|lower($Login$)
ENDIF
What I end up with if they have a login is
function|lower(
The AIE docs state that literals must be in double quotes, and I have other
mappings that resolve VALUE = $field$, so I assumed using the function would
be good. Is it possible to use functions within IF statements? Is there
some escape character that I'm missing?
ARS 7.1 patch 2
AIE 7.1 patch 2
Windows Server 2003
SQL Server 2005
Thanks!
Brian
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
