> Years ago i picked up a way of returning the value > inserted into an > Identity column in SQL server, by adding a trigger to that > table:
<snip> > Its worked from CF4 to CFMX7, but barfs with the > DataDirect 3.4 > drivers: the insert happens, but JRun sits at 50%. > Does that mean there's a bug with the driver, or something > wrong with my code? I believe the fact that the trigger returns data to the calling page is sort of "incidental" ... it can happen, but I don't think the standard says anything about whether it should or not... Being that's the case, and that as a rule of thumb returning data isn't the purpose of triggers (whether or not they do), I would imagine that using a trigger to return data is a risky proposition that's liable to only work in a certain narrow set of conditions (certain database servers and a particular sub-set of drivers). Hell, for that matter there was a time when CFMX couldn't return a query from a SQL Server stored procedure if the procedure was written in-line in a cfquery (instead of cfstoredproc - it may still fail with some drivers), and that's a SQL construct that IS designed to return data. s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:212305 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
