Stack Overflow
Stack Overflow

Questions tagged [cfoutput]

Displays output that can contain the results of processing ColdFusion variables and functions. Can loop over the results of a database query.

33 questions
8
votes
2 answers

How to Break out of Cfoutput

I am looping through the results of a query, and I need to limit the number of rows displayed. I need to use cfoutput because I'm using the group attribute, and I cannot use the maxrows because not all rows will be displayed. I tried to use…
Yisroel
  • 8,164
  • 4
  • 26
  • 26
4
votes
5 answers

How to find the nested cfoutput recordcount when using group

Consider the following:

#type#

#name# resources.recordcount would give me the total number of records, but is there an elegant way of…
Neokoenig
  • 1,102
  • 7
  • 16
3
votes
2 answers

Excess Characters Being Generated by ColdFusion Query/output

I've got a strange issue with some Coldfusion/SQL Query output. The actual data is generating properly, but at the bottom of the page it's outputting "Library/Library/Library/Library/Library/Library/Library/Library" for no reason I can discern. It…
EepMoody
  • 124
  • 10
3
votes
3 answers

Coldfusion dynamic query output

Not sure if this is possible or not. What I am trying to do is build an output string via queries. I am concatenating the output "name" and appending the "value" to the end. Then outputting the string. I don't think this is possible. But I am…
jeeperscreepers
  • 143
  • 5
  • 16
2
votes
1 answer

display the query result

I am new to coldfusion and I am stuck with looping a query within a function. For example, I have a function within which has a query which returns the names which starts with 'a'. but i am able to get only one value (first value) from the…
user1049057
  • 459
  • 4
  • 15
  • 36
2
votes
2 answers

With Many-To-Many Relationship

I am working on a project for our accounting department. I have a database (MySQL) table with ledger codes. Our company has a few different office locations, and each of these codes can apply to one or more office location. Each office location…
Michael Buckman
  • 140
  • 9
2
votes
0 answers

ColdFusion cffeed/cfoutput

I'm currently using a combination of cffeed and cfoutput to generate an XLM/RSS feed, but am getting some curious output, which manifest differently with different browser settings(I think). The ColdFusion code that produces the XML is
Phil S
  • 123
  • 8
2
votes
2 answers

How can I cfoutput a JavaScript String?

I'm building a JSON string within script Tags in a cfm file. I would like to find a way to get this JSON string into a cfoutput so that the page can display the JSON. I'm currently just document.write()ing the json which retrieves the JSON in the…
Karim Shoorbajee
  • 99
  • 2
  • 9
2
votes
1 answer

ColdFusion cfdump / cfoutput doesn't match query analyser results

I have created a query which displays different data when being executed in Microsoft SQL Server Management Studio express than it does when outputting in a browser either using cfdump or cfoutput. Here is the query: select count(stat_id) as val,…
weekev126
  • 23
  • 2
2
votes
1 answer

Why can I reference RecordCount on a query embedded in an object but I can't loop over it?

I have a model, surveyTemplate, that has all but one of it's properties populated by a query. I am storing an additional query in the last property of the model which is called, surveyTemplateQuestions. If I do the…
Caleb Palmquist
  • 448
  • 2
  • 7
  • 15
2
votes
1 answer

How can I access the query for my cfoutput dynamically, based on a query name variable?

I have a struct that contains 2 queries. I have a variable with the "key" of one of the queries, and I want to output the query dynamically using that variable. My basic code: ...
froadie
  • 79,995
  • 75
  • 166
  • 235
2
votes
1 answer

ColdFusion 9 CFCHART CFCHARTSERIES Issue

I'm displaying a chart with one or more line series. The data comes from a query and works correctly if there is more than on series on the chart. However, if only one series is returned it is not displaying correctly. Here's the code…
Brad
  • 1,684
  • 4
  • 20
  • 36
2
votes
1 answer

How to output table results by using cfoutput group by date?

I have a query that get the all the employees count in a table: emp_namelast | emp_namefirst | employeetotal | year_cse1 -------------------------------------------------------- smith | john | 13 | 2014 smith jr |…
user3591637
  • 499
  • 5
  • 20
2
votes
4 answers

ColdFusion - approach for table of query data and CRUD actions

My question is more geared towards approach than it is programming or errors. I have a query that runs and gathers a set of data. I then want to use that query's return values to build a table on a page listing all the values. Along with that I…
bcar
  • 815
  • 9
  • 19
1
vote
2 answers

group inside sql code rather than in cfoutput

I have a sql-server code of cities as rows and months as columns, there are sums by months but there are no sum by the city_id, I mean I have to count all the sum by city inside the output, and group it by city_id, anyway here is the sql…
user745110
  • 119
  • 2
  • 11
1
2 3