This looks right to me too. Just to test - try a simple set field and specific in your qualification a record you know has a login - VALUE = function|lower($Login$). Does that work? If yes, try this next. (If not, file a support ticket ;) ) Next - Try modifying the qualification query to $Login$ NOT Null and VALUE = function|lower($Login$). Still work? If yes, try this next. (If not, file a support ticket) Now try building the statement gain, going with what you know. STMT|IF $Login$ NOT NULL THEN VALUE = function|lower($Login$) ELSE VALUE = "No Login" ENDIF
Hopefully, somewhere along the line you figure out what it doesn't like. If not, it should definately go to support because some directions aren't clear or you found a bug. Do let us know what you find. --------------------- Kelly Deaver [EMAIL PROTECTED] > -------- Original Message -------- > Subject: AIE Escape Character? > From: Brian Gillock <[EMAIL PROTECTED]> > Date: Wed, June 11, 2008 11:41 am > To: arslist@ARSLIST.ORG > > 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" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"