>YO! 2005 + > >USE OUTPUT Duh! Yes, if needed, OUTPUT is an option as well. (Though IIRC it does not work with the jTDS driver. At least not the last time I checked.) However, the primary point was there are safer alternatives to SELECT MAX(ID) ..
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333217 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm