Skip to main content
tej_web
tej_web
Inspiring
May 6, 2015
Answered

Progress Open Edge cfoutput.

  • May 6, 2015
  • 1 reply
  • 557 views

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 has been closed for replies.
    Correct answer tej_web

    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

    1 reply

    H
    haxtbh
    Inspiring
    May 7, 2015

    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>
    tej_web
    tej_webAuthor
    Inspiring
    May 7, 2015

    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

    H
    haxtbh
    Inspiring
    May 7, 2015

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

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