Thanks for the post Frank. I do quick a bit of this and have had some head scratch moments!!
-----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Frank Caruso Sent: 13 August 2009 07:11 To: [email protected] Subject: SQL and IF Statements in AIE 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" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
