Re: cfoutput and <>

2012-11-05 Thread Rob Voyle

Brilliant Matt
Thanks
Rob

On 5 Nov 2012 at 12:19, Matt Quackenbush wrote:

> 
> <#email#>
> 
> 



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353062
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: cfoutput and <>

2012-11-05 Thread Matt Quackenbush

<#email#>


On Mon, Nov 5, 2012 at 12:17 PM, Rob Voyle  wrote:

>
> Hi folks
>
> I need to output email addresses  enclosed in <> as is  <#email#>
>
> I am using  #name# <#email#> 
> just gives the name how do I escape the < > (doubling doesn't work)
>
> Thanks
>
> Rob
>
>
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353061
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


cfoutput and <>

2012-11-05 Thread Rob Voyle

Hi folks

I need to output email addresses  enclosed in <> as is  <#email#>

I am using  #name# <#email#>  
just gives the name how do I escape the < > (doubling doesn't work)

Thanks

Rob


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353060
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: cfoutput and groups

2007-08-06 Thread Dale Fraser
You need an inner 

#qGetCEProcedures.cecategory#


#qGetCEProcedures.cename#



So you can put stuff in the first cfoutput or second, the first one happens
once per group and the second for each item in the group.

Regards
Dale Fraser

http://dalefraser.blogspot.com


-Original Message-
From: Peter Tanswell [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, 7 August 2007 12:04 PM
To: CF-Talk
Subject: cfoutput and groups

Hi there

I have a query where I am getting information from 2 tables.

Basically a category table i.e. categories are face, body & breasts

Users have entered details of cosmetic enhancementprocedures according to
whether the procedure is for face, body or breasts, e.g. face has face lift,
rhinoplasty, browlift, Body has liposuction, tummy tuck etc

On the site I want to display the information in the respective groups hence
body, face and breasts.

My query is as follows:


SELECT  cecat.cecatid, cecat.cecategory, ce.cecategoryid, ce.cename,
ce.cedetails, ce.ceresults
FROM  tbl_cosmeticenhancement ce, tbl_cecategories cecat
WHERE  ce.cecategoryid = cecat.cecatid
Order by cecat.cecategory


Then I was going to have 



#qGetCEProcedures.cecategory#
#qGetCEProcedures.cename#


What I am finding is that I am only getting one result displayed for each
category instead of 3 or 4. 

Thanks in advance for feedback. 




~|
Download the latest ColdFusion 8 utilities including Report Builder,
plug-ins for Eclipse and Dreamweaver updates.
http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285551
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: cfoutput and groups

2007-08-06 Thread James Holmes
You need an inner cfoutput to loop inside the group.

On 8/7/07, Peter Tanswell <[EMAIL PROTECTED]> wrote:
> Hi there
>
> I have a query where I am getting information from 2 tables.
>
> Basically a category table i.e. categories are face, body & breasts
>
> Users have entered details of cosmetic enhancementprocedures according to 
> whether the procedure is for face, body or breasts, e.g. face has face lift, 
> rhinoplasty, browlift, Body has liposuction, tummy tuck etc
>
> On the site I want to display the information in the respective groups hence 
> body, face and breasts.
>
> My query is as follows:
>
>
> SELECT  cecat.cecatid, cecat.cecategory, ce.cecategoryid, ce.cename, 
> ce.cedetails, ce.ceresults
> FROM  tbl_cosmeticenhancement ce, tbl_cecategories cecat
> WHERE  ce.cecategoryid = cecat.cecatid
> Order by cecat.cecategory
>
>
> Then I was going to have
>
>
> 
> #qGetCEProcedures.cecategory#
> #qGetCEProcedures.cename#
>
>
> What I am finding is that I am only getting one result displayed for each 
> category instead of 3 or 4.


-- 
mxAjax / CFAjax docs and other useful articles:
http://www.bifrost.com.au/blog/

~|
Create robust enterprise, web RIAs.
Upgrade to ColdFusion 8 and integrate with Adobe Flex
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285550
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: cfoutput and groups

2007-08-06 Thread Joel Watson
> Hi there
> 
> I have a query where I am getting information from 2 tables.
> 
> Basically a category table i.e. categories are face, body & breasts
> 
> Users have entered details of cosmetic enhancementprocedures according 
> to whether the procedure is for face, body or breasts, e.g. face has 
> face lift, rhinoplasty, browlift, Body has liposuction, tummy tuck 
> etc
> 
> On the site I want to display the information in the respective groups 
> hence body, face and breasts.
> 
> My query is as follows:
> 
> 
> SELECT  cecat.cecatid, cecat.cecategory, ce.cecategoryid, ce.cename, 
> ce.cedetails, ce.ceresults
> FROM  tbl_cosmeticenhancement ce, tbl_cecategories cecat
> WHERE  ce.cecategoryid = cecat.cecatid
> Order by cecat.cecategory
> 
> 
> Then I was going to have 
> 
> 
> 
> #qGetCEProcedures.cecategory#
> #qGetCEProcedures.cename#
> 
> 
> What I am finding is that I am only getting one result displayed for 
> each category instead of 3 or 4. 
> 
> Thanks in advance for feedback. 


Have you tried joining the tables on the shared categoryID values? 

~|
ColdFusion is delivering applications solutions at at top companies 
around the world in government.  Find out how and where now
http://www.adobe.com/cfusion/showcase/index.cfm?event=finder&productID=1522&loc=en_us

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285549
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


cfoutput and groups

2007-08-06 Thread Peter Tanswell
Hi there

I have a query where I am getting information from 2 tables.

Basically a category table i.e. categories are face, body & breasts

Users have entered details of cosmetic enhancementprocedures according to 
whether the procedure is for face, body or breasts, e.g. face has face lift, 
rhinoplasty, browlift, Body has liposuction, tummy tuck etc

On the site I want to display the information in the respective groups hence 
body, face and breasts.

My query is as follows:


SELECT  cecat.cecatid, cecat.cecategory, ce.cecategoryid, ce.cename, 
ce.cedetails, ce.ceresults
FROM  tbl_cosmeticenhancement ce, tbl_cecategories cecat
WHERE  ce.cecategoryid = cecat.cecatid
Order by cecat.cecategory


Then I was going to have 



#qGetCEProcedures.cecategory#
#qGetCEProcedures.cename#


What I am finding is that I am only getting one result displayed for each 
category instead of 3 or 4. 

Thanks in advance for feedback. 


~|
Download the latest ColdFusion 8 utilities including Report Builder,
plug-ins for Eclipse and Dreamweaver updates.
http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285548
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


CFOUTPUT and Nested Loops and Grouping

2007-01-04 Thread Bruce Sorge
I have a page that has four queries. One gets a list of council names, the
other three get documents that are either live, archived or awaiting
approval. So, as you can see by my code below, I have X tables depending on
how many councils there are. Each table group has three rows that have the
links to the documents. It is working well except that each council shows
ALL of the documents that are getting called. For instance, the first two
table groups should have no documents since there are none for that council,
and the third table group should have documents. I tried to do a cfoutput
inside the loop using a group attribute, but no joy. How to do this?

 

 


 
 
  
  #Name#'s Bylaws (current, temp and past)
  
 
 
  
   Current Bylaw
  
  
   
   
#Bylaw_Name#
 #DateFormat(Create_Date, "mm/dd/yy")#
   
  
  
  
   
Archived Bylaws
   
   
    

 #Arch_Bylaw_Name# #DateFormat(Create_Date,
"mm/dd/yy")#

   
  
   

 Pending Bylaw


 
 
  #Temp_Bylaw_Name# #DateFormat(Create_Date,
"mm/dd/yy")#
 
 

   
  
  

 

Thanks,

 

Bruce Sorge

Contractor

City of Los Angeles

Department of Neighborhood Empowerment



~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265667
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: cfoutput and cfquery question ...

2004-08-28 Thread Charles Heizer
This was just what I was looking for ...

Thanks a bunch!

- Charles

>Here you go ...
>
>
>
>  
>  #col# = #evaluate(col)#
>  
>
>
>- Joe
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: cfoutput and cfquery question ...

2004-08-28 Thread joe velez
Here you go ...



  
  #col# = #evaluate(col)#
  


- Joe
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




RE: cfoutput and cfquery question ...

2004-08-28 Thread Marlon Moyer
you could always use 

or you could loop through the q_info.columnlist variable.

> -Original Message-
> From: Charles Heizer [mailto:[EMAIL PROTECTED]
> Sent: Saturday, August 28, 2004 2:07 PM
> To: CF-Talk
> Subject: cfoutput and cfquery question ...
> 
> Hello,
> I was wondering if there was a easy way to run a quick query and have it
> display all of the results with out know in column names?
> 
> Example --
> 
> 
> 	SELECT *
> 	FROM DOCS
> 
> 
> 
>    #q_Info.queryoutput# <--- This is what I need help with :-)
> 
> 
> Thanks,
> - Charles
> 
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: cfoutput and cfquery question ...

2004-08-28 Thread Dick Applebaum
Loop thru query.ColumnNames

On Aug 28, 2004, at 12:06 PM, Charles Heizer wrote:

> Hello,
>  I was wondering if there was a easy way to run a quick query and have 
> it display all of the results with out know in column names?
>
>  Example --
>
>  
>  SELECT *
>  FROM DOCS
>  
>
>  
> #q_Info.queryoutput# <--- This is what I need help with :-)
>  
>
>  Thanks,
>  - Charles
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




cfoutput and cfquery question ...

2004-08-28 Thread Charles Heizer
Hello,
I was wondering if there was a easy way to run a quick query and have it display all of the results with out know in column names?

Example --


	SELECT *
	FROM DOCS



   #q_Info.queryoutput# <--- This is what I need help with :-)


Thanks,
- Charles
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: cfoutput and grouping

2002-07-14 Thread Joseph Thompson

You should be able to do a simple group on the date:

SELECT
  Format(YourDate,'') AS GroupedDate
GROUP BY
  GroupedDate

http://cfhub.com/forum//index.cfm?FuseAction=Thread&TopicID=2399


> Hi,
>
> What is the best way to group by months for a query that contains full
(day,
> month, year) dates?
>
> The query looks something like:
>
> startDate , user
> 10-JUN-2000, Bill
> 30-JUN-2000, Steve
> 15-SEP-2000, Phil
>
> I would like the results to be displayed thus:
>
> June 2000
>
>   Bill
>   Steve
>
> September 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:
>
> 
>
> 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
>
> David
> 
__
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: cfoutput and grouping

2002-07-14 Thread Whiterod, David (PLNSA)

Hi Tim,

At the mo I am using Access but would like solution that would work on any
DB.

I think I will create a custom function like:

AddDateCol(theQuery, newColumnName, datePart)

It may even appear on cflib.org :-)

cheers

David


-Original Message-
From: Timothy Heald [mailto:[EMAIL 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,

What is the best way to group by months for a query that contains full (day,
month, year) dates?

The query looks something like:

startDate , user
10-JUN-2000, Bill
30-JUN-2000, Steve
15-SEP-2000, Phil

I would like the results to be displayed thus:

June 2000

  Bill
  Steve

September 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:



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

David


__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: cfoutput and grouping

2002-07-14 Thread Matthew Walker

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 and grouping
> 
> 
> Hi,
> 
> What is the best way to group by months for a query that 
> contains full (day,
> month, year) dates?
> 
> The query looks something like:
> 
> startDate , user
> 10-JUN-2000, Bill
> 30-JUN-2000, Steve
> 15-SEP-2000, Phil
> 
> I would like the results to be displayed thus:
> 
> June 2000
> 
>   Bill
>   Steve
> 
> September 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:
> 
> 
> 
> 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
> 
> David
> 
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: cfoutput and grouping

2002-07-14 Thread Timothy Heald

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?

The query looks something like:

startDate , user
10-JUN-2000, Bill
30-JUN-2000, Steve
15-SEP-2000, Phil

I would like the results to be displayed thus:

June 2000

  Bill
  Steve

September 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:



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

David

__
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



cfoutput and grouping

2002-07-14 Thread Whiterod, David (PLNSA)

Hi,

What is the best way to group by months for a query that contains full (day,
month, year) dates?

The query looks something like:

startDate , user
10-JUN-2000, Bill
30-JUN-2000, Steve
15-SEP-2000, Phil

I would like the results to be displayed thus:

June 2000

  Bill
  Steve

September 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:



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

David
__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Best Practice on using/optimizing cfoutput and cfloops

2002-02-01 Thread Tyler M. Fitch

Hi Steve,

That KB article
http://www.macromedia.com/v1/Handlers/index.cfm?ID=2497&Method=Full 
is for CF Server 3.1... And as people have pointed out, there was a
shift in 4.5 to make the cfoutput/cfloop difference nominal.  So I'd
consider that information, well... dated.

We tend to put a  at the top of
every page and begin all our CF processing and then put a cfoutput ride
before we start any HTML output.  Then close cfoutput at the bottom of
the page.  Everything inside the output is then available for CF use and
we don't have to think about whether we need to add yet another cfoutput
tag around one line here or there.  All queries are cflooped and we find
performance to be just fine.

Maybe we would save a millisecond or two with opening and closing
cfoutput tags throughout the page but it's not really worth it.

Cheers,

t

**
Tyler M. Fitch
Certified Advanced ColdFusion 5 Developer
http://isitedesign.com
**



-Original Message-
From: Steve Oliver [mailto:[EMAIL PROTECTED]] 
Sent: Friday, February 01, 2002 1:08 PM
To: CF-Talk
Subject: RE: Best Practice on using/optimizing cfoutput and cfloops


This is directly from the Knowledge base on macromedia.

CFOUTPUT vs. CFLOOP

Use a CFOUTPUT query instead of CFLOOP query wherever possible. A loop
over a query repeats for every record in the query result set. The
CFLOOP results are just like a CFOUTPUT. During each iteration of the
loop the columns of the current row will be available for output. The
advantage of using CFLOOP instead of a CFOUTPUT is that you can use any
CFML tag within a CFLOOP. CFOUTPUT is restricted to a limited number of
tags to increase its performance. 

http://www.macromedia.com/v1/Handlers/index.cfm?ID=2497&Method=Full

__
steve oliver
atnet solutions, inc.
http://www.atnetsolutions.com



__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Best Practice on using/optimizing cfoutput and cfloops

2002-02-01 Thread Lee Fuller

Agreed...

We've been unable to confirm either, and attempt to do as much as is
reasonable to limit the amount of parsing for ANY CF tag.  However,
we're especially careful when we have a template that gets heavy usage
or will pull a lot of data.


Lee Fuller
Chief Technical Officer
PrimeDNA Corporation / AAA Web Hosting Corporation
"We ARE the net."
http://www.aaawebhosting.com




> -Original Message-
> From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] 
> Sent: Friday, February 01, 2002 2:48 PM
> To: CF-Talk
> Subject: RE: Best Practice on using/optimizing cfoutput and cfloops
> 
> 
> The issue with Cfoutput is that it parses everything between 
> the two tags looking for CF variables to output -including 
> any HTML that might be between the tags. If you have a lot of 
> HTML between your  tags, and just a few 
> variables, you are making CF wade through a lot of code that 
> it doesn't need to.  However, the penalty in many cases is 
> negligable and should be ignored in favor of the ease of use 
> (don't you hate going through and bracketing every little 
> thing in CF output tags?). In our own testing we have been 
> unable to prove that  is slower than a comparable 
> cfloop - but we do make an effort to make the HTML that is 
> between a  tags reasonably lean.
> 
> Mark
> 
> -Original Message-
> From: Dave Carabetta [mailto:[EMAIL PROTECTED]]
> Sent: Friday, February 01, 2002 12:33 PM
> To: CF-Talk
> Subject: Re: Best Practice on using/optimizing cfoutput and cfloops
> 
> 
> I would actually disput that claim. I can't find the article 
> for the life of me, but I think Michael Dinowitz or somebody 
> wrote an article some time ago comparing the two methods. 
> From what I remember CFLOOP is faster because it is a "dumbed 
> down" way of outputting your data. It doesn't look for record 
> set counts or anything, it just loops over whatever you give 
> it. I wish I could support this claim with valid links to 
> writings, but I know I have heard and read that CFLOOP is faster.
> 
> Dave.
> 
> 
> Original Message Follows----
> From: "Paul Giesenhagen" <[EMAIL PROTECTED]>
> Reply-To: [EMAIL 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
> 
>  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 every instance on #variables# in 
> cfoutput tags  >  >   >   
> > #query_variable#  >   >   >  >  >  > 
> VERSUS  >  >  >  > Practice 2: Enclosing the entire code in a 
> single cfoutput and use cfloop  > when necessary  >  >  
>  >   >   > 
> #query_variable#  >   >   >   >  > 
>  >  > Any advise to demystify any 'performance penalties' 
> would be appreciated.  >  >  >  > Thanks,  >  > Michael  >
__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Best Practice on using/optimizing cfoutput and cfloops

2002-02-01 Thread Steve Oliver

This is directly from the Knowledge base on macromedia.

CFOUTPUT vs. CFLOOP

Use a CFOUTPUT query instead of CFLOOP query wherever possible. A loop
over a query repeats for every record in the query result set. The
CFLOOP results are just like a CFOUTPUT. During each iteration of the
loop the columns of the current row will be available for output. The
advantage of using CFLOOP instead of a CFOUTPUT is that you can use any
CFML tag within a CFLOOP. CFOUTPUT is restricted to a limited number of
tags to increase its performance. 

http://www.macromedia.com/v1/Handlers/index.cfm?ID=2497&Method=Full

__
steve oliver
atnet solutions, inc.
http://www.atnetsolutions.com


-Original Message-
From: Steve Oliver [mailto:[EMAIL PROTECTED]] 
Sent: Friday, February 01, 2002 3:58 PM
To: CF-Talk
Subject: RE: Best Practice on using/optimizing cfoutput and cfloops


See I've heard the exact opposite of that.  I used to code like that,
putting cfoutput around everything and using cfloop to loop over the
queries, but after looking over quite a few sites, most of them say
using cfoutput to loop is a lot faster.  

Even in the Allaire knowledge base it said to use cfoutput for looping
through queries.

__
steve oliver
atnet solutions, inc.
http://www.atnetsolutions.com


-Original Message-
From: Dave Carabetta [mailto:[EMAIL PROTECTED]] 
Sent: Friday, February 01, 2002 3:46 PM
To: CF-Talk
Subject: Re: Best Practice on using/optimizing cfoutput and cfloops


OK, I finally found some explanations in the archives. Careful about the
URL 
wrapping. One thing to keep in mind as I've read through some of the old

posts, I think the answer depends on two things:

1.) CF Server version
Apparently, CF 4.0 and below proved that CFOUTPUT was quicker, but the 
reverse is true for 4.5+.

2.) Size of record set
For small record sets, the difference is negligible. However, for larger

record sets, CFLOOP wins. The links below should expand a bit on this 
thought, especially the first link.

http://www.mail-archive.com/cf-talk@houseoffusion.com/msg54188.html

This one refers to Forta's CF Developer's Study Guide:
http://www.mail-archive.com/cf-talk@houseoffusion.com/msg54029.html


Hope this helps,
Dave.


Original Message Follows
From: "Paul Giesenhagen" <[EMAIL PROTECTED]>
Reply-To: [EMAIL 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

 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 every instance on #variables# in cfoutput tags
 >
 > 
 > 
 > #query_variable#
 > 
 > 
 >
 >
 >
 > VERSUS
 >
 >
 >
 > Practice 2: Enclosing the entire code in a single cfoutput and use
cfloop
 > when necessary
 >
 > 
 > 
 > 
 > #query_variable#
 > 
 > 
 > 
 >
 >
 >
 > Any advise to demystify any 'performance penalties' would be
appreciated.
 >
 >
 >
 > Thanks,
 >
 > Michael
 >



__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Best Practice on using/optimizing cfoutput and cfloops

2002-02-01 Thread Steve Oliver

See I've heard the exact opposite of that.  I used to code like that,
putting cfoutput around everything and using cfloop to loop over the
queries, but after looking over quite a few sites, most of them say
using cfoutput to loop is a lot faster.  

Even in the Allaire knowledge base it said to use cfoutput for looping
through queries.

__
steve oliver
atnet solutions, inc.
http://www.atnetsolutions.com


-Original Message-
From: Dave Carabetta [mailto:[EMAIL PROTECTED]] 
Sent: Friday, February 01, 2002 3:46 PM
To: CF-Talk
Subject: Re: Best Practice on using/optimizing cfoutput and cfloops


OK, I finally found some explanations in the archives. Careful about the
URL 
wrapping. One thing to keep in mind as I've read through some of the old

posts, I think the answer depends on two things:

1.) CF Server version
Apparently, CF 4.0 and below proved that CFOUTPUT was quicker, but the 
reverse is true for 4.5+.

2.) Size of record set
For small record sets, the difference is negligible. However, for larger

