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
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
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>
Copy link to clipboard
Copied
Thanks for the reply haxtbh,
I have tried the your suggestion with out success.
Also, #Employee1.Employee-ID#,
#"Employee"#.#"Employee-ID"#,
#Employee#.#Employee-ID# and others.
Please let me know if you have any additional suggestions.
Thanks,
TJ
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.
Copy link to clipboard
Copied
Thanks for the reply haxtbh,
I have tried the your suggestion with out success.
<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
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
Copy link to clipboard
Copied
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.