<cfscript>
factory = createObject( "java", "coldfusion.server.ServiceFactory" );
ds = factory.getDataSourceService().getDatasource( "dsn" );
conn = ds.getConnection();
stmt = conn.createStatement();
stmt.execute( "select * from A; select * from B" );
rs = stmt.getResultSet();
while( rs.next() ) {
writeOutput(rs.getString( "tableAcolumn" )& '<br>');
}
if( stmt.getMoreResults() ) {
rs = stmt.getResultSet();
}
while( rs.next() ) {
writeOutput( rs.getString( "tableBcolumn" ) & '<br/>' );
}
rs.close();
stmt.close();
conn.close();
</cfscript>
> I have a situation that could be implemented in two different ways and
> looking to see which situation would be best:
> I have 3 result sets that i need to obtain...i could query the
> database 3 times to obtain each one or query the database once and
> then filter the result in cf using cfquery...in the long run is the
> cfquery slower at filtering than querying the db 3 times? lets say we
> would be dealing with 300-500 records in total.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble
Ticket application
http://www.houseoffusion.com/banners/view.cfm?bannerid=48
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201943
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