record sets, CFLOOP wins. The links below should expand a bit on this 
thought, especially the first link.

http://www.mail-archive.com/cf-talk@houseoffusion.com/msg54188.html

This one refers to Forta's CF Developer's Study Guide:
http://www.mail-archive.com/cf-talk@houseoffusion.com/msg54029.html


Hope this helps,
Dave.


Original Message Follows
From: "Paul Giesenhagen" <[EMAIL PROTECTED]>
Reply-To: [EMAIL 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

 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 every instance on #variables# in cfoutput tags
 >
 > 
 > 
 > #query_variable#
 > 
 > 
 >
 >
 >
 > VERSUS
 >
 >
 >
 > Practice 2: Enclosing the entire code in a single cfoutput and use
cfloop
 > when necessary
 >
 > 
 > 
 > 
 > #query_variable#
 > 
 > 
 > 
 >
 >
 >
 > Any advise to demystify any 'performance penalties' would be
appreciated.
 >
 >
 >
 > Thanks,
 >
 > Michael
 >


__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Best Practice on using/optimizing cfoutput and cfloops

2002-02-01 Thread ksuh

In CF5, it's not supposed to matter if you do cfloop or cfoutput.  
I've 

done some testing with getTickCount() to compare the two and they seem 

to be equivalent.  I remember back in the version 3 days where cfloop 

would be slow as molasses.

- Original Message -
From: Dave Carabetta <[EMAIL PROTECTED]>
Date: Friday, February 1, 2002 1:32 pm
Subject: Re: Best Practice on using/optimizing cfoutput and cfloops

> I would actually disput that claim. I can't find the article for 

> the life of 

> me, but I think Michael Dinowitz or somebody wrote an article some 

> time ago 

> comparing the two methods. From what I remember CFLOOP is faster 

> because it 

> is a "dumbed down" way of outputting your data. It doesn't lo
ok 

> for record 

> set counts or anything, it just loops over whatever you give it. 
I 

> wish I 

> could support this claim with valid links to writings, but I know 

> I have 

> heard and read that CFLOOP is faster.
> 

> Dave.
> 

> 

> Original Message Follows
> From: "Paul Giesenhagen" <[EMAIL PROTECTED]>
> Reply-To: [EMAIL PROTECTED]
> To: CF-Talk <[EMAIL PROTECTED]>
> Subject: Re: Best Practice on using/optimizing cfoutput and cfloo
ps
> Date: Fri, 1 Feb 2002 12:47:24 -0600
> 

>  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 mo
re
> > efficient than the other.
> >
> >
> > Practice 1: Enclosing every instance on #variables# in cfou
tput 

> tags >
> > 
> > 
> > #query_variable#
> > 
> > 
> >
> >
> >
> > VERSUS
> >
> >
> >
> > Practice 2: Enclosing the entire code in a single cfoutput and 

> use cfloop
> > when necessary
> >
> > 
> > 
> > 
> > #query_variable#
> > 
> > 
> > 
> >
> >
> >
> > Any advise to demystify any 'performance penalties' would be 

> appreciated. >
> >
> >
> > Thanks,
> >
> > Michael
> >
> 

> ___
_
__
> Get Your Own Dedicated Windows 2000 Server
>  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
>  Instant Activation · $99/Month · Free Setup
>  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb

> FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion
com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sideb
ar=lists
> 
__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Best Practice on using/optimizing cfoutput and cfloops

2002-02-01 Thread Mark A. Kruger - CFG

The issue with Cfoutput is that it parses everything between the two tags
looking for CF variables to output -including any HTML that might be between
the tags. If you have a lot of HTML between your  tags,
and just a few variables, you are making CF wade through a lot of code that
it doesn't need to.  However, the penalty in many cases is negligable and
should be ignored in favor of the ease of use (don't you hate going through
and bracketing every little thing in CF output tags?). In our own testing we
have been unable to prove that  is slower than a comparable
cfloop - but we do make an effort to make the HTML that is between a
 tags reasonably lean.

Mark

-Original Message-
From: Dave Carabetta [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 01, 2002 12:33 PM
To: CF-Talk
Subject: Re: Best Practice on using/optimizing cfoutput and cfloops


I would actually disput that claim. I can't find the article for the life of
me, but I think Michael Dinowitz or somebody wrote an article some time ago
comparing the two methods. From what I remember CFLOOP is faster because it
is a "dumbed down" way of outputting your data. It doesn't look for record
set counts or anything, it just loops over whatever you give it. I wish I
could support this claim with valid links to writings, but I know I have
heard and read that CFLOOP is faster.

Dave.


Original Message Follows
From: "Paul Giesenhagen" <[EMAIL PROTECTED]>
Reply-To: [EMAIL 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

 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 every instance on #variables# in cfoutput tags
 >
 > 
 > 
 > #query_variable#
 > 
 > 
 >
 >
 >
 > VERSUS
 >
 >
 >
 > Practice 2: Enclosing the entire code in a single cfoutput and use cfloop
 > when necessary
 >
 > 
 > 
 > 
 > #query_variable#
 > 
 > 
 > 
 >
 >
 >
 > Any advise to demystify any 'performance penalties' would be appreciated.
 >
 >
 >
 > Thanks,
 >
 > Michael
 >

_
_

Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Best Practice on using/optimizing cfoutput and cfloops

2002-02-01 Thread Dave Carabetta

OK, I finally found some explanations in the archives. Careful about the URL 
wrapping. One thing to keep in mind as I've read through some of the old 
posts, I think the answer depends on two things:

1.) CF Server version
Apparently, CF 4.0 and below proved that CFOUTPUT was quicker, but the 
reverse is true for 4.5+.

2.) Size of record set
For small record sets, the difference is negligible. However, for larger 
record sets, CFLOOP wins. The links below should expand a bit on this 
thought, especially the first link.

http://www.mail-archive.com/cf-talk@houseoffusion.com/msg54188.html

This one refers to Forta's CF Developer's Study Guide:
http://www.mail-archive.com/cf-talk@houseoffusion.com/msg54029.html


Hope this helps,
Dave.


Original Message Follows
From: "Paul Giesenhagen" <[EMAIL PROTECTED]>
Reply-To: [EMAIL 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

 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 every instance on #variables# in cfoutput tags
 >
 > 
 > 
 > #query_variable#
 > 
 > 
 >
 >
 >
 > VERSUS
 >
 >
 >
 > Practice 2: Enclosing the entire code in a single cfoutput and use cfloop
 > when necessary
 >
 > 
 > 
 > 
 > #query_variable#
 > 
 > 
 > 
 >
 >
 >
 > Any advise to demystify any 'performance penalties' would be appreciated.
 >
 >
 >
 > Thanks,
 >
 > Michael
 >

__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Best Practice on using/optimizing cfoutput and cfloops

2002-02-01 Thread Bryan Stevenson

Ben Forta has this info on his site.  It's in a PowerPoint presentation, so I don't 
have a direct
link.

Go to www.forta.comclikc ColdFusion.clikc on CF resources.go to bottom of 
page (or close
to bottom) and look for Tips and Tricks from the CF Masters (or something like 
that)then select
the CFLOOP Vs CFOUTPUT in the left frame (also look at the section about not overdoing 
CFOUTPUT)

Once again a great resource from Ben ;-)

Bryan Stevenson
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
p. 250.920.8830
e. [EMAIL PROTECTED]
-
Macromedia Associate Partner
www.macromedia.com

- Original Message -
From: "Steve Oliver" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, February 01, 2002 12:39 PM
Subject: RE: Best Practice on using/optimizing cfoutput and cfloops


> I've read that cfloop is faster when doing certain things, but if your
> using it to cfoutput, like this:
>
> 
> #var1# blah blah blah
> #var2#
> 
>
> That way supposedly runs slower because CF has to parse the data in each
> cfoutput.
>
> __
> steve oliver
> atnet solutions, inc.
> http://www.atnetsolutions.com
>
>
> -Original Message-
> From: Dave Carabetta [mailto:[EMAIL PROTECTED]]
> Sent: Friday, February 01, 2002 3:33 PM
> To: CF-Talk
> Subject: Re: Best Practice on using/optimizing cfoutput and cfloops
>
>
> I would actually disput that claim. I can't find the article for the
> life of
> me, but I think Michael Dinowitz or somebody wrote an article some time
> ago
> comparing the two methods. From what I remember CFLOOP is faster because
> it
> is a "dumbed down" way of outputting your data. It doesn't look for
> record
> set counts or anything, it just loops over whatever you give it. I wish
> I
> could support this claim with valid links to writings, but I know I have
>
> heard and read that CFLOOP is faster.
>
> Dave.
>
>
> Original Message Follows
> From: "Paul Giesenhagen" <[EMAIL PROTECTED]>
> Reply-To: [EMAIL 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
>
>  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 every instance on #variables# in cfoutput tags
>  >
>  > 
>  > 
>  > #query_variable#
>  > 
>  > 
>  >
>  >
>  >
>  > VERSUS
>  >
>  >
>  >
>  > Practice 2: Enclosing the entire code in a single cfoutput and use
> cfloop
>  > when necessary
>  >
>  > 
>  > 
>  > 
>  > #query_variable#
>  > 
>  > 
>  > 
>  >
>  >
>  >
>  > Any advise to demystify any 'performance penalties' would be
> appreciated.
>  >
>  >
>  >
>  > Thanks,
>  >
>  > Michael
>  >
>
>
> 
__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Best Practice on using/optimizing cfoutput and cfloops

2002-02-01 Thread Steve Oliver

I've read that cfloop is faster when doing certain things, but if your
using it to cfoutput, like this:


#var1# blah blah blah
#var2#


That way supposedly runs slower because CF has to parse the data in each
cfoutput.

__
steve oliver
atnet solutions, inc.
http://www.atnetsolutions.com


-Original Message-
From: Dave Carabetta [mailto:[EMAIL PROTECTED]] 
Sent: Friday, February 01, 2002 3:33 PM
To: CF-Talk
Subject: Re: Best Practice on using/optimizing cfoutput and cfloops


I would actually disput that claim. I can't find the article for the
life of 
me, but I think Michael Dinowitz or somebody wrote an article some time
ago 
comparing the two methods. From what I remember CFLOOP is faster because
it 
is a "dumbed down" way of outputting your data. It doesn't look for
record 
set counts or anything, it just loops over whatever you give it. I wish
I 
could support this claim with valid links to writings, but I know I have

heard and read that CFLOOP is faster.

Dave.


Original Message Follows
From: "Paul Giesenhagen" <[EMAIL PROTECTED]>
Reply-To: [EMAIL 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

 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 every instance on #variables# in cfoutput tags
 >
 > 
 > 
 > #query_variable#
 > 
 > 
 >
 >
 >
 > VERSUS
 >
 >
 >
 > Practice 2: Enclosing the entire code in a single cfoutput and use
cfloop
 > when necessary
 >
 > 
 > 
 > 
 > #query_variable#
 > 
 > 
 > 
 >
 >
 >
 > Any advise to demystify any 'performance penalties' would be
appreciated.
 >
 >
 >
 > Thanks,
 >
 > Michael
 >


__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Best Practice on using/optimizing cfoutput and cfloops

2002-02-01 Thread Dave Carabetta

I would actually disput that claim. I can't find the article for the life of 
me, but I think Michael Dinowitz or somebody wrote an article some time ago 
comparing the two methods. From what I remember CFLOOP is faster because it 
is a "dumbed down" way of outputting your data. It doesn't look for record 
set counts or anything, it just loops over whatever you give it. I wish I 
could support this claim with valid links to writings, but I know I have 
heard and read that CFLOOP is faster.

Dave.


Original Message Follows
From: "Paul Giesenhagen" <[EMAIL PROTECTED]>
Reply-To: [EMAIL 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

 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 every instance on #variables# in cfoutput tags
 >
 > 
 > 
 > #query_variable#
 > 
 > 
 >
 >
 >
 > VERSUS
 >
 >
 >
 > Practice 2: Enclosing the entire code in a single cfoutput and use cfloop
 > when necessary
 >
 > 
 > 
 > 
 > #query_variable#
 > 
 > 
 > 
 >
 >
 >
 > Any advise to demystify any 'performance penalties' would be appreciated.
 >
 >
 >
 > Thanks,
 >
 > Michael
 >

__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Best Practice on using/optimizing cfoutput and cfloops

2002-02-01 Thread Carlisle, Eric

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
To: CF-Talk
Subject: Best Practice on using/optimizing cfoutput and cfloops


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



#query_variable#





VERSUS



Practice 2: Enclosing the entire code in a single cfoutput and use 
cfloop 
when necessary




#query_variable#






Any advise to demystify any 'performance penalties' would be 
appreciated.



Thanks,

Michael

__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Best Practice on using/optimizing cfoutput and cfloops

2002-02-01 Thread Paul Giesenhagen

 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 every instance on #variables# in cfoutput tags
>
> 
> 
> #query_variable#
> 
> 
>
>
>
> VERSUS
>
>
>
> Practice 2: Enclosing the entire code in a single cfoutput and use cfloop
> when necessary
>
> 
> 
> 
> #query_variable#
> 
> 
> 
>
>
>
> Any advise to demystify any 'performance penalties' would be appreciated.
>
>
>
> Thanks,
>
> Michael
> 
__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Best Practice on using/optimizing cfoutput and cfloops

2002-02-01 Thread Michael E. Carluen

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



#query_variable#





VERSUS



Practice 2: Enclosing the entire code in a single cfoutput and use cfloop 
when necessary




#query_variable#






Any advise to demystify any 'performance penalties' would be appreciated.



Thanks,

Michael
__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: CFSETTING, CFOUTPUT and CFINCLUDE

2001-07-26 Thread Philip Arnold - ASP

Aidan,

I'll break this down into points

> With ColdFusion Professional 4.01, if you have this:
>
> 
>
> 
> ...some HTML here...
> 
> 
>
> 
>
> and include.cfm is
>
> 
> ...lots of lines of CFCode here...
> #variables.x#

What's in the "CFCode here" bit?
If it's all CFSet and CFIf, then use CFScript - it's white-space less - in
CF4, don't do loops in it as it's slower

> from the point of view of CFSETTING, CFOUTPUT is being carried over within
> the included file (ie, if you view the source, CFSETTING isn't suppressing
> the whitespace within the included file).

This should carry over, but I'll have to run some tests on our CF4 server

> However, from CFOUTPUTs point of view, it *hasn't* been carried
> over because
> #variables.x# isn't evaluated - without an additional CFOUTPUT around it,
> you'll see "#variables.x#". This just doesn't seem consistent.

This is correct, a CFInclude has to have all CFOutput's done within it -
this is so you can use 

> As you must have another CFOUTPUT block to output variables within the
> included file , why doesn't the first CFSETTING tag say "OK, the
> effects of
> the CFOUTPUT block around the included file isn't carried over into it, so
> I'll stop treating code within the included file as being wrapped within
> CFOUTPUT and suppress whitespace within it"?

It should - notice the word "should" - I'll do some testing

Philip Arnold
Director
Certified ColdFusion Developer
ASP Multimedia Limited
T: +44 (0)20 8680 1133

"Websites for the real world"

**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



CFSETTING, CFOUTPUT and CFINCLUDE

2001-07-25 Thread Aidan Whitehall

With ColdFusion Professional 4.01, if you have this:




...some HTML here...





and include.cfm is


...lots of lines of CFCode here...
#variables.x#

from the point of view of CFSETTING, CFOUTPUT is being carried over within
the included file (ie, if you view the source, CFSETTING isn't suppressing
the whitespace within the included file).

However, from CFOUTPUTs point of view, it *hasn't* been carried over because
#variables.x# isn't evaluated - without an additional CFOUTPUT around it,
you'll see "#variables.x#". This just doesn't seem consistent.

As you must have another CFOUTPUT block to output variables within the
included file , why doesn't the first CFSETTING tag say "OK, the effects of
the CFOUTPUT block around the included file isn't carried over into it, so
I'll stop treating code within the included file as being wrapped within
CFOUTPUT and suppress whitespace within it"?


-- 
Aidan Whitehall <[EMAIL PROTECTED]>
Macromedia ColdFusion Developer
Fairbanks Environmental +44 (0)1695 51775
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists