Re: [ACFUG Discuss] Query or Stored Proc calling

2010-02-04 Thread Derrick Peavy
Ajas: I am not an expert on how CF actually executes, but I am pretty darn sure that the assumption you have is wrong. cfoutputgetSomething.col1 br / getSomething.col2 br / getSomething.col3 br / /cfoutput Is not re-executing the query. Once the query is run once, assuming the query is

Re: [ACFUG Discuss] Query or Stored Proc calling

2010-02-04 Thread Ajas Mohammed
Thanks Teddy and Derrick. Good to know that I was wrong in my assumption. I felt cfoutputgetSomething.col1 br / getSomething.col2 br / getSomething.col3 br / /cfoutput is an overkill but apparently not. Thanks, Ajas Mohammed / http://ajashadi.blogspot.com We cannot become what we need to be,

RE: [ACFUG Discuss] Query or Stored Proc calling

2010-02-04 Thread Charlie Arehart
to your question that I'm not seeing? /charlie From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Ajas Mohammed Sent: Wednesday, February 03, 2010 10:21 PM To: discussion@acfug.org Subject: [ACFUG Discuss] Query or Stored Proc calling Hi, I came across code like this cfquery

RE: [ACFUG Discuss] Query or Stored Proc calling

2010-02-04 Thread Charlie Arehart
...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Derrick Peavy Sent: Thursday, February 04, 2010 10:00 AM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] Query or Stored Proc calling Ajas: I am not an expert on how CF actually executes, but I am pretty darn sure that the assumption you have

RE: [ACFUG Discuss] Query or Stored Proc calling

2010-02-04 Thread Charlie Arehart
] On Behalf Of Charlie Arehart Sent: Thursday, February 04, 2010 10:12 AM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] Query or Stored Proc calling Ajas, given your experience with CF, I'm a little confused how to reply. If this was a brand new user, I'd say that they have things backward

[ACFUG Discuss] Query or Stored Proc calling

2010-02-03 Thread Ajas Mohammed
Hi, I came across code like this cfquery name=getSomething datasource=test select col1,col2,col3 from tbl where condition /cfquery Now, instead of using cfoutput query=getSomething col1 br / col2 br / col3 br / /cfoutput, the code uses cfoutputgetSomething.col1 br / getSomething.col2 br /