> Give me an example of exactly what I should do and I will do it.
I don't know how this should look in CFML but I will give you the equivalent
Java code; I think it won't be hard for you to figure out what I mean. Here
goes:
Statement stmt = conn.createStatement();
for (int i = 0; i < 100; i++) {
ResultSet rs = stmt.executeQuery("Select * From Users");
// This is where you stopped processing. In any real world application
// some processing on the selected data should follow. Also, selecting
// a single INT field might not be totally relevant.
// Now do the processing
String res = rs.getString("userId") + rs.getString("userName")
+ rs.getTimestamp("lastLogin") + ...;
}
> The reason I didn't do anything other than a select was that my view
> was that ColdFusion then has the result set so there would be no more
> use from the SQL server. I do everything in stored procedures, how are
> the results when using the driver for that?
The idea is that ColdFusion has indeed the ResultSet but it doesn't do anything
with it. It simply calls ResultSet.close(). Now different drivers might choose
to drop the remaining data in different ways; jTDS processes it completely
(which is not necessarily the best idea, but as I said it should not be a
problem in real world applications, which don't just select a huge amount of
data to ignore it).
Alin.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191831
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
