> So in CF 4 they transfered the query to a JDBC statement?
No, ODBC also supports prepared statements with bind parameters.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
phone: 202-797-5496
fax: 202-797-5444
~|
Dave,
So in CF 4 they transfered the query to a JDBC statement?
On Fri, 22 Oct 2004 19:47:54 -0400, Dave Watts <[EMAIL PROTECTED]> wrote:
> > I'd assume that is something that started at a certain version
> > of CF?
>
> It started when the CFQUERYPARAM tag was added to CF - CF 4, I think.
>
> I'd assume that is something that started at a certain version
> of CF?
It started when the CFQUERYPARAM tag was added to CF - CF 4, I think.
> Does it take just one cfqueryparam in the statement for that
> to happen? Such as a insert statement with two columns, one
> of which has a cfquer
Mark thanks for the posting.
The article makes a couple of good points but does it does not dismiss
performance gains. The article illustrates using select queries in
unplanned manner.
When a procedure is complied, columns that depend on indexes are
represented in the compile. These indexes be
Uh... did I miss something?
-Mark
-Original Message-
From: Andy Ousterhout [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 19, 2004 9:23 AM
To: CF-Talk
Subject: RE: Execute Query string w CFQUERYPARAM
Nail bitter down to the finish with major lawsuits to follow. Buy stock in
antacid
Nail bitter down to the finish with major lawsuits to follow. Buy stock in
antacid companies.
Andy
-Original Message-
From: Mark A Kruger [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 19, 2004 9:03 AM
To: CF-Talk
Subject: RE: Execute Query string w CFQUERYPARAM
Hey - in regards to
Does the same type of logic apply in Oracle or does it handle SPs
differently than SQL Server?
On Tue, 19 Oct 2004 09:02:30 -0500, Mark A Kruger
<[EMAIL PROTECTED]> wrote:
> Hey - in regards to this topic I found an insiteful article in a Builder.com
> newsletter. Sometimes an SP doesn't give you
.com/
-Mk
-Original Message-
From: Joseph Flanigan [mailto:[EMAIL PROTECTED]
Sent: Monday, October 18, 2004 5:47 PM
To: CF-Talk
Subject: Re: Execute Query string w CFQUERYPARAM
> Why it is better in your opinion to use stored procedures for
insert/update/deletes?
The quick answer i
I'd assume that is something that started at a certain version of CF?
Does it take just one cfqueryparam in the statement for that to
happen? Such as a insert statement with two columns, one of which has
a cfqueryparam and the other is a hard coded value(for whatever
reason).
On Tue, 19 Oct 200
> I am curious do you make a SP for each query need. Meaning for example
do you have a separate SP for inserts that go into table A, B, or C. Or do
you have one single SP that handles all three based upon what is fed into it?
The simple answer is, yes every insert is its own procedure. Yes. e
> Why it is better in your opinion to use stored procedures for
insert/update/deletes?
The quick answer is that stored procedures are pre-complied execution plans.
To run in the database engine, every SQL statement is compiled into
something the database people call execution plans. These plan
> Why it is better in your opinion to use stored procedures for
insert/update/deletes?
The quick answer is that stored procedures are pre-complied execution plans.
To run in the database engine, every SQL statement is compiled into
something the database people call execution plans. These pla
The technique of assigning a SQL query to variable and then resolving the
variable in the cfquery is called the folded string technique. Since
cfqueryparam is a sub-tag of cfquery it cannot be used in a folded string
outside the cfquery. The function of cfqueryparam is to do data type
binding
Thanks, I will check that out - Mine is the Heinekin pattern, so if it
resembles someone else's, just coincidence.
Dan
On Mon, 18 Oct 2004 17:08:39 +0100, Greg Stewart <[EMAIL PROTECTED]> wrote:
> Sounds to me like you are looking at the DAO pattern
> (http://java.sun.com/blueprints/corej2eepatte
Sounds to me like you are looking at the DAO pattern
(http://java.sun.com/blueprints/corej2eepatterns/Patterns/DataAccessObject.html).
Without starting an OO/mach-ii debate or anything like that, you may
want to have a quick look at the Phil Cruz's mach-ii.info site to see
how he implemented the DA
Thanks, that is what it is starting to look like, but defats the
intended purpose which was being able to use this component from any
database comonent and generate the syntax.
Dan
> If you are building up the query using cf logic (and not pulling the bits
> of the query from a db or elsewhere)
Thanks Dina,
Thats what I meant (&). I tried htmlEditFormat and still get an error on the &.
Dan
On Mon, 18 Oct 2004 07:58:49 -0700, Dina Hess <[EMAIL PROTECTED]> wrote:
> try htmleditformat(); and it's ">" not "@gt;"
> - Original Message -
> From: Dan O'Keefe
> To: CF-Talk
>
A blackbox component that I can pass in an array, with field name,
value, and CFSQL type, and have the component return a complete insert
or update statement to be executed.
I am strating to think it cannot be done, and I see Pascal agree's
Thanks,
Dan
On Mon, 18 Oct 2004 15:49:07 +0100, Thomas
I don't think you can build up a string with cfqueryparam and execute it
inside a cfquery tag (check the archives for a definitive answer)
you would need to build some sort of udf's (custom tag pre-cfmx) that
would carry out this sort of thing AFAIK
(I think Issac's onTap does something lik
I'm guessing that this is not possible unless you are willing to write the string to a file and cfinclude it. The "<" problem sounds like a coding issue, and maybe separating the "<" from the "cf" would help with with the parsing, but I couldn't say for sure without looking at your code.
Withou
try htmleditformat(); and it's ">" not "@gt;"
- Original Message -
From: Dan O'Keefe
To: CF-Talk
Sent: Monday, October 18, 2004 7:33 AM
Subject: Execute Query string w CFQUERYPARAM
I have a variable that contains the following:
Insert into tblProducts (product,c_productDesc
You can't build a string to execute within cfquery and use cfqueryparam
at the same time. Build your sql in the cfquery tag itself.
Pascal
> -Original Message-
> From: Dan O'Keefe [mailto:[EMAIL PROTECTED]
> Sent: 18 October 2004 16:34
> To: CF-Talk
> Subject: Execute Query string w CFQUE
On Monday 18 Oct 2004 15:33 pm, Dan O'Keefe wrote:
> I want to execute this string inside a cfquery tag. 1st problem is,
> when I am building the string and looping over an array, if I try to
> use < and > in the string, my string ends up being empty. If I replace
> that with @lt; and @gt;, the str
23 matches
Mail list logo
