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,
Steven

This message has been edited. Last edited by: Kerry,

I found the solution.

Thanks,
Steven

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!

The proper syntax to concatenate a full name is like this:

FULL_NAME/A45=SPRIDEN_LAST_NAME ||(', ' | SPRIDEN_FIRST_NAME) ||(' ' | EDIT(SPRIDEN_MI,'9$$$$$$$$$'));

Steven