Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.
I am the chief technical officer at InVision App, Inc - a prototyping and collaboration platform for designers, built by designers. I also rock out in JavaScript and ColdFusion 24x7.
Meanwhile on Twitter
Loading latest tweet...
Ben Nadel at cf.Objective() 2014 (Bloomington, MN) with: Jeff McDowell and Jonathan Dowdle and Joel Hill and Josh Siok and Christian Ready and Steve 'Cutter' Blades

Joop Kaashoek

Member since Dec 11, 2008

Recent Blog Comments By Joop Kaashoek

  • Running ColdFusion Queries Inside CFSript Tags

    Posted on Apr 27, 2008 at 1:36 PM

    The be exact, the longer sample does close the connect with the statement: objConnection.Close(); So it works OK. But again,using a <CFQUERY> is must easier. Regards, Joop... read more »

  • Running ColdFusion Queries Inside CFSript Tags

    Posted on Apr 27, 2008 at 1:13 PM

    @Ben, Coldfusion does connection pooling so it would reuse a connection for other queries. Whereas the sample does not reuse the connections, it keeps opening new ones until the underlying datasource runs out, as I found out by trial and error. Regards, Joop... read more »

  • Running ColdFusion Queries Inside CFSript Tags

    Posted on Apr 26, 2008 at 1:23 PM

    Interesting code. You might want to mention that the one liner does not close the connection so the application can eventually run out of connections. And luckily you can manipulate a query that is created with CFQUERY, in CFSCRIPT. So there should be no need to use this code to run queries. Regard... read more »