CFOUTPUT
Here's a unique one:
CF 5, Win2K Server
This code:
-
cfoutput
div id=headerChange Bond Order for
#client.ssmembername#/div
/cfoutput
-
Produces this error:
-
Attribute set validation error in tag CFOUTPUT
Hi all,
Here's a bit of a challenge. I have a single table storing category
information similar to any search engine. The table structure looks
like this
ID NameParentIDLevel
1 Computers 0 1
2 Laptop 1 2
3
look at the group attribute of cfoutput.
Should do what you want.
HTH,
Sam
- Original Message -
From: Dowdell, Jason G [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, October 15, 2002 2:30 PM
Subject: group by in cfoutput
Hi all,
Here's a bit of a challenge. I
It does a portion of what I want. I need to restrict
the output of the group by to a max of 3 records per
parent category.
~jason
-Original Message-
From: Sam Farmer [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 15, 2002 3:11 PM
To: CF-Talk
Subject: Re: group by in cfoutput
look
Can you put maxrows=3 in the innermost CFOUTPUT?
-Original Message-
From: Dowdell, Jason G [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 15, 2002 3:15 PM
To: CF-Talk
Subject: RE: group by in cfoutput
It does a portion of what I want. I need to restrict
the output
PROTECTED]]
Sent: Tuesday, October 15, 2002 3:15 PM
To: CF-Talk
Subject: RE: group by in cfoutput
It does a portion of what I want. I need to restrict
the output of the group by to a max of 3 records per
parent category.
~jason
-Original Message-
From: Sam Farmer [mailto:[EMAIL PROTECTED]]
Sent
That's the piece I'm working on now.
It won't allow you to do that since you must
specify a query in order to specify maxrows.
~Jason
-Original Message-
From: Everett, Al [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 15, 2002 3:17 PM
To: CF-Talk
Subject: RE: group by in cfoutput
, child.name
Then you should be able to use your cfoutput group on id and sub-cfoutput
group on childid and come up with the 3 sub's you want...
hth
S. Isaac Dealey
Certified Advanced ColdFusion 5 Developer
www.turnkey.to
954-776-0046
Even if you can, I suspect it's not a very efficient method.
Can you put maxrows=3 in the innermost CFOUTPUT?
-Original Message-
From: Dowdell, Jason G [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 15, 2002 3:15 PM
To: CF-Talk
Subject: RE: group by in cfoutput
It does
AND p.level = 1)
WHERE
(
SELECT Count(*)
FROM category
WHERE category.parentID = c.parentID
AND category.ID c.ID
) = 2;
cfoutput query= group=parentname
#parentname#
cfoutput
#childname#
/cfoutput
/cfoutput
Jochem
: embedding cfmail in a cfoutput -- thx
This is because the cfmail tag uses the cfoutput mechanism internally (
this is why it has the query= atrribute and I think a group=
That helps me explain why cfmail requires grouping if nested within
cfoutput. Basically because cfmail *is* a cfoutput (of sorts
I must be missing something very simple. I'm trying to embed a cfmail in a
cfoutput tag and am getting the following error msg.
// ERROR MSG
A CFMAIL tag is nested inside a CFOUTPUT tag that does not have a GROUP=
attribute. This is not allowed. Nesting these tags implies that you want to
use
in a cfoutput
I must be missing something very simple. I'm trying to embed a cfmail in a
cfoutput tag and am getting the following error msg.
// ERROR MSG
A CFMAIL tag is nested inside a CFOUTPUT tag that does not have a GROUP=
attribute. This is not allowed. Nesting these tags implies that you
Dave,
It really doesn't make any sense but it works. I'm sure as I work with it
more it will sink in. Thx.
ummm ... Is this because cfoutput query= loops through the table? ...
and this makes it stop at the first match?
// glm
-Original Message-
From: Dave Wilson [mailto:[EMAIL
This is because the cfmail tag uses the cfoutput mechanism internally (
this is why it has the query= atrribute and I think a group=
attribute... this is also why you don't need a cfoutput inside a cfmail
in order to output variables, because the folks at Allaire originally
assumed people would
Gilbert,
I'll try and explain a little more clearly.
Basically, yes you're right that the cfoutput query= behaves as a loop.
Looping through each record obtained from the specified query - in your case
users.
Now, sometimes when we are looping an output it becomes necessary to have
some kind
This is because the cfmail tag uses the cfoutput mechanism internally (
this is why it has the query= atrribute and I think a group=
That helps me explain why cfmail requires grouping if nested within
cfoutput. Basically because cfmail *is* a cfoutput (of sorts) and nesting
cfoutput tags
OK, this is so strange I almost don't want to write it.
This code doesn't work. The innermost cfoutput is not working as
expected. It is only showing the first Product. There are several
Products in each Category. If I change cfform to form, it works as
expected. I double checked by also
be worthwhile to look at another solution. Something about
using CFFORM inside of CFOUTPUT just gave us fits.
If you're interested I'll send you the validation routines and tag that
we wrote to get around cfform.
Joshua Miller
Web Development :: Programming
Eagle Web Development LLC
www.eaglewd.com
towards validation,
but it may be worthwhile to look at another solution. Something about
using CFFORM inside of CFOUTPUT just gave us fits.
If you're interested I'll send you the validation routines and tag that
we wrote to get around cfform.
Sure thing.
Man, I wish they'd try to think about
oh yeah, i had said that in the message :) way
too many, but heck, it was too late...
tw
-Original Message-
From: Sean A Corfield [mailto:[EMAIL PROTECTED]]
Sent: Sunday, August 18, 2002 12:52 AM
To: CF-Talk
Subject: Re: limit cfoutput
On Saturday, August 17, 2002, at 08:34 , Tony
Yiap [mailto:[EMAIL PROTECTED]]
Sent: Saturday, August 17, 2002 11:23 PM
To: CF-Talk
Subject: limit cfoutput
Does anyone know a way to limit the length of the output from cfoutput
tag? I have a data field from db that is that set to MEMO, obviously it's
more then 255 char. but I would like to only
Does anyone know a way to limit the length of the output from cfoutput
tag? I have a data field from db that is that set to MEMO, obviously it's
more then 255 char. but I would like to only display the first 255 char. and
add a read more... link to redirect it to a more descript page.
thanks
#Left('#MEMO#', 255)#
a href=theNextPage.cfmread more../a
tw
you can get jazzy with it after that
-Original Message-
From: Corey Yiap [mailto:[EMAIL PROTECTED]]
Sent: Saturday, August 17, 2002 11:23 PM
To: CF-Talk
Subject: limit cfoutput
Does anyone know a way to limit
(GetMemo.MemoCol)
CFELSE
CFSET Variables.CharCount=255
/CFIF
!--- Second, use the left function to output the leftmost (up to) 255
characters. ---
CFOUTPUT#Left(GetMemo.MemoCol,Variables.CharCount)#/CFOUTPUT
That should do the trick. Hope this helps.
Matthieu
-Original Message
cfif len(mymemofield) gt 250
cfset mymemo=left(mymemo,250)
/cfif
cfoutput#mymemo#/cfoutput
-Original Message-
From: Corey Yiap [mailto:[EMAIL PROTECTED]]
Sent: Saturday, August 17, 2002 11:23 PM
To: CF-Talk
Subject: limit cfoutput
Does anyone know a way to limit the length
then find the len() of that total output,
subtract 255 from it, and do a right, the difference
cfset getTheRest=#Len(#Memo#)# - 255
cfoutput
and now, The Rest of The Story (shout out to my man Paul
Hizzarvey)
#Right('#Memo#',#getTheRest#)#
/cfoutput
thats probably too
thanks guys
-Original Message-
From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 16, 2002 8:35 PM
To: CF-Talk
Subject: RE: limit cfoutput
cfif len(mymemofield) gt 250
cfset mymemo=left(mymemo,250)
/cfif
cfoutput#mymemo#/cfoutput
-Original Message
On Saturday, August 17, 2002, at 08:34 , Tony Weeg wrote:
cfset getTheRest=#Len(#Memo#)# - 255
cfoutput
and now, The Rest of The Story (shout out to my man Paul
Hizzarvey)
#Right('#Memo#',#getTheRest#)#
/cfoutput
That's a lot of #! Why not just:
cfset getTheRest
when i output a variable with the cfoutput tag and then view source of the
page cold fusion has added a bunch whitespace between the beginning of the
file and were the variable is. I have no whitespace in the cold fusion file
itself .
example:
beginning of the file
5658 variable
If your using CFMX, the new whitespace management option in the
administrator works like a gem.
Or you can use cfsetting enablecfoutputonly=yes to suppress any output
not within a cfoutput tag block. Don't forget to close this tag with
cfsetting enablecfoutputonly=no.
Brook
At 02:16 PM 16
Kurt:
Is the template under an Application.cfm? If so, that's where the
additional whitespace is coming from.
Charlie
- Original Message -
From: Kurt Knazek [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, August 16, 2002 11:16 AM
Subject: cfoutput adding whitespace
if you use array
notation as above.
-Andy
-Original Message-
From: William H. Bowen [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 23, 2002 2:30 PM
To: CF-Talk
Subject: Maximum value of column in cfoutput
Hello all,
I have a column [ lvl ] being returned in a query that is a Count
cfoutput?
Desired result:
A table that builds itself dynamically so the end result will look like this
td colspan=*max(lvl)* - lvl (here it'll be 0) 0 level header /td/tr
tdnbsp;,/td td colspan=*max(lvl)* - lvl (here it'll be 1) 1 level subhead
/td/tr
etc.
so far the data I need to display
]
Sent: Tuesday, July 23, 2002 11:29 AM
Subject: Maximum value of column in cfoutput
Hello all,
I have a column [ lvl ] being returned in a query that is a Count [
count(child.startbranch) AS lvl ]of another column. I need to be able to
find the MAX of the returned column so that I can write
PROTECTED]
http://www.esca.com/
425.739.3629 Voice
425.466.7016 Cell
425.739.3690 FAX
- Original Message -
From: Bryan Stevenson [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, July 23, 2002 11:52 AM
Subject: Re: Maximum value of column in cfoutput
I'm not sure I entirely
11:59 AM
Subject: Re: Maximum value of column in cfoutput
Unfortunately I don't need the data in that order, I just need the largest
value of lvl so that I can use that as the colspan value at the top row of
my table.
will
William H. Bowen
Webmaster
ALSTOM's TD Energy Automation
]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, July 23, 2002 11:59 AM
Subject: Re: Maximum value of column in cfoutput
Unfortunately I don't need the data in that order, I just need the largest
value of lvl so that I can use that as the colspan value at the top row of
my table
You can do it in CF after the query is back ...
cfset maxLvl = ArrayMax(ListToArray(ValueList(query.column)))
Dan
-Original Message-
From: William H. Bowen [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 23, 2002 11:59 AM
To: CF-Talk
Subject: Re: Maximum value of column in cfoutput
We are still on 4.5 ... why won't valuelist work in CF5?
-Original Message-
From: Bryan Stevenson [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 23, 2002 12:08 PM
To: CF-Talk
Subject: Re: Maximum value of column in cfoutput
and if you're not using CF 5...
cfset LevelList = ValueList
in cfoutput
and if you're not using CF 5...
cfset LevelList = ValueList(YourQuery.Lvl)
Then do some list manipulation to get the MAX item in the list
Bryan Stevenson B.Comm.
VP Director of E-Commerce Development
Electric Edge Systems Group Inc.
t. 250.920.8830
e. [EMAIL PROTECTED
Founder Director
www.cfug-vancouverisland.com
- Original Message -
From: Dan Haley [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, July 23, 2002 12:15 PM
Subject: RE: Maximum value of column in cfoutput
We are still on 4.5 ... why won't valuelist work in CF5
- Original Message -
From: Dan Haley [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, July 23, 2002 12:05 PM
Subject: RE: Maximum value of column in cfoutput
You can do it in CF after the query is back ...
cfset maxLvl = ArrayMax(ListToArray(ValueList(query.column)))
Dan
2000
Phil
Since the month would not be in a query column by itself I could not use it
as cfoutput's group column.
Ideally I would like some simple mechanism like:
cfoutput query=qryExampleDates group=Month(startDate)
I'm currently using CF5.
I am thinking of manipulating the query recordset
What DB are you using?
Tim
-Original Message-
From: Whiterod, David (PLNSA) [mailto:[EMAIL PROTECTED]]
Sent: Sunday, July 14, 2002 8:49 PM
To: CF-Talk
Subject: cfoutput and grouping
Hi,
What is the best way to group by months for a query that contains full (day,
month, year) dates
If you can'rt change the query, I would do exactly what you are
thinking, q of q with CreateDate(Year(startDate), Month(startDate), 1)
-Original Message-
From: Whiterod, David (PLNSA) [mailto:[EMAIL PROTECTED]]
Sent: Monday, 15 July 2002 12:49 p.m.
To: CF-Talk
Subject: cfoutput
PROTECTED]]
Sent: Monday, 15 July 2002 10:26 AM
To: CF-Talk
Subject: RE: cfoutput and grouping
What DB are you using?
Tim
-Original Message-
From: Whiterod, David (PLNSA) [mailto:[EMAIL PROTECTED]]
Sent: Sunday, July 14, 2002 8:49 PM
To: CF-Talk
Subject: cfoutput and grouping
Hi
it
as cfoutput's group column.
Ideally I would like some simple mechanism like:
cfoutput query=qryExampleDates group=Month(startDate)
I'm currently using CF5.
I am thinking of manipulating the query recordset (in CF) to add a new
column that just contains the month part of the date.
cheers
I have this code (actual custom tags removed to protect the innocent):
tdcfsetting enablecfoutputonly=Yes
cf_getsomeinfo id=2
cf_getsomeotherinfo id=#request.getsomeinfo.imageid#
cfoutputimg src=#request.getsomeotherinfo.imagesrc#/cfoutput
cf_getsomeinfo id=4
cf_getsomeotherinfo
The problem is not the cfoutput, but the return AFTER the cfoutput. I
agree this is a flaky implementation when suppression is turned on.
To make it look better for the customer, try this - remove the returns after
/cfoutput and before the next cfoutput like this:
tdcfsetting
I actually found a better way around it. I noticed that we had some images that
worked correctly on other pages. They were in their own table. So I just put
these inside another table and put the td and /td inside the cfoutput and
/cfoutput. It puts the space like this: /td td but we all know
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 group=column like
Name
Category
SubCategory
SubSubCategory
Name
Name
Name
etc...
Can I nest cfoutput groups like this?
cfoutput query=myQuery group=category
#category#
cfoutput query=myQuery group
Yes, you can nest grouped cfoutput's, not sure you need to query attribute
beyond the first cfoutput though?
MiKEY C!
-Original Message-
From: Carlisle, Eric [mailto:[EMAIL PROTECTED]]
Sent: 10 May 2002 13:43
To: CF-Talk
Subject: Can cfoutput group= be nested?
I have a query
Thank you :)
-Original Message-
From: Mike Connolly [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 10, 2002 8:44 AM
To: CF-Talk
Subject: RE: Can cfoutput group= be nested?
Yes, you can nest grouped cfoutput's, not sure you need to query attribute
beyond the first cfoutput though?
MiKEY
While on this topic, how about efficiency with cfoutput?
It makes sense to me that this:
select name=fred
cfloop query=fredQ
option
value=cfoutput#val#/cfouputcfoutput#valDesc#/cfouput
/cfloop
/select
is faster than this:
cfoutput
select name=fred
Shawn McKee wrote:
While on this topic, how about efficiency with cfoutput?
It makes sense to me that this:
select name=fred
cfloop query=fredQ
option
value=cfoutput#val#/cfouputcfoutput#valDesc#/cfouput
/cfloop
/select
is faster than this:
cfoutput
At 10:55 AM 4/15/2002 -0500, you wrote:
While on this topic, how about efficiency with cfoutput?
It makes sense to me that this:
select name=fred
cfloop query=fredQ
option
value=cfoutput#val#/cfouputcfoutput#valDesc#/cfouput
/cfloop
/select
is faster than
RecordSet contained 1000 results...
Using Cfoutput to loop through query: 50 ms
Using Cfloop contained with cfoutput tags: 50 ms
Using Cfloop with cfoutput tag contained within the cfloop tags: 170 ms
Matt
-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]]
Sent
: Venn, Matthew [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 15, 2002 11:20 AM
To: CF-Talk
Subject: RE: cfoutput - was RE: cfset vs using cfscript
RecordSet contained 1000 results...
Using Cfoutput to loop through query: 50 ms
Using Cfloop contained with cfoutput tags: 50 ms
Using Cfloop
At 11:46 AM 4/15/2002 -0500, you wrote:
My testing agrees with this. This flies in the face of what Chris Cortes
says in his book Optimizing ColdFusion 5. Page 404. Or am I reading it
wrong? Does anyone else have any beefs with this book?
That was the only thing I read in the book that
My testing agrees with this. This flies in the face of what Chris Cortes
says in his book Optimizing ColdFusion 5. Page 404. Or am I reading it
wrong? Does anyone else have any beefs with this book?
The book is referring to it being more efficient to wrap cfoutput tags
around individual
My testing agrees with this. This flies in the face of what Chris
Cortes
says in his book Optimizing ColdFusion 5. Page 404. Or am I reading
it
wrong? Does anyone else have any beefs with this book?
The book is referring to it being more efficient to wrap cfoutput tags
around
I have to take issue with your last paragraph. I don't know what's going
on
in the examples in the book because I don't own it. However, as has been
discussed here way too many times (check the archives), CFLOOP QUERY=
has
been tuned starting with CF 4.01 to be faster than CFOUTPUT QUERY
of those items, then the difference in performance that you'll
get by tweaking CFOUTPUT vs CFLOOP, or CFSET vs CFSCRIPT, or any of these
other types of things will be truly insignificant.
It's important to remember that there are no perfect applications, and any
time you spend on one thing is time
can't
rely on their behavior in future versions (or previous versions for that
matter).
Eh? I wasn't aware there was a chance Macromedia was going to rip cfscript
out of ColdFusion, or make changes so that cfoutput couldn't loop over
queries. Maybe you're talking about something else
, or make changes so that cfoutput couldn't loop over
queries. Maybe you're talking about something else, but that comment makes
no sense to me.
I believe he meant that the minor performance tweaks being discussed here
may not hold true in new (or previous) versions.
Just because cfloop runs
I believe he meant that the minor performance tweaks being discussed
here
may not hold true in new (or previous) versions.
Ah, ok. Then it makes perfect sense. It's late. It's Monday. I'm closing
the thread in my mind and going home.
-Justin Scott, Lead Developer
Sceiron Internet
there was a chance Macromedia was going
to rip cfscript out of ColdFusion, or make changes so that
cfoutput couldn't loop over queries. Maybe you're talking
about something else, but that comment makes no sense to me.
Yes, I'm talking about something else. While the functionality of CFSCRIPT,
CFOUTPUT
OK, tell us everything you know about CF 7 and CF 2010 ;)
So, we've got two different ways of doing something; one of these
ways used
to be faster than the other, but now their positions have been
reversed,according to this. Who's to say which will be faster
under CF MX, or CF 7,
or CF
Ah, but the real question that will end the debate.
Will it make a difference in NEO?
I don't think it will if after your code is compiled.
This leaves us with, will it compile faster?
Most likely, but everything is compiled on the first hit, who cares, right?
To me, this boils it down
CF7 is great, finally incorporating the full range of object oriented
methodologies within ColdFusion.
CF 2010 is not my cup of tea, though. They decided to bypass the
Internet all together since it is now owned and controlled entirely by
Microsoft, which means, thankfully we still have
At 05:15 PM 4/15/2002 -0500, you wrote:
Ah, but the real question that will end the debate.
Will it make a difference in NEO?
I don't think it will if after your code is compiled.
Someone mentioned that to me in the past. I believe we were talking
about custom tags vs includes.
It
]]
Sent: Monday, April 15, 2002 4:31 PM
To: CF-Talk
Subject: Re: RE: cfoutput - was RE: cfset vs using cfscript
CF7 is great, finally incorporating the full range of object oriented
methodologies within ColdFusion.
CF 2010 is not my cup of tea, though. They decided to bypass the
Internet all
Plane, Nathaniel wrote:
Eek, what about cfoutput group=? You wouldn't be able to group result
sets in this case.
Just use a conditional loop which is not over the query as a query, but
over the query as a structure of arrays. Have to do that anyway if you
want to jump back and forth between
I know that the prevailing wisdom is that CFOUTPUT with the Query attribute
is faster than CFLOOPing over a query. However, in Forta's CF 5
Certification Study Guide, he states that CFLOOP performs better (p. 37 and
374). Has CF 5 improved the performance of CFLOOP (Steve Drcuker referred
I know that the prevailing wisdom is that CFOUTPUT with the Query attribute
is faster than CFLOOPing over a query. However, in Forta's CF 5
Certification Study Guide, he states that CFLOOP performs better (p. 37 and
374). Has CF 5 improved the performance of CFLOOP (Steve Drcuker referred
I agree with everything that Dave says... (Having just deleted all the
stuff I typed cos it was a repeat)
Only to add that
eliminating unnecessary whitespace is important to me. But you will find
that there are some people who swear by using CFOUTPUT QUERY=. When it
comes to grouping
This one came through the list abouyt a month ago, so you may want to check the
archives.
The basic result was that CFLOOP is the way to go.
Personally I wrap my entire page in CFOUTPUT tags and always use CFLOOP to output
queries etc. IMHO
it makes the code easier to read becaue I don't
Yup. CFLOOP no longer sucks. Thank god.
- Original Message -
From: Park, Simon [EMAIL PROTECTED]
Date: Friday, March 8, 2002 8:13 am
Subject: CFLOOP and CFOUTPUT
I know that the prevailing wisdom is that CFOUTPUT with the Query
attributeis faster than CFLOOPing over a query
So, does cfloop perform better than cfoutput or are they now comparable?
Gunna have to change my way of thinking!
Paul Giesenhagen
QuillDesign
http://www.quillldesign.com
SiteDirector - Commerce Builder
- Original Message -
From: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent
Correct, when first introduced CFLOOP was s-l-o-w, but nowadays you'll
actually find that it outperforms CFOUTPUT.
--- Ben
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 08, 2002 11:12 AM
To: CF-Talk
Subject: Re: CFLOOP and CFOUTPUT
Yup
Eek, what about cfoutput group=? You wouldn't be able to group result
sets in this case. And what about page includes, those would be out of the
question (including a page with another cfoutput without a group parameter
would throw an error). This coding method has quite a few consequences
But also remember, when it was introduced cfoutput also had constraints on
the tag usage allowed withen its block, so in cases it was still acceptable
at the expense of speed.. Ah the good ole days =)
Nat
-Original Message-
From: Ben Forta
Sent: Friday, March 08, 2002 1:13 PM
To: CF
From: Plane, Nathaniel [mailto:[EMAIL PROTECTED]]
--
Eek, what about cfoutput group=? And what about page includes, those
would be out of the question (including a page with another cfoutput
without a group parameter would throw an error). This coding method has
quite a few consequences
#'
AND tblPhone.EmpResID = tblEmployee.EMPLOYEE_ID
AND tblEmployee.studioid in (#FORM.StudioID#)
AND tblEmployee.floorid = tblFloor.floorid
ORDER BY #FORM.OrderBy#, tblOffice.City, tblEmployee.EMPLOYEE_ID;
/cfquery
Name
Extension
Edit
CFOUTPUT QUERY=Employees GROUP=StudioName
Office - Studio
- Order your query by employee ID.
- cfoutput the query and cfabort to verify you are in fact getting an
ordered recordset.
- cfoutput the query grouping by employee ID
In your example, your ORDER BY in the query is not by employee ID. You have
to order by employee ID to get your desired
I'm not quite sure exaclt what you want but if you want to display the
name only once, then all of the phone numbers that are associated with
it, then you need multiple grouping values:
CFOUTPUT QUERY=Employees GROUP=city
Office - Studio
#Employees.City
Since cfoutput creates the table one row at a time as each query row is
output, wouldn't it be possible to put a cfif statement in the cfoutput
to
set first and last name to blank if they already exist?
-Original Message-
From: Paul Ihrig [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March
Need to use cfloop you can't nest cfoutputs.
Dave
-Original Message-
From: Matthew R. Small [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 07, 2002 12:54 PM
To: CF-Talk
Subject: RE: Group in cfoutput query. brain fart
I'm not quite sure exaclt what you want but if you want
Dave, you can absolutely nest cfoutputs if you use the group attribute.
This is a nice feature of Cold Fusion that allows reports to made
without a lot of logic involved.
Consider:
cfset currentname=
cfoutput query=somequery
cfif currentname neq namehr#name#Br/cfif
#phonenumber
My bad I didn't notice the group attribute in the second cfoutput.
Dave
-Original Message-
From: Matthew R. Small [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 07, 2002 2:02 PM
To: CF-Talk
Subject: RE: Group in cfoutput query. brain fart
Dave, you can absolutely nest cfoutputs
colspan=3bEdit/b/td
/tr
CFOUTPUT QUERY=Employees GROUP=StudioName
tr
td colspan=5 align=center valign=topa href=Emp_Form.cfmAdd an
Employee/a
:: a href=../Picture_Board/Default.cfmSearch the Picture Board!/a/td
/tr
tr valign=top align=center bgcolor=##33
td colspan=2bfont color=##FFOffice
/td
tdbExtension/b/td
td colspan=3bEdit/b/td
/tr
CFOUTPUT QUERY=Employees GROUP=StudioName
tr
td colspan=2Office - Studio/td
td colspan=3#Employees.City# - #Employees.StudioName#/td
/tr
cfoutput
tr
tdB#Employees.LastName#/B, #Employees.FirstName#/td
td#Employees.PhoneNumb#/td
in (#FORM.StudioID#)
AND tblEmployee.floorid = tblFloor.floorid
ORDER BY tblEmployee.EmployeeID
/cfquery
That should fix ya up.
Adam.
-Original Message-
From: Paul Ihrig [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 06, 2002 4:27 PM
To: CF-Talk
Subject: Group in cfoutput query
Add an order by studioid. Anytime you do a group by in a cfoutput tag,
you must order by the same column in the query. I always thought that the
attribute should be order by - as it is, it's kinda confusing.
Depending on the many-to-one relationships here, you might need several
order bys
I am wondering if anyone can advise if one practice (below) is more
efficient than the other.
Practice 1: Enclosing every instance on #variables# in cfoutput tags
body
cfoutput query=query_name
#query_variable#
/cfoutput
/body
VERSUS
Practice 2: Enclosing
cfoutput is much faster than cfloop always try to use cfoutput when
you can.
Paul Giesenhagen
QuillDesign
http://www.quilldesign.com
SiteDirector - Commerce Builder
I am wondering if anyone can advise if one practice (below) is more
efficient than the other.
Practice 1: Enclosing
CFOUTPUT over a query acts as a scaled down version of CFLOOP. If
you're
simply doing output of variables, it's better to use the first example.
Much faster than CFLOOP.
-Original Message-
From: Michael E. Carluen [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 01, 2002 1:43 PM
PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Subject: Re: Best Practice on using/optimizing cfoutput and cfloops
Date: Fri, 1 Feb 2002 12:47:24 -0600
cfoutput is much faster than cfloop always try to use cfoutput when
you can.
Paul Giesenhagen
QuillDesign
http://www.quilldesign.com
SiteDirector
601 - 700 of 910 matches
Mail list logo