7 Replies Latest reply on May 7, 2015 7:08 AM by haxtbh

    Progress Open Edge cfoutput.

    tej_web Level 1

      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

        • 1. Re: Progress Open Edge cfoutput.
          haxtbh Level 4

          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>
          
          • 2. Re: Progress Open Edge cfoutput.
            tej_web Level 1

            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

            • 3. Re: Progress Open Edge cfoutput.
              haxtbh Level 4

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

              • 4. Re: Progress Open Edge cfoutput.
                tej_web Level 1

                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

                • 5. Re: Progress Open Edge cfoutput.
                  tej_web Level 1

                  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

                  • 6. Re: Progress Open Edge cfoutput.
                    haxtbh Level 4

                    Right. This is why we need the error. The dash in the field name is causing an issue in coldfusion it seems. Setting an alias without this will resolve it as you have discovered.