Skip to main content
tej_web
tej_web
Inspiring
May 6, 2015 8:11 PM UTC
Answered

Progress Open Edge cfoutput.

Hello,

I have successfully connected and queried a Progress Open Edge database 10.2B and have dumped the data using <cfdump>.  I have tried to use <cfoutput query> with out success.

Please see below,

<cfquery name="list" datasource="progress1>

SELECT "Employee"."Employee-ID","Employee"."Employee-Name"

FROM   "sams"."BUB"."Employee"

Where "Employee"."Record-Active"='1'


ORDER BY  "Employee"."Employee-Name"

</cfquery>

<CFDUMP  query="list">                        / Displays all of the fields from the select above.

When I try using    <cfoutput>    #"Employee"."Employee-ID"# </cfoutput>

I receive errors. I have tried with " and ' and with only # and many others.

Please advise if some one knows and has successfully displayed this data using <cfoutput>

Thanks,

TJ

    This topic is closed to new replies. Start a new post to keep the conversation going.
    tej_web
    tej_webCorrect answer
    Inspiring
    May 7, 2015 1:16 PM UTC

    Thanks for the reply haxtbh,

    I have tried the your suggestion with out success.

    1. <cfoutput query="list"> 
    2.          #Employee-ID#
    3. </cfoutput>

                                

    <cfoutput>

                  #Employee-ID#

                  #Employee1.Employee-ID#

                    #list.employee#

                ect...

    </cfoutput>

    Also, #Employee.Employee-ID#,

    #"Employee"#.#"Employee-ID"#,

    #Employee#.#Employee-ID# and others.

    The most common error message is " Element EMPLOYEE is Undefined in list"


    Please let me know if you have any additional suggestions.

    Thanks,

    TJ


    Hi haxtbh,

    Just got it!

    Assign an allises to "Employee1"."Employee-Name" as EMPN

    Output the field as    <cfoutput>#list.EMPN#</cfoutput>

    Thanks for the reply.

    TJ

    View reply

    6 replies

    haxtbh
    Inspiring
    May 7, 2015 7:59 AM UTC

    You need to tell the cfoutput what query you are trying to use and then reference them inside it,. So it would look something like this:

    <cfoutput query="list">
    

        #Employee-ID#
    

    </cfoutput>
    Translate
    tej_web
    tej_webAuthor
    Inspiring
    May 7, 2015 12:45 PM UTC

    Thanks for the reply haxtbh,

    I have tried the your suggestion with out success.

    1. <cfoutput query="list"> 
    2.     #Employee-ID# 
    3. </cfoutput>

    Also, #Employee1.Employee-ID#,

    #"Employee"#.#"Employee-ID"#,

    #Employee#.#Employee-ID# and others.

    Please let me know if you have any additional suggestions.

    Thanks,

    TJ

    Translate
    haxtbh
    Inspiring
    May 7, 2015 12:51 PM UTC

    What happens when you try? What error are you getting? Cant really help any more without knowing what the error is.

    Translate
    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices