Quite, and using semi-colons did not help in this case. With all the drivers, using the 'result' attribute worked for getting the newly created id. However, I implemented the BEGIN... END syntax as it was the cleanest and quickest to implement without introducing bugs - having no budget for the extensive testing requirement created :~(
It's definitely an interesting area as I don't think the choice of driver is arbritary. Certainly not in our case where heap memory usage is dropping from an average 800-1000 Mb with the CF shipped driver to around 300Mb with the jTDS driver. Youch. This is on CF 8.0.1 Dominic On 1 February 2010 20:25, Leigh <[email protected]> wrote: > > > I'm just curious: don't you need to separate the statements > > with semicolons? > > I do not think it is technically required with SQL Server. Though it may be > in the ANSI specs. In which case, it is probably not a bad idea to use them. > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:330332 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
