RE: FORTA: CFMX - I've never seen anything so unstable in my life (backup please)
Hi Sean!
We actually are talking with you right now - and I mean specifically YOU.
:) - refer to Mark J's e-mail. I'll reiterate what our issue is with the
JDBC Driver.
Using SQL Server 7 there is a way to trick the database into doing several
sql statements - this was suggested by Ben Forta in one of his books. So,
for example, instead of doing:
cfquery
INSERT INTO blarg (a) VALUES ('a')
/cfquery
cfquery
SELECT * FROM blarg
/cfquery
You can write:
cfquery
SET NOCOUNT ON
INSERT INTO blarg (a) VALUES ('a')
SELECT * FROM blarg
SET NOCOUNT OFF
/cfquery
and save a database connection by doing all the sql at once.
We have lots of code that uses this technique. We can't be the only ones as
Ben Forta suggested it, and a lot of people read/listen to Ben.
Also, this technique allows for huge queries where you can mix cf and sql
variables. Which make a re-write to a stored proc really, really hard.
Hmm, that's a very unfair criticism. No products are error-free and
CFMX was *extensively* tested for many months. The QA team accrued a
vast pool of ColdFusion source code to test against and my team was
developing heavy applications in CFMX and working with the product team
That maybe true I apologize for my quick assumption, but we were to be a
beta tester and the paper work took so long to implement that it never
happened, which means many of the errors we have could have been caught long
ago.
-Original Message-
From: Sean A Corfield [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 07, 2002 11:13 AM
To: CF-Talk
Subject: Re: CFMX - I've never seen anything so unstable in my life
On Monday, Oct 7, 2002, at 10:56 US/Pacific, Rob Rohan wrote:
We are porting cf5 to MX and had several sloppy coding errors, as
well as
some full fledged product errors. All in all, when the code is
optimized for
MX - which almost no currently existing cf code is - it runs like a
champ.
Glad to hear it (that it runs like a champ)! It's always good to hear
from a (fairly) satisfied customer :)
It is *very* obvious that the project was pushed out the door without
being
tested well, or at least tested in some sort of large production
environment - probably do to the dropping stock.
Hmm, that's a very unfair criticism. No products are error-free and
CFMX was *extensively* tested for many months. The QA team accrued a
vast pool of ColdFusion source code to test against and my team was
developing heavy applications in CFMX and working with the product team
on resolving issues. CFMX was probably tested more than any previous
version of CF. However, you must bear in mind that CFMX is a complete
rewrite on a new platform - that means there are bound to be *some*
issues that will crop up. Some of these are a natural fall-out of the
transition from C++ to Java and the use of different libraries (for
example, the database access via JDBC).
We are having issues with the JDBC Drivers as well. We have several
messages
into smack-romedia, and we will post when we hear.
Has the Updater helped? Several database issues were addressed in that,
I believe. Please let either Vern or myself know if there are specific
issues we can follow up on for you!
An Architect's View -- http://www.corfield.org/blog/
Macromedia DevCon 2002, October 27-30, Orlando, Florida
Architecting a New Internet Experience
Register today at http://www.macromedia.com/go/devcon2002
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com
RE: FORTA: CFMX - I've never seen anything so unstable in my life (backup please)
Is this made possible by simply placing
SET NOCOUNT ON
inside the CFQUERY
then placing
SET NOCOUNT OFF
just before the /CFQUERY?
Rick
-Original Message-
From: Rob Rohan [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 07, 2002 2:38 PM
To: CF-Talk
Subject: RE: FORTA: CFMX - I've never seen anything so unstable in my
life (backup please)
Hi Sean!
We actually are talking with you right now - and I mean specifically YOU.
:) - refer to Mark J's e-mail. I'll reiterate what our issue is with the
JDBC Driver.
Using SQL Server 7 there is a way to trick the database into doing several
sql statements - this was suggested by Ben Forta in one of his books. So,
for example, instead of doing:
cfquery
INSERT INTO blarg (a) VALUES ('a')
/cfquery
cfquery
SELECT * FROM blarg
/cfquery
You can write:
cfquery
SET NOCOUNT ON
INSERT INTO blarg (a) VALUES ('a')
SELECT * FROM blarg
SET NOCOUNT OFF
/cfquery
and save a database connection by doing all the sql at once.
We have lots of code that uses this technique. We can't be the only ones as
Ben Forta suggested it, and a lot of people read/listen to Ben.
Also, this technique allows for huge queries where you can mix cf and sql
variables. Which make a re-write to a stored proc really, really hard.
Hmm, that's a very unfair criticism. No products are error-free and
CFMX was *extensively* tested for many months. The QA team accrued a
vast pool of ColdFusion source code to test against and my team was
developing heavy applications in CFMX and working with the product team
That maybe true I apologize for my quick assumption, but we were to be a
beta tester and the paper work took so long to implement that it never
happened, which means many of the errors we have could have been caught long
ago.
-Original Message-
From: Sean A Corfield [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 07, 2002 11:13 AM
To: CF-Talk
Subject: Re: CFMX - I've never seen anything so unstable in my life
On Monday, Oct 7, 2002, at 10:56 US/Pacific, Rob Rohan wrote:
We are porting cf5 to MX and had several sloppy coding errors, as
well as
some full fledged product errors. All in all, when the code is
optimized for
MX - which almost no currently existing cf code is - it runs like a
champ.
Glad to hear it (that it runs like a champ)! It's always good to hear
from a (fairly) satisfied customer :)
It is *very* obvious that the project was pushed out the door without
being
tested well, or at least tested in some sort of large production
environment - probably do to the dropping stock.
Hmm, that's a very unfair criticism. No products are error-free and
CFMX was *extensively* tested for many months. The QA team accrued a
vast pool of ColdFusion source code to test against and my team was
developing heavy applications in CFMX and working with the product team
on resolving issues. CFMX was probably tested more than any previous
version of CF. However, you must bear in mind that CFMX is a complete
rewrite on a new platform - that means there are bound to be *some*
issues that will crop up. Some of these are a natural fall-out of the
transition from C++ to Java and the use of different libraries (for
example, the database access via JDBC).
We are having issues with the JDBC Drivers as well. We have several
messages
into smack-romedia, and we will post when we hear.
Has the Updater helped? Several database issues were addressed in that,
I believe. Please let either Vern or myself know if there are specific
issues we can follow up on for you!
An Architect's View -- http://www.corfield.org/blog/
Macromedia DevCon 2002, October 27-30, Orlando, Florida
Architecting a New Internet Experience
Register today at http://www.macromedia.com/go/devcon2002
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com
RE: FORTA: CFMX - I've never seen anything so unstable in my life (backup please)
Yes - you have to be using SQL Server. The only catch is you can have only
ONE select statement, often at the end of the query. In other words you can
only return one record set.
But you might want to hold of using it apparently.
-Original Message-
From: Rick Faircloth [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 07, 2002 12:14 PM
To: CF-Talk
Subject: RE: FORTA: CFMX - I've never seen anything so unstable in my
life (backup please)
Is this made possible by simply placing
SET NOCOUNT ON
inside the CFQUERY
then placing
SET NOCOUNT OFF
just before the /CFQUERY?
Rick
-Original Message-
From: Rob Rohan [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 07, 2002 2:38 PM
To: CF-Talk
Subject: RE: FORTA: CFMX - I've never seen anything so unstable in my
life (backup please)
Hi Sean!
We actually are talking with you right now - and I mean specifically YOU.
:) - refer to Mark J's e-mail. I'll reiterate what our issue is with the
JDBC Driver.
Using SQL Server 7 there is a way to trick the database into doing several
sql statements - this was suggested by Ben Forta in one of his books. So,
for example, instead of doing:
cfquery
INSERT INTO blarg (a) VALUES ('a')
/cfquery
cfquery
SELECT * FROM blarg
/cfquery
You can write:
cfquery
SET NOCOUNT ON
INSERT INTO blarg (a) VALUES ('a')
SELECT * FROM blarg
SET NOCOUNT OFF
/cfquery
and save a database connection by doing all the sql at once.
We have lots of code that uses this technique. We can't be the only ones as
Ben Forta suggested it, and a lot of people read/listen to Ben.
Also, this technique allows for huge queries where you can mix cf and sql
variables. Which make a re-write to a stored proc really, really hard.
Hmm, that's a very unfair criticism. No products are error-free and
CFMX was *extensively* tested for many months. The QA team accrued a
vast pool of ColdFusion source code to test against and my team was
developing heavy applications in CFMX and working with the product team
That maybe true I apologize for my quick assumption, but we were to be a
beta tester and the paper work took so long to implement that it never
happened, which means many of the errors we have could have been caught long
ago.
-Original Message-
From: Sean A Corfield [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 07, 2002 11:13 AM
To: CF-Talk
Subject: Re: CFMX - I've never seen anything so unstable in my life
On Monday, Oct 7, 2002, at 10:56 US/Pacific, Rob Rohan wrote:
We are porting cf5 to MX and had several sloppy coding errors, as
well as
some full fledged product errors. All in all, when the code is
optimized for
MX - which almost no currently existing cf code is - it runs like a
champ.
Glad to hear it (that it runs like a champ)! It's always good to hear
from a (fairly) satisfied customer :)
It is *very* obvious that the project was pushed out the door without
being
tested well, or at least tested in some sort of large production
environment - probably do to the dropping stock.
Hmm, that's a very unfair criticism. No products are error-free and
CFMX was *extensively* tested for many months. The QA team accrued a
vast pool of ColdFusion source code to test against and my team was
developing heavy applications in CFMX and working with the product team
on resolving issues. CFMX was probably tested more than any previous
version of CF. However, you must bear in mind that CFMX is a complete
rewrite on a new platform - that means there are bound to be *some*
issues that will crop up. Some of these are a natural fall-out of the
transition from C++ to Java and the use of different libraries (for
example, the database access via JDBC).
We are having issues with the JDBC Drivers as well. We have several
messages
into smack-romedia, and we will post when we hear.
Has the Updater helped? Several database issues were addressed in that,
I believe. Please let either Vern or myself know if there are specific
issues we can follow up on for you!
An Architect's View -- http://www.corfield.org/blog/
Macromedia DevCon 2002, October 27-30, Orlando, Florida
Architecting a New Internet Experience
Register today at http://www.macromedia.com/go/devcon2002
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: FORTA: CFMX - I've never seen anything so unstable in my life (backup please)
On Monday, Oct 7, 2002, at 11:37 US/Pacific, Rob Rohan wrote: We actually are talking with you right now - and I mean specifically YOU. :) - refer to Mark J's e-mail. I'll reiterate what our issue is with the JDBC Driver. Ah, I didn't connect Rob Rohan with [EMAIL PROTECTED] in Mark's Cc: list! :) Using SQL Server 7 there is a way to trick the database into doing several sql statements - this was suggested by Ben Forta in one of his books. Hmm, I wonder what Ben will have to say about that? Mr Forta, where are you? Actually, I believe he's 'en route' at the moment since he'll be in SF this week. I'm meeting up with him tomorrow morning so we'll chat about this interesting practice. That maybe true I apologize for my quick assumption, but we were to be a beta tester and the paper work took so long to implement that it never happened, which means many of the errors we have could have been caught long ago. Well, yes, but to be fair, you were not part of the beta program through the normal channels and I'm very sorry that we were not able to get you added to the program 'manually' after the fact. However, this is probably not a discussion for cf-talk :) An Architect's View -- http://www.corfield.org/blog/ Macromedia DevCon 2002, October 27-30, Orlando, Florida Architecting a New Internet Experience Register today at http://www.macromedia.com/go/devcon2002 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: FORTA: CFMX - I've never seen anything so unstable in my life (backup please)
:) Tell Ben I said hi. Thanks for your help Sean, Rob -Original Message- From: Sean A Corfield [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 12:12 PM To: CF-Talk Subject: Re: FORTA: CFMX - I've never seen anything so unstable in my life (backup please) On Monday, Oct 7, 2002, at 11:37 US/Pacific, Rob Rohan wrote: We actually are talking with you right now - and I mean specifically YOU. :) - refer to Mark J's e-mail. I'll reiterate what our issue is with the JDBC Driver. Ah, I didn't connect Rob Rohan with [EMAIL PROTECTED] in Mark's Cc: list! :) Using SQL Server 7 there is a way to trick the database into doing several sql statements - this was suggested by Ben Forta in one of his books. Hmm, I wonder what Ben will have to say about that? Mr Forta, where are you? Actually, I believe he's 'en route' at the moment since he'll be in SF this week. I'm meeting up with him tomorrow morning so we'll chat about this interesting practice. That maybe true I apologize for my quick assumption, but we were to be a beta tester and the paper work took so long to implement that it never happened, which means many of the errors we have could have been caught long ago. Well, yes, but to be fair, you were not part of the beta program through the normal channels and I'm very sorry that we were not able to get you added to the program 'manually' after the fact. However, this is probably not a discussion for cf-talk :) An Architect's View -- http://www.corfield.org/blog/ Macromedia DevCon 2002, October 27-30, Orlando, Florida Architecting a New Internet Experience Register today at http://www.macromedia.com/go/devcon2002 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: FORTA: CFMX - I've never seen anything so unstable in my life (backup please)
FYI this is also a handy way to do an INSERT into a table and then get the
identity field value of that insert...
cfquery name=queryname
set nocount on
(your INSERT call here)
select varname = @@identity
set nocount off
/cfquery
My new ID is #queryname.varname#
Works great.
--Scott
At 03:13 PM 10/7/2002 -0400, you wrote:
Is this made possible by simply placing
SET NOCOUNT ON
inside the CFQUERY
then placing
SET NOCOUNT OFF
just before the /CFQUERY?
Rick
-Original Message-
From: Rob Rohan [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 07, 2002 2:38 PM
To: CF-Talk
Subject: RE: FORTA: CFMX - I've never seen anything so unstable in my
life (backup please)
Hi Sean!
We actually are talking with you right now - and I mean specifically YOU.
:) - refer to Mark J's e-mail. I'll reiterate what our issue is with the
JDBC Driver.
Using SQL Server 7 there is a way to trick the database into doing several
sql statements - this was suggested by Ben Forta in one of his books. So,
for example, instead of doing:
cfquery
INSERT INTO blarg (a) VALUES ('a')
/cfquery
cfquery
SELECT * FROM blarg
/cfquery
You can write:
cfquery
SET NOCOUNT ON
INSERT INTO blarg (a) VALUES ('a')
SELECT * FROM blarg
SET NOCOUNT OFF
/cfquery
and save a database connection by doing all the sql at once.
We have lots of code that uses this technique. We can't be the only ones as
Ben Forta suggested it, and a lot of people read/listen to Ben.
Also, this technique allows for huge queries where you can mix cf and sql
variables. Which make a re-write to a stored proc really, really hard.
Hmm, that's a very unfair criticism. No products are error-free and
CFMX was *extensively* tested for many months. The QA team accrued a
vast pool of ColdFusion source code to test against and my team was
developing heavy applications in CFMX and working with the product team
That maybe true I apologize for my quick assumption, but we were to be a
beta tester and the paper work took so long to implement that it never
happened, which means many of the errors we have could have been caught long
ago.
-Original Message-
From: Sean A Corfield [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 07, 2002 11:13 AM
To: CF-Talk
Subject: Re: CFMX - I've never seen anything so unstable in my life
On Monday, Oct 7, 2002, at 10:56 US/Pacific, Rob Rohan wrote:
We are porting cf5 to MX and had several sloppy coding errors, as
well as
some full fledged product errors. All in all, when the code is
optimized for
MX - which almost no currently existing cf code is - it runs like a
champ.
Glad to hear it (that it runs like a champ)! It's always good to hear
from a (fairly) satisfied customer :)
It is *very* obvious that the project was pushed out the door without
being
tested well, or at least tested in some sort of large production
environment - probably do to the dropping stock.
Hmm, that's a very unfair criticism. No products are error-free and
CFMX was *extensively* tested for many months. The QA team accrued a
vast pool of ColdFusion source code to test against and my team was
developing heavy applications in CFMX and working with the product team
on resolving issues. CFMX was probably tested more than any previous
version of CF. However, you must bear in mind that CFMX is a complete
rewrite on a new platform - that means there are bound to be *some*
issues that will crop up. Some of these are a natural fall-out of the
transition from C++ to Java and the use of different libraries (for
example, the database access via JDBC).
We are having issues with the JDBC Drivers as well. We have several
messages
into smack-romedia, and we will post when we hear.
Has the Updater helped? Several database issues were addressed in that,
I believe. Please let either Vern or myself know if there are specific
issues we can follow up on for you!
An Architect's View -- http://www.corfield.org/blog/
Macromedia DevCon 2002, October 27-30, Orlando, Florida
Architecting a New Internet Experience
Register today at http://www.macromedia.com/go/devcon2002
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
