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=lists&body=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.
