OK, ok. :-)
/Charlie
http://www.carehart.org/blog/
-Original Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Andrew Scott
Sent: Monday, March 05, 2007 9:14 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: CFQUERYPARAM was RE: [cfaussie] Re
presentation.
/Charlie
http://www.carehart.org/blog/
-Original Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Duncan
Sent: Sunday, March 04, 2007 6:24 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: CFQUERYPARAM was RE: [cfaussie] Re: @#$!! queryparam
@googlegroups.com
Subject: [cfaussie] Re: @#$!! queryparam
We are not caching any templates.
In CFAdmin there are no cached templates, trusted cache or saving of class
files.
We are not using a framework, its as simple as putting a cfquery into a .cfm
page and running it directly in the browser.
It is only
PROTECTED] On Behalf
Of Andrew Scott
Sent: Sunday, March 04, 2007 7:03 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: CFQUERYPARAM was RE: [cfaussie] Re: @#$!! queryparam
Acually not sure, but the problem Duncan was having was suggested my
Macromedia so that shows you it is a known problem
://www.carehart.org/blog/
-Original Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Duncan
Sent: Thursday, March 01, 2007 10:21 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: @#$!! queryparam
Charlie,
I didnt think that would be affecting it, I
Charlie,
Cheers for the info, but I wasn't confusing anything. I was asking to begin
with.
And with select * from when using cfqueryparam, I only am reporting what is
reported as a solution on the Adobe livedocs.
Gosh:-)
Andrew Scott
Senior Coldfusion Developer
Aegeon Pty. Ltd.
Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Charlie Arehart
Sent: Tuesday, 6 March 2007 9:03 AM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: CFQUERYPARAM was RE: [cfaussie] Re: @#$!! queryparam
Well, I know I just wrote my last note so you can't
Most database (including SQLServer) presume that the database structure does
not change between re-uses of parameterized queries.
What a strange presumption for them to make! Sure, table-schema
updates are rare compared to table-queries, but it's not like the DB
doesn't *know* when the table
Oracle does behave like this - actually to the point where you can't add new
tables and then run parametrised queries on them within the same session (I
believe it is session related).
Databases weren't designed to dynamically updated at runtime, and never have
been - so you will end up hitting
Databases weren't designed to dynamically updated at runtime, and never have
been - so you will end up hitting brick walls there.
Can you explain to me what you mean by runtime, in the context of a
DB engine? In such a way that distinguishes between me using CF as a
DB client or using Query
http://www.carehart.org/blog/
-Original Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On
Behalf
Of Duncan
Sent: Thursday, March 01, 2007 10:21 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: @#$!! queryparam
Charlie,
I didnt think
[mailto:cfaussie@googlegroups.com
mailto:cfaussie@googlegroups.com] On Behalf
Of Duncan
Sent: Thursday, March 01, 2007 10:21 PM
To: cfaussie@googlegroups.com mailto:cfaussie@googlegroups.com
Subject: [cfaussie] Re: @#$!! queryparam
Charlie
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: Why select * is bad (was RE: [cfaussie] Re: @#$!!
Queryparam)
I am a SELECT * user.
(In my defence, I'm self-taught and didn't know any better until now)
My question... is there a trick or tip or tool that you guys use to save
typing
Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Andrew Scott
Sent: Monday, March 05, 2007 6:15 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: CFQUERYPARAM was RE: [cfaussie] Re: @#$!! queryparam
Charlie,
The link is
http://livedocs.adobe.com/coldfusion/6.1
: +613 8676 4223
Mobile: 0404 998 273
-Original Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Charlie Arehart
Sent: Tuesday, 6 March 2007 1:07 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: CFQUERYPARAM was RE: [cfaussie] Re: @#$!! queryparam
, and I'm a Select * user. :-)
/Charlie
http://www.carehart.org/blog/
_
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Tom MacKean
Sent: Monday, March 05, 2007 7:48 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: Why select * is bad (was RE: [cfaussie] Re
@googlegroups.com
[mailto:cfaussie@googlegroups.com mailto:cfaussie@googlegroups.com]
On Behalf
Of Duncan
Sent: Thursday, March 01, 2007 10:21 PM
To: cfaussie@googlegroups.com mailto:cfaussie@googlegroups.com
Subject: [cfaussie] Re: @#$!! queryparam
Charlie,
I didnt think that would
*To:* cfaussie@googlegroups.com
*Subject:* [cfaussie] Re: Why select * is bad (was RE: [cfaussie] Re:
@#$!! Queryparam)
I am a SELECT * user.
(In my defence, I'm self-taught and didn't know any better until now)
My question... is there a trick or tip or tool that you guys use to save
typing
(was RE: [cfaussie] Re: @#$!!
Queryparam)
Thanks Charlie,
I'm alternating between Dreamweaver and Eclipse at the moment, depending on
the project. Since my original post, I found a button in MySQL Manager
(http://www.mysqlmanager.com/ ) that copies all field names to clipboard.
Reasonably easy
@googlegroups.com
Subject: [cfaussie] Re: Why select * is bad (was RE:
[cfaussie] Re:
@#$!! Queryparam)
Thanks Charlie,
I'm alternating between Dreamweaver and Eclipse
at the
moment, depending on the project. Since my original post, I found a
button in
MySQL Manager
Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Andrew Scott
Sent: Thursday, March 01, 2007 10:08 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: @#$!! queryparam
The suggestions I had mentioned, I didn't think of Trusted Cache but I never
have
-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Charlie Arehart
Sent: Saturday, 3 March 2007 3:44 AM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: CFQUERYPARAM was RE: [cfaussie] Re: @#$!! queryparam
Andrew, I didn't say anything about SPs, nor did I
Duncan,
But the Admin says Cached Queries so I am going to guess its CF, just wanted
to make sure I was right on my assumption. And if you read my post, hey
Charlie (yells out) correct me you seem to know.. If you set this setting to
zero, there will be no caching and no performance gain.
So I
I think CF would only cache the queries if cachedafter= or cachedwithin=
was used.
Andrew Scott [EMAIL PROTECTED] 05/03/2007 10:38 am
Duncan,
But the Admin says Cached Queries so I am going to guess its CF, just wanted
to make sure I was right on my assumption. And if you read my post, hey
, 5 March 2007 11:01 AM
To: cfaussie@googlegroups.com
Subject: [cfaussie] CFQUERYPARAM was RE: [cfaussie] Re: @#$!! queryparam
I think CF would only cache the queries if cachedafter= or cachedwithin=
was used.
Andrew Scott [EMAIL PROTECTED] 05/03/2007 10:38 am
Duncan,
But the Admin says
] On Behalf
Of Duncan
Sent: Monday, 5 March 2007 8:47 AM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: @#$!! queryparam
We are not caching any templates.
In CFAdmin there are no cached templates, trusted cache or saving of
class files.
We are not using a framework, its as simple
through all the available info to decide best for
yourself. :-)
/Charlie
http://www.carehart.org/blog/
-Original Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Duncan
Sent: Thursday, March 01, 2007 10:21 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re
: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Andrew Scott
Sent: Thursday, March 01, 2007 10:42 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: @#$!! queryparam
Charlie,
I did a bit of research into cfqueryparam to see what you meant by ther
performance but it is only
Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Andrew Scott
Sent: Thursday, March 01, 2007 10:08 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: @#$!! queryparam
The suggestions I had mentioned, I didn't think of Trusted Cache but I never
have
PROTECTED] On
Behalf
Of Duncan
Sent: Thursday, March 01, 2007 10:21 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: @#$!! queryparam
Charlie,
I didnt think that would be affecting it, I am more than aware that its
bad
practice, and as it happens the queries in question do have
Duncan,
The query is only cached when you tell it to be cached. But are you using
any other framework like reactor or transfer or even MG:U, or even have this
in a cfc that might be stored in a session or application scope.
One other thing I would like to point out that a lot of people do not
Scott,
Well although I know what you said, I see no reason to add overhead to my
application to provide a stop measure for SQL injection when I have already
taken care of it before my code ever reaches there in a cffunction. As far
as making sure it is an integer instead of numeric, I couldn't
I should add to this that the queries are not using any caching, they
are not in a cfc, and are not loaded into any scopes like the
application. Simple, inline, straightforward queries.
On 3/2/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
Scott - thats precisely why we use cfqueryparam - and
@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Andrew Scott
Sent: Thursday, March 01, 2007 7:58 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: @#$!! queryparam
Duncan,
The query is only cached when you tell it to be cached. But are you using
any other framework like reactor
: Thursday, March 01, 2007 10:01 PM
To: cfaussie
Subject: [cfaussie] Re: @#$!! queryparam
Scott - thats precisely why we use cfqueryparam - and the performance
increase is marked, especially on inserts. There is a performance hit on the
first time the query is put together, but after that you save
Subject: [cfaussie] Re: @#$!! queryparam
Scott - thats precisely why we use cfqueryparam - and the performance
increase is marked, especially on inserts. There is a performance hit
on the first time the query is put together, but after that you save
time.
Andrew - I thought the cached templates
Did you delete any cached templates in the CFIDE folder?
On 02/03/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
Scott - thats precisely why we use cfqueryparam - and the performance
increase is marked, especially on inserts. There is a performance hit
on the first time the query is put
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: @#$!! queryparam
Duncan,
The query is only cached when you tell it to be cached. But are you using
any other framework like reactor or transfer or even MG:U, or even have this
in a cfc that might be stored in a session or application scope.
One
38 matches
Mail list logo
