• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit
0

Progress Open Edge cfoutput.

Explorer ,
May 06, 2015 May 06, 2015

Copy link to clipboard

Copied

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

Views

312

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines

correct answers 1 Correct answer

Explorer , May 07, 2015 May 07, 2015

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

Votes

Translate

Translate
Advocate ,
May 07, 2015 May 07, 2015

Copy link to clipboard

Copied

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>

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Explorer ,
May 07, 2015 May 07, 2015

Copy link to clipboard

Copied

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

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Advocate ,
May 07, 2015 May 07, 2015

Copy link to clipboard

Copied

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

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Explorer ,
May 07, 2015 May 07, 2015

Copy link to clipboard

Copied

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

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Explorer ,
May 07, 2015 May 07, 2015

Copy link to clipboard

Copied

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

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Advocate ,
May 07, 2015 May 07, 2015

Copy link to clipboard

Copied

LATEST

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.

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Resources
Documentation