I made a few postings about having issues using the IF and SQL statements in field mappings within AIE. Although I appeared to be using valid syntax in my class mappings, AIE would not process those statements. No errors were shown in the logs. After a bunch of emails back and forth with BMC I was able to figure out the issue and felt it was worth posting to the list.
These type of statements must contain spaces between all fields\variables. A statement such as: STMT|IF $Index0$="0" THEN VALUE="1000" ELSE VALUE="5000" ENDIF will not work but the following will: STMT|IF $Index0$ = "0" THEN VALUE = "1000" ELSE VALUE = "5000" ENDIF The same with an SQL statement: sql|select <column> from <table> where <column>=$column$ will not work but: sql|select <column> from <table> where <column> = $column$ does work. Frank _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
