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
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
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
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
-
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
, 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
13 matches
Mail list logo
