Community Member Profile
- Profile: /members/772-Joop-Kaashoek.htm
- Comments: 3
- Points: 1
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. <... read more »
