[SOLVED] Populate Listbox with HTML Painter and SungardHe Banner
Hello,
I am trying to write a .fex to populate a listbox in HTML. I want to bring back only the faculty name with pidm in table sirasgn. The return full name should look something like this - Adams, Robert T. The spaces between name do not work either. Below is my code but it takes forever to return and it does not work right. Can someone help me with a sample code?
SET HOLDLIST = PRINTONLY JOIN SIRASGN.SIRASGN.SIRASGN_PIDM IN SIRASGN TO MULTIPLE SPRIDEN.SPRIDEN.SPRIDEN_PIDM IN SPRIDEN AS J0 END DEFINE FILE SIRASGN FULL_NAME/A45=SPRIDEN_LAST_NAME ||',&|nbsp' || SPRIDEN_FIRST_NAME ||'&|nbsp' || EDIT(SPRIDEN_MI,'9$$$$$$$$$'); END TABLE FILE SIRASGN PRINT 'SPRIDEN.SPRIDEN.SPRIDEN_LAST_NAME' 'SPRIDEN.SPRIDEN.SPRIDEN_FIRST_NAME' 'SPRIDEN.SPRIDEN.SPRIDEN_MI' COMPUTE FULL_NAME/A45 = SPRIDEN.SPRIDEN.SPRIDEN_LAST_NAME||',&|nbsp' ||SPRIDEN.SPRIDEN.SPRIDEN_FIRST_NAME||'&|nbsp' ||SPRIDEN.SPRIDEN.SPRIDEN_MI; BY 'FULL_NAME' NOPRINT BY 'FULL_NAME' NOPRINT WHERE SPRIDEN_CHANGE_IND EQ MISSING; WHERE SPRIDEN_ENTITY_IND EQ 'P'; ON TABLE NOTOTAL ON TABLE PCHOLD FORMAT XML END
In TOAD, I can do it fine like this: select distinct spriden_last_name || ', ' ||spriden_first_name || ' ' || substr(spriden_mi, 1,1) as "NAME" from sirasgn, spriden where sirasgn_pidm = spriden_pidm and spriden_change_ind is null order by spriden_last_name || ', ' ||spriden_first_name || ' ' || substr(spriden_mi, 1,1)
Thanks so much, StevenThis message has been edited. Last edited by: Kerry,
7.6.4 OS is Windows HTML, Excel, and PDF
May 12, 2009, 05:43 PM
kingfish1
I found the solution.
Thanks, Steven
7.6.4 OS is Windows HTML, Excel, and PDF
May 12, 2009, 07:12 PM
Darin Lee
Glad you solved the problem. When you get a minute, kindly post your solution to help someone who might run into a similar problem in the future. Thanks!
Regards,
Darin
In FOCUS since 1991 WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex WF Client: 77 on Linux w/Tomcat
May 14, 2009, 05:06 PM
kingfish1
The proper syntax to concatenate a full name is like this: