macromedia.coldfusion.advanced_techniques
[Top] [All Lists]

Re: Letters above names in output

Subject: Re: Letters above names in output
From: "projectproofing"
Date: Mon, 18 Feb 2008 16:56:24 +0000 UTC
Newsgroups: macromedia.coldfusion.advanced_techniques

Here is my Query (Oracle).

 I have no place to grab a single letter.

         SELECT DISTINCT
                        ind.individual_id,
                        mail_name,
                        first_name,
                        middle_name,
                        last_name,
                        name_suffix,
                        degrees,
                        clinical_specialty service_name,
                        <!---prov.planning_specialty service_name,--->
                        facdept.um_department,
                        fellow_name_flag
          FROM  MS.INDIVIDUAL ind,
                        MS.provider prov,
                        pcd.clinical_faculty clinfac,
                        pcd.view_guide_faculty_department facdept
         where  ind.individual_id = prov.individual_id
                        AND ind.individual_id = clinfac.individual_id
                        AND clinfac.individual_id = facdept.individual_id
                        AND show_on_pcd_flag = 'YES'
                        AND facdept.um_department='#searchphys_department#' 
                        AND clinical_specialty is not null
        UNION
         SELECT DISTINCT
                        ind.individual_id,
                        mail_name,
                        first_name,
                        middle_name,
                        last_name,
                        name_suffix,
                        degrees,
                        prov.planning_specialty service_name,
                        <!---prov.planning_specialty service_name,--->
                        facdept.um_department,
                        fellow_name_flag
          FROM  MS.INDIVIDUAL ind,
                        MS.provider prov,
                        pcd.clinical_faculty clinfac,
                        pcd.view_guide_faculty_department facdept
         where  ind.individual_id = prov.individual_id
                        AND ind.individual_id = clinfac.individual_id
                        AND clinfac.individual_id = facdept.individual_id
                        AND show_on_pcd_flag = 'YES'
                        AND facdept.um_department='#searchphys_department#' 
                        AND clinical_specialty is null


<Prev in Thread] Current Thread [Next in Thread>