Or, if you don't need to loop the output for any other reason, just do this
once, without using CFOUTPUT at all:
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http:/
Thanks Guys!
worked like a charm!
On Fri, Feb 27, 2009 at 12:18 PM, morgan l wrote:
>
> You're restarting the variable by setting it inside the output group. Try:
>
>
>
>
>
>
>
> On Fri, Feb 27, 2009 at 11:10 AM, Paul Ihrig wrote:
>
> >
> >
> >
> >
> >
> >
>
>
>
~
You're restarting the variable by setting it inside the output group. Try:
On Fri, Feb 27, 2009 at 11:10 AM, Paul Ihrig wrote:
>
>
>
>
>
>
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic releas
returns:
myList: 6,
myListX: 6,,6
#n1Id#,
returns:
1,7,2,6,
which is what i want, but as a carible i can call outside of the output.
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
G
Adrian
> -Original Message-
> From: Paul Ihrig [mailto:pih...@gmail.com]
> Sent: 27 February 2009 16:58
> To: cf-talk
> Subject: setting a var from Inside cfoutput group
>
>
> #n1Id#,
>
> i need to set a variable as a list from the results above.
> i
#n1Id#,
i need to set a variable as a list from the results above.
i tried putting a cfset inside the cfoutput, but it didn't work.
some thing like
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release
You could just alter your query slightly and let SQL do the counting for you.
-Original Message-
From: Toby King [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 08, 2007 2:22 PM
To: CF-Talk
Subject: cfoutput group with totals
#authorName#
#bookTitle#
Hi there
I understand
yes - put the code in the proper place - the outer cfoutput - like in
Janet's example
--
Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com
~|
Get involved in the latest ColdFusion discussions, product
development sharing, a
#authorName#
#bookTitle#
You put the output you want between the two closing tags. Output
there will appear once per group after the group details. Just as the
tag is being output once per group. This is the same as the content put
between the two opening tags that appears once pe
Hi Toby -
Have you tried:
#authorName#
#bookTitle#
#getAuthorsAndBooks.RecordCount#
~|
ColdFusion 8 - Build next generation apps
today, with easy PDF and Ajax features - download now
http://download.macromedia.com/p
> IS there anyway of controlling this to
> limit it to display just once.
Yes. Move the totals _outside_ the inner tags. See my
previous example. Otherwise, #total# will output multiple times.
#authorName#
#Books#
#total#
~
Well I have basically got the same.
The problem I'm having can be shown below:
Harry Potter
1292BB85 $65 Cash
135CC94A $65 Cash
Totals $130.00$130.00
Ben Forta
1292BB85 $65 Cash
135CC94A $65 Cash
135CC96B $65 Cash
Totals $195.00$195.00$1
Well I had done this
But the problem I have is that I am getting output like this
IDTime Amount
Erin
1292BB85-06-11-07 12:29 PM 65
135CC94A-06-11-07 04:14 PM 65
Totals$130.00 $130.00
Erin
> Hoe do you include a count after the books and before the next author
> name.
Do you mean something like this?
#authorName#
#bookTitle#
total books for this author (#bookCount#)
~~~
#authorName#
#bookTitle#
Hi there
I understand the piece of code well â so thatâs cool â just want to try
and enhance the code a fraction.
I want to try and place after the list of books for each author a count of the
number of books.
I tried this but instead of getting the count
Problem has been fixed.
Thanks
-Original Message-
From: Pete [mailto:[EMAIL PROTECTED]
Sent: Saturday, 9 December 2006 8:29 PM
To: CF-Talk
Subject: cfoutput group
Hi All
I am outputting information OK but I would like to improve the way the
information is presented to the user
Hi All
I am outputting information OK but I would like to improve the way the
information is presented to the user.
Hence I would like to group the output. Its sort of working but not the way
I want it to and I cant seem to get the information exactly how I want it.
Heres my code:
Will Tomlinson [mailto:[EMAIL PROTECTED]
Sent: 05 January 2005 01:46
To: CF-Talk
Subject: Re: SQL group by instead of cfoutput group?
>Just add 'DISTINCT' after 'SELECT' and SQL Server will automatically
>ensure that you don't have any duplicate rows in you
lol!
actually it woulda been nice as i was in kentucky and the ice storm knocked out
power out for 3 days, so we huddled around the coal stove
-- Original Message --
From: S. Isaac Dealey <[EMAIL PROTECTED]>
Reply-To: cf-talk@houseoffusion.com
Date: Wed, 5
> tiz amazing and i will leave it at that as im trying to be
> good :) (i got coal in stockings this yr)
So Santa says to a kid "you should be good, you don't want to get coal
in your stocking" and the kid asks "what's coal?" and Santa says
"well... it's kind of a rock that burns"... and the kid s
hehe
i tried not to, i really did! but it just kept knawin at me haha
i think most ppl just get wrong impression from me, i dont say things to well
on here sometimes though (ok all the time)
but its all good
i even refrained from slappin up that big post from after ebay pulled all its
.net stu
>there isnt some whifty nifty whizbang thing from .net 4 that?
You are a trip dude!! I KNEW you were gonna post with somethin like this. I
KNEW it!!
Hell, I don't blame you though! Ya got me!
I don't have time to learn .net for this project. For me, CF is kinda like
sittin in front of a warm
there isnt some whifty nifty whizbang thing from .net 4 that?
-- Original Message --
From: Will Tomlinson <[EMAIL PROTECTED]>
Reply-To: cf-talk@houseoffusion.com
Date: Tue, 04 Jan 2005 21:46:11 -0400
>>Just add 'DISTINCT' after 'SELECT' and SQL Server will
What is the sql you have now?
-Original Message-
From: Will Tomlinson [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 04, 2005 8:46 PM
To: CF-Talk
Subject: Re: SQL group by instead of cfoutput group?
>Just add 'DISTINCT' after 'SELECT' and SQL Server will automat
>Just add 'DISTINCT' after 'SELECT' and SQL Server will automatically
>ensure that you don't have any duplicate rows in your result set. Oh,
>and go check out CFQUERYPARAM and use it. It'll save you lots of
>headaches.
I tried DISTINCT and it still returns duplicate prodmodelcodes. How can I wee
Just add 'DISTINCT' after 'SELECT' and SQL Server will automatically
ensure that you don't have any duplicate rows in your result set. Oh,
and go check out CFQUERYPARAM and use it. It'll save you lots of
headaches.
cheers,
barneyb
On Tue, 04 Jan 2005 21:04:20 -0400, Will Tomlinson <[EMAIL PROT
Hello,
I'm working with a clothing database. ProdID is the PK, then I have
prodmodelnumber, prodcategory, etc..etc..
Clothes with the same model number have different sizes and colors so there
will be quite a few duplicate model numbers in this table. I'm passing the
usual URL parameter for th
uery.
>
>
>
>
>
> do something
>
>
>
>
> Pascal
>
>
>>-Original Message-
>>From: Umer Farooq [mailto:[EMAIL PROTECTED]
>>Sent: 10 December 2004 02:54
>>To: CF-Talk
&
2004 02:54
> To: CF-Talk
> Subject: odd.. cfoutput group and cfloop over query
>
> Hi,
>
> I'm getting this odd.. problem.. when doing..
>
>
>
>
> SOMETHING
>
>
>
>
> in the loo
Hi,
I'm getting this odd.. problem.. when doing..
SOMETHING
in the loop QUERYONE.XID will keep the first row value.
if I remove the prefix from XID.. it gives me an error saying its
not defined. Which is odd by itself.
I
Thanks for all the tips! I had thought about using my own counter, but thought it wouldn't work with pagination tools like cf_recordcount. Of course, they can be work together! It's up and running like a charm now.
For what it's worth, here's how I integrated my homemade counter with the cf_record
#publication_title#
#author_name#
But the maxrows attribute goes by the query record count, rather than the
count of unique publication_titles. So instead of seeing 10 records per
page, I may get 6 or 9 or 7--the system is counting each author row and
thinks it's reached 10 before i
p 2004 14:52:45 -0400
Subject: cfoutput -- group and maxrows problem
To: CF-Talk <[EMAIL PROTECTED]>
Hi everyone,
I'm new to the list, but was driven to subscribe by a problem that's
been driving me mad for days.
I have three tables: publications, authors, and pub_author. I designed
i
> ...which gives me multiple rows for publications with more
> than one author. So Pub 1-Auth1, Pub1-Auth2, Pub2-Auth3,
> Pub3-Auth4 = 4 rows for 3 records. My output uses grouped
> nested cfoutputs for display, essentially like this:
>
> maxrows="10">
> #publication_title#
>
> #author
Hi everyone,
I'm new to the list, but was driven to subscribe by a problem that's been driving me mad for days.
I have three tables: publications, authors, and pub_author. I designed it this way b/c pubs can have multiple authors, and I wanted a controlled list of authors. They're joined like so:
When outputting a query with cfoutput group, and using a cfimported
custom tag inbetween, cfoutput does not output all the
records...only the grouped ones. I tested both cfmodule and a
shorthand custom tag under MX UD3 default JRE and they also exhibit
this behavior.
A CF5 custom tag
Tom, you're welcome. My pleasure to be of assistance.
~Dina
- Original Message -
From: Tom Forbes
To: CF-Talk
Sent: Tuesday, December 10, 2002 1:41 PM
Subject: Re: CFOUTPUT group by & recordcount HELP
Dear Dina Hess,
Thank you very much for taking the time thi
>
>
>
>
>
> #num_cat_recs#
>
>
>
>
>#DomainName#
>
>
>
> - Original Message -
> From: Tom Forbes
> To: CF-Talk
> Sent: Monday, December 09, 2002 9:28 PM
> Subject: CFOUTPUT group by & recordcount HE
DomainName#
- Original Message -
From: Tom Forbes
To: CF-Talk
Sent: Monday, December 09, 2002 9:28 PM
Subject: CFOUTPUT group by & recordcount HELP
I have checked my books and the CF achieve, but need a little help in the
right direction, please.
I have a
I have checked my books and the CF achieve, but need a little help in the
right direction, please.
I have a db table that contains, among other things, Domain Names and about
20 Different Domain Name Categories. I want to Output the results of this
db table by GROUPING the Domain Name Categorie
I'm using cfoutput group="column" to show grouped output like this
Group
Item
Item
Item
Group
Item
Item
Item
I'm trying to show 10 items per page. Using grou
Here is a tag that alows you to use "group output" AND MaxRows. This time I
will get the credits right.
Bud Schneehagen - Tropical Web Creations put this link up for us.
http://www.twcreations.com/recordcount/
> Hi,
>
> I have question regarding cfouput group. If I use this code :
>
>
>
>
Hi,
I have question regarding cfouput group. If I use this code :
I got max 10 records to the screen... no problem for this...
-
-
But If I use this code :
bla bla bla...
I got all
If you need to get the count within a group before you
output, how about using ValueList or QuotedValueList
on the column you need to group by and then using
ListValueCount or ListValueCountNoCase as appropriate
to find the number of instances within that group?
For example:
#qGetItems.Cate
> What if you need to display the count _above_ the enumerated items?
>
>
> #xx.category# (#count# items)
>
>
>
>
You have a couple of options. You could bring back the count in your SQL
query, by using COUNT and GROUPing BY the field that you're ORDERing BY now.
Or, you could u
o do it without making two passes through the
query, one to get cts, second time to display but that is ugly.
- Original Message -
From: "Jim McAtee" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Saturday, August 18, 2001 6:17 PM
Subject: Re: cfout
What if you need to display the count _above_ the enumerated items?
#xx.category# (#count# items)
-Original Message-
From: Don Vawter <[EMAIL PROTECTED]>
To: CF-Talk <[EMAIL PROTECTED]>
Date: Saturday, August 18, 2001 2:41 PM
Subject: Re: cfoutput group c
gt;
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Saturday, August 18, 2001 1:43 PM
Subject: cfoutput group count
> I know this is easy, but I need sleep. How can I easily get the number
of
> records returned per grouping in a cfoutput query?
>
> Eric J Hoffman
>
You could add a COUNT() to your query...
Once you add a "Scalar/Aggregate" function to your SQL you will need to
specify al the fields in the GROUP BY though.
SELECT
table1.field1,
table2.field1,
COUNT(table2.field1) AS CountField1
FROM
table1 INNER JOIN table2 ON table1.ID=table2.Foreign
I know this is easy, but I need sleep. How can I easily get the number of
records returned per grouping in a cfoutput query?
Eric J Hoffman
Small Dog Design, LLC
www.smalldogdesign.com
~~
Structure your ColdFusion code with Fusebox. Get the offi
Paul Smith [mailto:[EMAIL PROTECTED]]
>Sent: May 7, 2001 17:01
>To: CF-Talk
>Subject: CFOUTPUT & GROUP
>
>
>Hello!
>
>Is there a good tutorial somewhere on the Subject?
>
>I need to group more than one level down and the subject of grouping always
>hurts my head ;-)
.
Stuff every time new value in field3.
-Original Message-
From: Paul Smith [mailto:[EMAIL PROTECTED]]
Sent: May 7, 2001 17:01
To: CF-Talk
Subject: CFOUTPUT & GROUP
Hello!
Is there a good tutorial somewhere on the Subject?
I need to group more than one level down
Hello!
Is there a good tutorial somewhere on the Subject?
I need to group more than one level down and the subject of grouping always
hurts my head ;-)
Project Category 1
Project Type 1
Project 1
Project 2
etc
Project Type 2
Project 89
ges to display once, showing the most recent message and subject.
Hopefully this helps to clarify. Thanks in advance!
Greg Albert
> -Original Message-
> From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, August 07, 2000 11:34 AM
> To: [EMAIL PROTECTED]
> Cc
> I am trying to group all messages together with the same subject
> for a forum.
>
> When I do that, I have to use
> (where "Subject" is the field name).
>
> Here's the problem. I need the messages to be sorted by current
> date/time first and then by subject. Is there a way to use the
> ORDER B
I am trying to group all messages together with the same subject for a
forum.
When I do that, I have to use (where "Subject" is
the field name).
Here's the problem. I need the messages to be sorted by current date/time
first and then by subject. Is there a way to use the ORDER BY clause in SQL
56 matches
Mail list logo
